ªð¦^¦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¦ó ?



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

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

¦^´_ 7# cypd


    ¤W¤è aer ¾Çªø¦^µªªº¤½¦¡¥i¥H¦b Excel 2013 ¨Ï¥Î­ò

[AV4]¤½¦¡
=IFNA(INDEX($AW4:$BH4,,MATCH($AT$1,$AW$3:$BH$3,0)),"")
¤U©Ô

TOP

¦^´_ 8# goner

·PÁ gonet ¼ö¤ßªº¦^ÂÐ
¥Ñ©ó ¨ç¼Æ XLOOKUP ¦ü¥GµLªk¾A¥Î...Ãö¨t
¥N¤J IFNA(INDEX(...
¤w­×¥¿ ^^  ·PÁ±z  ^^

TOP

¦^´_ 8# goner

IFNA(INDEX($AW4:$BH4,,MATCH($AT$1,$AW$3:$BH$3,0)),"")
Ãö©ó¤½¦¡¬O§_¯à­×¥¿Åý¨äÅã¥Ü­È(AV4-AV28)§¡¬°¼Æ¦r®æ¦¡!!


1120916.rar (9.68 KB)

TOP

        ÀR«ä¦Û¦b : ¤H¥Í³Ì¤jªº¦¨´N¬O±q¥¢±Ñ¤¤¯¸°_¨Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD