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

[µo°Ý] ¿é¤J¸ê®Æ«á¦Û°Ê¤ñ¹ï¨Ã¸ü¤J¸ê®Æ°ÝÃD?

[µo°Ý] ¿é¤J¸ê®Æ«á¦Û°Ê¤ñ¹ï¨Ã¸ü¤J¸ê®Æ°ÝÃD?

¿é¤J¸ê®Æ«á¦Û°Ê¤ñ¹ï¨Ã¸ü¤J¸ê®Æ
½Ð°Ý¦U¦ì¤j­ô¦p¦ó³]©w?
¦pªþ¥ó©Ò¥Ü....ÁÂÁÂ

¦Û°Ê¤ñ¹ï¸ü¤J¸ê®Æ.zip (198.15 KB)

¦^´_ 1# jeff5424

    ª¬ºA=VLOOKUP(Y22,IF({1,0},AI20:AI27,AF20:AF27),2,0)
    «È¤á¼t§O=VLOOKUP(Y22,IF({1,0},AI20:AI27,AG20:AG27),2,0)
    ¤Ñ¼Æ=VLOOKUP(Y22,IF({1,0},AI20:AI27,AH20:AH27),2,0)
    ¦ì¸m½Ð¨Ì»Ý¨D½Õ¾ã

TOP

¦X¨Ö®æ¤½¦¡³B²z
blog.xuite.net/hcm19522/twblog/588913564
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

·PÁ¨â¦ì¤j¤j,¸g´ú¸Õ¥i¥¿±`¨Ï¥Î

TOP

EXCEL¬O¸ê®Æªí©Î­pºâªí, ¤£¬O¯Â¤å¦r¥Î³~,
©Ò¥H, ¾¨¶qÁקK¦X¨ÖÀx¦s®æ~~

TOP

¦^´_ 5# ­ã´£³¡ªL
·PÁª©¥D¤j¤j¶K¤ß§iª¾,¤U¦¸§Ú·|ª`·N ÁקK¨Ï¥Î¦X¨ÖÀx¦s®æ
¥t¥~·Q½Ð±Ð¤@­Ó°ÝÃD:
§@·~«È¤á¨S¦³¿é¥X¸ê®Æ,¦Û°Ê¸ü¤J¸ê®Æ·|Åã¥Ü#N/A,
¦p¦ó±N#N/AÅܪťաC
Àɮצpªþ¥ó©Ò¥Ü

¦Û°Ê¸ü¤J¸ê®Æ¤è¦¡¦p¤U:
ª¬ºA=VLOOKUP(Y20,IF({1,0},AI20:AI27,AF20:AF27),2,0)    
«È¤á¼t§O=VLOOKUP(Y20,IF({1,0},AI20:AI27,AG20:AG27),2,0)    
¤Ñ¼Æ=VLOOKUP(Y20,IF({1,0},AI20:AI27,AH20:AH27),2,0)

¦Û°Ê¤ñ¹ïµL¸ê®ÆÅܪťÕ.zip (17.09 KB)

TOP

¦^´_ 6# jeff5424

±N¦X¨Ö®æ¸Ñ°£:
Xl0000040.rar (19.13 KB)

TOP

¦^´_ 7# ­ã´£³¡ªL
·PÁª©¥D¤j¤j,
¸g´ú¸Õ¥i¥¿±`¨Ï¥Î
«D±`·PÁª©¥D
¦X¨ÖÀx¦s®æ°ÝÃD
§Ú·|¯S§Oª`·N

TOP

        ÀR«ä¦Û¦b : ¥ÌÄ@°µ¡BÅw³ß¨ü¡C
ªð¦^¦Cªí ¤W¤@¥DÃD