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

[µo°Ý] EXCEL¦p¦ó±a¤J¸ê®Æ

[µo°Ý] EXCEL¦p¦ó±a¤J¸ê®Æ

¬ã¨sEXCELªí³æ  Àµ½Ð¤j¤j«ü¾É
¦p¦ó¦b¸g¾P°ÓÄæ¦ì¥´¤J¸ê®Æ«á ¦Û°Ê¦C¥XÁpµ¸¤H    ³sµ¸¹q¸Ü    °e³f¦a§}         ¨Ã¹ï·Ó¾÷«¬ ¦p¸Ó©±±H®w¤º¦³³f  ¦Û°Ê¤Ä¿ï "±H®w¥X³f" ¦pµL³f´N¦Û°Ê¤Ä¿ï"®Ö©w¥X³f"
¥ýÁÂÁ¤F^^

¥X³f³qª¾³æ.zip (8.11 KB)

¤p§Ì¤£¤~¡A¨Ì©Òª¾´£¨Ñ·N¨£
±zÀ³¸ÓÁÙ·|¦³¨â­Ó³øªí¡A1. ¸g¾P°Ó¸ê®Æ©ú²Óªí  2. ¸g¾P°Ó±H®w©ú²Óªí
®Ú¾Ú¤W­z¤Gªí¥i§Q¥Î¨ç¼ÆVLookup¬d¥X±z©Ò»Ýªº¸ê®Æ¡C
¥H¤W½Ð°Ñ¦Ò

TOP

match + index¤]¥i¥H
ss

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡µLªk¾B¾×¡j©È®É¶¡®ø³u¡Aªá¤F³\¦h¤ß¦å¡A·QºÉ¦U¦¡¤èªk­n¾B¾×®É¶¡¡Aµ²ªG¬O¡G®ö¶O¤F§ó¦h®É¶¡¡A¥B¤@µL©Ò¦¨¡I
ªð¦^¦Cªí ¤W¤@¥DÃD