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

[µo°Ý] ²Î­p¶µ§t¦³¤å¦r

¥»©«³Ì«á¥Ñ hcm19522 ©ó 2021-10-7 14:48 ½s¿è

B5 ¥k©Ô ¤U©Ô {=IFERROR(INDEX(1:1,RIGHT(SMALL(IF($B$2:$AE$2<>"",IF($B$2:$AE$2="¸É³f¤¤",99,$B$2:$AE$2)/1%+COLUMN($B:$AE)),COLUMN(A1)),2)),"")

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

TOP

        ÀR«ä¦Û¦b : §ïÅܦۤv¬O¦Û±Ï¡A¼vÅT§O¤H¬O±Ï¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD