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

½Ð°Ýexcel¤½¦¡¦p¦ó¨q¥X ¥X²{³Ì¦h¦¸¼Æªº¤H¦W?

½Ð°Ýexcel¤½¦¡¦p¦ó¨q¥X ¥X²{³Ì¦h¦¸¼Æªº¤H¦W?

­n¦bcÄ檺owner¨q¥X¨C¤@¦æ¥X²{³Ì¦h¦¸¼Æªº¤H¦Winitial.
¥u»Ý¦Ò¼{E-KÄæ
«ô°UÀ°À°¦£!

test1.zip (5.7 KB)

C6°}¦C¤½¦¡
{=INDEX(E6:K6,,MATCH(MAX(COUNTIF(E6:K6,E6:K6)),COUNTIF(E6:K6,E6:K6),0))}
¦V¤U½Æ»s
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

C6

{=INDEX(E6:K6,MATCH(MODE(COUNTIF(E6:K6,E6:K6)),COUNTIF(E6:K6,E6:K6),))}
300 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

        ÀR«ä¦Û¦b : ¦³¦h¤Ö¤O¶q´N°µ¦h¤Ö¨Æ¡A¤£­n¤ß¦sµ¥«Ý¡Aµ¥«Ý¤~·|¸¨ªÅ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD