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

[µo°Ý] ¤£ª¾­n¨Ï¥Î¦óºØ¨ç¼Æ

[µo°Ý] ¤£ª¾­n¨Ï¥Î¦óºØ¨ç¼Æ

¤j®a¦n  

¤p§Ì¦b®a¸Õ¤F2¤ÑÁÙ¬O¨S¦³µ²ªG
¥u¦n¤W¨Óµo°Ý½Ð¨D¤j®a¤F

¦bC2 ¿é¤J¬ÛÃö¥N¸¹     G2==VLOOKUP(C2,Sheet2!A:B,2,0)
¦bF1¿é¤J  ¤£¦Pªº½s¸¹ LW-102489/LW-103806      J1©MH3  ¥i¥H¸ò¸ê®Æ§ó·s









123.rar (79.54 KB)

¦^´_ 1# abcdpage

J1=INDEX(INDEX(Sheet2!$A:$W,MATCH($C$2,Sheet2!$A:$A,0),),,MATCH(Sheet1!$F$1,INDEX(Sheet2!$A:$W,MATCH($C$2,Sheet2!$A:$A,0),),0)+1)
H3=INDEX(INDEX(Sheet2!$A:$W,MATCH($C$2,Sheet2!$A:$A,0),),,MATCH(Sheet1!$F$1,INDEX(Sheet2!$A:$W,MATCH($C$2,Sheet2!$A:$A,0),),0)-2)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 1# abcdpage


123.rar (79.51 KB)

©w¸q ¸ê®Æ=Sheet2!$A$2:$W$3
J1={=INDEX(¸ê®Æ,MAX((¸ê®Æ=F1)*ROW(¸ê®Æ))-1,MAX((¸ê®Æ=F1)*COLUMN(¸ê®Æ))+1)}
H3={=INDEX(¸ê®Æ,MAX((¸ê®Æ=F1)*ROW(¸ê®Æ))-1,MAX((¸ê®Æ=F1)*COLUMN(¸ê®Æ))-2)}

°Ñ¦Ò¬Ý¬Ý
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

·PÁÂ2¦ì  ªºÀ°¦£
¤p§Ì·P¿E¤£ºÉ

TOP

J1
=SUMIF(Sheet2!F:V,F1,Sheet2!G$1)

H3

{=INDIRECT("Sheet2!"&ADDRESS(MAX((F1=Sheet2!F2:V3)*ROW(F2:V3)),MAX((F1=Sheet2!F2:V3)*COLUMN(F2:V3)-2),4))}
300 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¤H¤£©È¿ù¡A´N©È¤£§ï¹L¡A§ï¹L¨Ã¤£Ãø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD