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

[µo°Ý] ¥i¬Ù²¤»²§U¦Cªº¤½¦¡

[µo°Ý] ¥i¬Ù²¤»²§U¦Cªº¤½¦¡

¥»©«³Ì«á¥Ñ ziv976688 ©ó 2020-12-12 02:54 ½s¿è


¥i¬Ù²¤»²§U¦Cªº¤½¦¡.rar (4.66 KB)
¦C12©M¦C13ªº¤½¦¡¬OÂǦC9©M¦C10ªº¤G»²§U¦C¹F¦¨»Ý¨D¡C

·Q¤£­n¦C9©M¦C10ªº¤G»²§U¦C¡A¦b¦C16©M¦C17§e²{¦p¦C12©M¦C13ªº¬Û¦Pµª®×¡A
¤£ª¾¬O§_¥i¦æ¡H
¦pªG¥i¦æ~
½Ð°Ý¡JB16©MB17ªº¤½¦¡­n¦p¦ó½s¼g¡H
ÁÂÁ¡I

google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 2# hcm19522
h¤j :
±z¤Ó¼F®`¤F~´ú¸Õ¦¨¥\
ÁÂÁ±zªº­@¤ßÀ°¦£~·P®¦

TOP

B16//°}¦C:
=iferror(MODE(ROW($1:$49),IF(ISNA(RANK($B$1:$N$7&"",$A16:A16)),$B$1:$N$7)),"")
B17//¤@¯ë:
=IF(B16="","",COUNTIF($B$1:$N$7,B16))

©Î:2003
B16//°}¦C:
=IF(SUM($A17:A17)=COUNT($B$1:$N$7),"",MODE(ROW($1:$49),IF(ISNA(RANK($B$1:$N$7&"",$A16:A16)),$B$1:$N$7)))

B17//¤@¯ë:
=IF(SUM($A17:A17)=COUNT($B$1:$N$7),"",COUNTIF($B$1:$N$7,B16))

B16:B17 ¨â®æ¦P®É¥k©Ô

TOP

¥»©«³Ì«á¥Ñ ziv976688 ©ó 2020-12-13 10:45 ½s¿è

¦^´_ 4# ­ã´£³¡ªL
ª©¥D¤j¤j :
±z¤]¤Ó¼F®`¤F
ÁÂÁ±zªº¼ö¤ß¬Û§U
¦³2003ª©ªº¤½¦¡¤è«K³\¦h~·P®¦

TOP

        ÀR«ä¦Û¦b : ¦Û¤v®`¦Û¤v¡A²ö¹L©ó¶ÃµoµÊ®ð¡C
ªð¦^¦Cªí ¤W¤@¥DÃD