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

[µo°Ý] ¤U©Ô¿ï¶µ

¨â¼h¤U©Ô²M³æ¡A¤T­Ó©w¸q¦WºÙ³B²z¡I¡I

001.GIF
2015-11-11 20:59

¡@

¢°¡D¢ÏÄæ¥Î²M³æ
xList¡G=OFFSET(ªþ¥ó!$G$1,,,,COUNTA(ªþ¥ó!$G$1:$AZ$1))

¢±¡D
xCell¡G=OFFSET(ªþ¥ó!$G$1,1,MATCH(ªþ¥ó!$A2,xList1,)-1)
¡@
¢²¡D¢ÒÄæ¥Î²M³æ
xList2¡G=IF(ªþ¥ó!$A2="QTY",IF(ªþ¥ó!$B2<ªþ¥ó!$C2,ªþ¥ó!$H$2,ªþ¥ó!$H$3:$H$4),OFFSET(xCell,,,COUNTA(OFFSET(xCell,,,999))))

TOP

¦^´_ 11# ­ã´£³¡ªL

ÁÂÁ­ã¤j¡A¤½¦¡Â²³æ¤S¦n¥Î

TOP

¨Ï¥Î©w¸q¦WºÙ + ¸ê®ÆÅçÃÒ + INDIRECT()­n¥Î´X¼h³£¥i¥H³á!
Rogersg

TOP

        ÀR«ä¦Û¦b : °ß¨ä´L­«¦Û¤vªº¤H¡A¤~§ó«i©óÁY¤p¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD