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

¦^´_ 11# goner

«D±`·PÁ gonet ¦A«×¦^ÂÐ

¥Ñ©ó AW4:BH28¸ê®Æ®É±a¤JªºµL¸ê®Æµ²ªG¬OªÅ­È""  Ãö«Y¡A
¤w±NµL¸ê®Æªºµ²ªGÅܧ󬰼ƭÈ0...

¤w­×¥¿ ^^  ·P®¦  ^^

TOP

¦^´_ 10# cypd


    ¨ç¼ÆISNUMBER¬O§P©w¸ÓÀx¦s®æ¤º¸ê®Æ¬O§_¬°¼Æ­È®æ¦¡¡A
©Ò¥HÀx¦s®æ¬°ªÅ­È""®É(µL¸ê®Æ)¦^¶Çªº«K¬OFALSE¡A
¦pªG³£­nÅã¥ÜTRUE¡A¦b±a¤JAW4:BH28¸ê®Æ®É½Ð¤£­nÅý±a¤JªºµL¸ê®Æµ²ªG¬°ªÅ­È""¡A½ÐÅýµL¸ê®Æªºµ²ªG¬°¼Æ­È0¡A
³o¼Ë´N¯àÅýISNUMBER³£¯à§P©w¬°TRUE¡C

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

¦^´_ 8# goner

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

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

¦^´_ 2# goner

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

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

TOP

¦^´_ 3# aer


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

TOP

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

TOP

¦^´_ 2# goner


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

TOP

        ÀR«ä¦Û¦b : ¥@¤W¦³¨â¥ó¨Æ¤£¯àµ¥¡G¤@¡B§µ¶¶ ¤G¡B¦æµ½¡C
ªð¦^¦Cªí ¤W¤@¥DÃD