excelÈçºÎ¼ÆËãÒ»ÁÐÖÐÏàͬÄÚÈݵ¥Ôª¸ñµÄ¸öÊý£¿

ʱ¼ä£º ·¢²¼ÈË£ºpj310

excelÈçºÎ¼ÆËãÒ»ÁÐÖÐÏàͬÄÚÈݵ¥Ôª¸ñµÄ¸öÊý£¿

Òѽâ¾öÎÊÌâ

¹È¸èpj310Óû§ÔÚÌá½»Á˹ØÓÚ¡°ÁéÓòexcelÈçºÎ¼ÆËãÒ»ÁÐÖÐÏàͬÄÚÈݵ¥Ôª¸ñµÄ¸öÊý£¿¡±µÄÌáÎÊ£¬»¶Ó­´ó¼ÒÓ¿Ô¾·¢±í×Ô¼ºµÄ¹Ûµã¡£Ä¿Ç°¹²ÓÐ1¸ö»Ø´ð£¬×îºó¸üÐÂÓÚ2025-01-05T15:45:29¡£Ï£Íû´ó¼ÒÄܹ»°ïÖúËý¡£

ÏêϸÎÊÌâÃèÊö¼°ÒÉÎÊ£ºÆÚ´ýÄúµÄ´ð°¸£¬²»ÖªµÀ˵ʲô,ËÍÄãÒ»¶äСºì»¨°É £¡

Ï£ÍûÒÔϵĻشð£¬Äܹ»°ïÖúÄã¡£

µÚ1¸ö»Ø´ð

Óû§Ãû£ºjiwl9411601  

1¡¢Æô¶¯Excel³ÌÐò£¬²¢ÔÚAÁÐÖÐÌî³äÏàÓ¦µÄ**¡£

2¡¢ÔÚB1µ¥Ôª¸ñÄÚÊäÀ´×ÔÈ빫ʽ£º=COUNTIF(AÎÊ´ð1:A9,A1)£¬¸Ã¹«Ê½ÓÃÓÚͳ¼ÆA1µ½A9·¶Î§ÄÚÓëA1µ¥Ôª¸ñÖµÏàͬµÄ**¸öÊý¡£

3¡¢°´Ï»سµ¼üºó£¬¼´¿É»ñµÃ¼ÆËã½á¹û£¬ÏÔʾÓëA1µ¥Ôª¸ñÏàͬµÄÊýÖ**öÏÖÁË¡°3¡±´Î¡£

4¡¢ÈôÒª¼ÆËãÓëA2µ¥Ôª¸ñÖµÏàͬµÄ¸öÊý£¬Ö»ÐèÔÚÏàÓ¦µ¥Ôª¸ñÊäÈ빫ʽ£º=COUNTIFÖªºÃ(A1:A9,A2)£¬²¢ÒÔ´Ë·½·¨¼ÌÐø½øÐÐͳ¼Æ¡£

5¡¢Í¬ÑùµØ£¬Ö´Ðлسµ²Ù×÷ºó£¬»áµÃµ½ÓëA2µ¥Ôª¸ñÏà±ä¾«ÐíÏ£Çá×¥ÏÖÄØÄêͬµÄÊýÖµÒ²³öÏÖÁË¡°3¡±´ÎµÄ½á¹û¡£