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

[µo°Ý] ¦p¦ó¥Î¨ç¼Æ¨ú«ü©w¤é´Á¸ê®Æ

[µo°Ý] ¦p¦ó¥Î¨ç¼Æ¨ú«ü©w¤é´Á¸ê®Æ

history test.zip (8.45 KB)

¤å¥ó¤¤SHEET ­ì¥»¸ê®ÆÅã­ì¨C­û¤uªº¤É¯Å¬ö¿ý. ¦b¤@Äýªí¤º«ö¦~¦C¥X.
°ÝÃD1:¦ý¦³¨Ç­û¤u¦³¦h©ó¤@¶µ¤É¯Å¬ö¿ý¥u¯àÅã¥Ü¤@¶µ,
°ÝÃD2: ¤w§ä¥X³Ìªñ¤@¦¸Â¾¯ÅÅܰʤë¥÷, À³¥Î¬Æ»ò¨ç¼Æ¥i¥H±N³Ìªñ¤@¦¸Â¾¯ÅÅܰʤë¥÷ªºÂ¾¦ì¤Î¨ä¥L¸ê®Æ·Ç½T§ä?
¦³³Ò½ç±Ð.

¥»©«³Ì«á¥Ñ p212 ©ó 2014-1-6 09:21 ½s¿è

¦^´_ 1# missbb
¹ï©ó¡u°ÝÃD1¡G¦ý¦³¨Ç­û¤u¦³¦h©ó¤@¶µ¤É¯Å¬ö¿ý¥u¯àÅã¥Ü¤@¶µ¡v¡A¤D¦]¬°±z³]©wªºVLOOKUP©Ò­n·j´Mªº¸ê®Æ½d³ò¤£·í³y¦¨ªº¡C
VLOOKUP©Ò­n·j´M¤u§@ªí¡u­ì¥»¸ê®Æ¡vªº¸ê®Æ½d³ò¬°¦C3~¦C8¡A¦Ó«D¦C3~¦C6¡C

TOP

¦^´_ 1# missbb


m3=OFFSET($S3,,MATCH($K3,$S3:$AQ3,0),)
m3=OFFSET($S3,,MATCH($K3,$S3:$AQ3,0)+1,)
o3=OFFSET($S3,,MATCH($K3,$S3:$AQ3,0)+2,)
p3=OFFSET($S3,,MATCH($K3,$S3:$AQ3,0)+3,)
m3:p3 °é¿ï¦V¤U©Ô

s3=IFERROR(VLOOKUP($A3&S$2,­ì¥»¸ê®Æ!$B$3:$N$65535,6,FALSE),"")
t3=IFERROR(VLOOKUP($A3&T$2,­ì¥»¸ê®Æ!$B$3:$N$65535,8,FALSE),"")
u3=IFERROR(VLOOKUP($A3&U$2,­ì¥»¸ê®Æ!$B$3:$N$65535,9,FALSE),"")
v3=IFERROR(VLOOKUP($A3&V$2,­ì¥»¸ê®Æ!$B$3:$N$65535,12,FALSE),"")
w3=IFERROR(VLOOKUP($A3&W$2,­ì¥»¸ê®Æ!$B$3:$N$65535,13,FALSE),"")
s3:w3°é¿ï¡A¦V¥k ¦V¤U©Ô
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¦^´_ 3# softsadwind


    «Ü¤[¥¼¦^¨Ó ! ¦hÁ¦^ÂÐ,

TOP

        ÀR«ä¦Û¦b : µêªÅ¦³ºÉ¡D§ÚÄ@µL½a¡AµoÄ@®e©ö¦æÄ@Ãø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD