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

[µo°Ý] ¨Ì¾ÚÀx¦s®æÅã¥Ü¤ë¥÷ ±N¹ïÀ³¤ë¥÷¤º¤§¬ÛÃö¼Æ¾Ú²£¥Í...

[µo°Ý] ¨Ì¾ÚÀx¦s®æÅã¥Ü¤ë¥÷ ±N¹ïÀ³¤ë¥÷¤º¤§¬ÛÃö¼Æ¾Ú²£¥Í...

¨Ì¾Ú AT1Àx¦s®æÅã¥Ü¤ë¥÷(¨Ò¦p 8 ¤ë¥÷)
¹ïÀ³ AW3-BH3(1-12¤ë¥÷¼Æ¦r)
±N¹ïÀ³¤ë¥÷¤º¤§¬ÛÃö¼Æ¾Ú...
(AW4-BH28¤º¤§¼Æ¾Ú¨t°Ñ·Ó¨ä¥L¤u§@ªí©Ò²£¥Í«D¦Û¦æ¿é¤J)
±Nµ²ªG²£¥Í¦b AV4-AV28 Äæ¦ì³B¡K9¤ë¥H¦¹Ãþ±À
AV4-AV28 ¤½¦¡¸Ó¦p¦ó ?

0913.jpg
2023-9-14 00:10


1120913.rar (11.33 KB)

¥»©«³Ì«á¥Ñ goner ©ó 2023-9-14 15:00 ½s¿è

¦^´_ 1# cypd


    AV4¤½¦¡
  1¡B=IFNA(XLOOKUP($AT$1,$AW$3:$BH$3,AW4:BH4),"")
  2¡B¤½¦¡©¹¤U©Ô½Æ»s

1120913.rar (12.07 KB)

TOP

¦^´_ 1# cypd

AV4=INDEX($AW$4:$BH$28,,MATCH($AT$1,$AW$3:$BH$3,0))&""
¤U©Ô

TOP

¦^´_ 2# goner


«D±`·PÁ gonet ¼ö¤ßªº¦^ÂÐ
¥Ñ©óoffice exce ª©¥»¬O 2010 Ãö¨t
¨ç¼Æ XLOOKUP ¦ü¥GµLªk¾A¥Î...
¸Ó¦p¦ó­×¥¿ ?  ·PÁ±z  ^^

TOP

¦^´_ 2# goner
«D±`·PÁ gonet ¼ö¤ßªº¦^ÂÐ
ÀɮפU¸ü¨Ï¥Îoffice exce ª©¥» 2016 ´ú¸Õµ²ªG¦p¤U

14.jpg
2023-9-14 19:21

TOP

¦^´_ 3# aer


«D±`·PÁ gonet ¼ö¤ßªº¦^ÂÐ
¸g¥N¤J¤½¦¡´ú¸Õ¬°§Æ±æ¤§µ²ªG³á  ^^

TOP

¦^´_ 2# goner

°w¹ï¦¹  =IFNA(XLOOKUP($AT$1,$AW$3:$BH$3,AW4:BH4),"")  
¬ÛÃö  XLOOKUP ¬°Office 365 ¤~¦³ªº¨ç¼Æ...

¬O§_¯à¦A­×¥¿¤@¯ë Office 2013 ª©¾A¥Î¤§¤½¦¡...·P®¦  ^^

TOP

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