ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] Åã¥Ü¦P¦C¤§³Ì¤j¼Æ¦r

[µo°Ý] Åã¥Ü¦P¦C¤§³Ì¤j¼Æ¦r



·Q°Ý¦p¦ó¥i¥HÅã¥Ü¥X¦P¦C¤§³Ì¤j¼Æ¦r
¦pªG¦³¬Û¦P¼Æ¥Øªº¼Æ¦r
³£·|¦P®ÉÅã¥Ü¥X¨Ó

­×¥¿¤@¤U
¥¿½T¨Ó»¡¬OÅã¥Ü¦P¦C¤§³Ì¦h¼Æ¦r
¦pªG¦P¦C³Ì¦h¼Æ¦r¦P®É¥X²{¬Û¦P¼Æ¶q(¦h©ó¤@­Ó¼Æ¦r)
¤]»Ý­n¦P®ÉÅã¥Ü¸Ó¨Ç³Ì¦h¼Æ¶q¤§¼Æ¦r
ÁÂÁÂ

TOP

¥»©«³Ì«á¥Ñ zz5151353 ©ó 2017-6-28 08:28 ½s¿è

¼È®É¥ý´£¨Ñ¤@²Â¤èªk¡AÁÙ¨S¦³·Q¨ì§ó²µuªº¤èªk¡C

B13 ¤U©ì©Ô¤Î¥k©ì©Ô
{=IF(COUNTIF(B$1:B$12,MODE(IF(B$1:B$12=$A13,B$1:B$12)))=COUNTIF(B$1:B$12,MODE(B$1:B$12)),IF(MODE(IF(B$1:B$12=$A13,B$1:B$12))=$A13,$A13,""),"")}
300 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

B13=IF(COUNTIF(B$1:B$12,$A13)=MAX(COUNTIF(B$1:B$12,$A$13:$A$21)),$A13,"")
ctrl+shift+enter

TOP

B13=IF(COUNTIF(B$1:B$12,$A13)=MAX(COUNTIF(B$1:B$12,$A$13A$21)),$A13,"")
ctrl+shift+enter
fengetianxia µoªí©ó 2017-6-28 09:45


Æg¡A¤@»yÂI¿ô¹Ú¤¤¤H
300 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

http://blog.xuite.net/hcm19522/twblog/515709991
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 3# zz5151353
¦^´_ 4# fengetianxia
¦^´_ 6# hcm19522
¥ý·PÁ¤T¦ì¥S§Ì´£¨Ñ¤èªk
µy«á·|§@¥X´ú¸Õ
¦A¨M©w¿ï¨ú¦X¾A§Ú»Ý¨Dªº¤½¦¡

TOP

¥»©«³Ì«á¥Ñ K_Wing ©ó 2017-7-6 01:07 ½s¿è

¦^´_ 3# zz5151353
¦^´_ 4# fengetianxia
¦^´_ 6# hcm19522
·Q¦A½Ð±Ð´X¦ì
¦P¤@°ÝÃD§ä³Ì¦h¤§¼Æ­È
¦pªG±N·j´M½d³ò
§ïÅܬ°B1:G12
(¤£¬O¨C¦C¡A¦Ó¬O¾ã­Ó½d³ò¡^
¤½¦¡¤S·|¬O«ç»ò¼Ë©O?

TOP

B13=IF(COUNTIF(B$1:G$12,$A13)=MAX(COUNTIF(B$1:G$12,$A$13:$A$21)),$A13,"")
ctrl+shift+enter

¤U©Ô

TOP

        ÀR«ä¦Û¦b : ¤â¤ß¦V¤U¬O§U¤H¡A¤â¤ß¦V¤W¬O¨D¤H¡F§U¤H§Ö¼Ö¡A¨D¤Hµh­W¡C
ªð¦^¦Cªí ¤W¤@¥DÃD