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

¦^¶Ç¦³­ÈªºÀx¦s®æÀ³¹ï²Ä¤@¦Cªº¸ê®Æ

ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 3# wei9133

2003ª©µLIFERROR
COLUMN(A:G)-->1~6   
SMALL(IF($C2:$I2,COLUMN($A:$G)-->$C2:$I2 C¦X¥G±ø¥ó¬°1   I¦X¥G±ø¥ó¬°6
¦X¥G±ø¥ó¨ú¦ì¸m­È «D­pºâ   ¤º¤å¬O¼Æ¦r ¤å¦r¡A¤£·|¦³¼vÅT
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

        ÀR«ä¦Û¦b : ¦³´¼¼z¤~¯à¤À¿ëµ½´c¨¸¥¿¡F¦³Á¾µê¤~¯à«Ø¥ß¬üº¡¤H¥Í¡C
ªð¦^¦Cªí ¤W¤@¥DÃD