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

[µo°Ý] ¦p¦ó§ä¥X²Ä¤@¦W~²Ä¤­¦Wªº®y¸¹¸ò¤À¼Æ

[µo°Ý] ¦p¦ó§ä¥X²Ä¤@¦W~²Ä¤­¦Wªº®y¸¹¸ò¤À¼Æ

½Ð°Ý¤j¤j
­n¦p¦ó§ä¥X²Ä¤@¦W~²Ä¤­¦Wªº®y¸¹¸ò¤À¼Æ??ÁÂÁÂ!
Book1.rar (1.66 KB)

¦^´_ 1# 230211


    C6=LARGE($A$3:$BC$3,ROW(A1))
B6°}¦C¤½¦¡
=SMALL(IF($A$3:$BC$3=C6,COLUMN(A1:BC1),""),COUNTIF($C$5:C6,C6))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦pÆp¥Û¡j®É¶¡¹ï¤@­Ó¦³´¼¼zªº¤H¦Ó¨¥¡A´N¦pÆp¥Û¯ë¬Ã¶Q¡F¦ý¹ï·M¤H¨Ó»¡¡A«o¹³¬O¤@§âªd¤g¡A¤@ÂI»ù­È¤]¨S¦³¡C
ªð¦^¦Cªí ¤W¤@¥DÃD