ªð¦^¦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 : ¡i®É¤é²öªÅ¹L¡j¤@­Ó¤H¦b¥@¶¡°µ¤F¦h¤Ö¨Æ¡A´Nµ¥©ó¹Ø©R¦³¦hªø¡C¦]¦¹¥²¶·»P®É¶¡Ävª§¡A¤Á²ö¨Ï®É¤éªÅ¹L¡C
ªð¦^¦Cªí ¤W¤@¥DÃD