·Q½Ð±Ð¦³ÃöEXCEL: Sheet1¸ê®Æ,¦p¦ó¦Û°Ê±a¥X¦bSheet2ªº¤U¤@¦Cªº°ÝÃD
- ©«¤l
- 9
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 22
- ÂI¦W
- 0
- §@·~¨t²Î
- Vista
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-8-29
- ³Ì«áµn¿ý
- 2011-9-27
|
·Q½Ð±Ð¦³ÃöEXCEL: Sheet1¸ê®Æ,¦p¦ó¦Û°Ê±a¥X¦bSheet2ªº¤U¤@¦Cªº°ÝÃD
¦U¦ìEXCEL°ª¤â±z¦n!¦³Ó°ÝÃDÅý¤p§Ì§xÂZ¤F¦n¤[!
¤p§Ìn¦p¦ó¥ÎEXCEL±N¨C¤Ñ©T©w²£¥Íªº³øªí(Sheet1),®æ¦¡¦p¤U:
¤é´Á ²£«~A ²£«~B ²£«~C ²£«~D ²£«~F ²£«~G
2011/8/30 690 723 23 35 667 688
±N¤W±ªº¸ê®Æ,¥i¥H¨Ì·Ó¤é´Á¦Û°Ê²£¥Í¦bSheet2¤W,¦Ó¤£¥Î¤@µ§¤@µ§ªº¦bSheet1½Æ»s,¦A¶K¤W¦bSheet2¤W!?
¤é´Á ²£«~A ²£«~B ²£«~C ²£«~D ²£«~F ²£«~G
2011/8/22 328 419 1652 1294 -1324 -875
2011/8/23 439 631 4076 69 -3637 562
2011/8/24 3454 1645 301 415 3153 1230
2011/8/25 111 165 811 1106 -700 -941
2011/8/26 1988 415 352 502 1636 -87
2011/8/30 690 723 23 35 667 688
·q½Ð½Ñ¦ì°ª¤â¶ÉÅn¬Û±Â,ÁÂÁÂ!! |
|
|
|
|
|
|
- ©«¤l
- 455
- ¥DÃD
- 8
- ºëµØ
- 1
- ¿n¤À
- 480
- ÂI¦W
- 0
- §@·~¨t²Î
- WINS home
- ³nÅ骩¥»
- OFFICE XP
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥Âí
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2015-1-22
|
¬On§ä³Ì«á¤@¦CÁÙ¬O8/30
¥ý°µ8/30
sheet1!a1="¤é´Á"
sheet1!a2=today()
sheet1!b2=vlookup($a2,sheet2!$a:$g,column(),0)©¹¥k©Ô |
|
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I
|
|
|
|
|
- ©«¤l
- 9
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 22
- ÂI¦W
- 0
- §@·~¨t²Î
- Vista
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-8-29
- ³Ì«áµn¿ý
- 2011-9-27
|
¦^´_ 2# gong
gong«e½ú±z¦n : «D±`°ª¿³¦¬¨ì±zªº¨Ó«H½ç±Ð, §Ú¸Õ¹L«e½úªº¤èªk,¥Ø«e¨S¦³¸Ñ¨M§ÚªººÃ°Ý,
©Ò¥H§Ú§â°ÝÃD¦A«·s±Ôz,·Ð½Ð«e½úÀ°¦£¬Ý¤@¦¸³oÓ°ÝÃD,ÁÂÁÂ!!
====================================================================================================
=> ¨C¤Ñ©T©w²£¥Íªº³øªí,¦p¤U:
-----------------------------------------------------------------------------------------------
(Sheet1)
¤é´Á ²£«~A ²£«~B ²£«~C ²£«~D ²£«~F ²£«~G
2011/8/30 690 723 23 35 667 688
-----------------------------------------------------------------------------------------------
=> ¦]¬°¤p§Ìt³d³øªíªº¶×¾ã,©Ò¥H»Ýn§â¨C¤Ñ¼´¥X¨ÓªºSheet1¸ê®Æ("2011/8/30 690 723 23 35 667 688")
½Æ»s¶K¤W¦bSheet2 ("2011/8/26 1988 415 352 502 1636 -87 ") ªº¤U¤@¦C, ? (PS: Sheet2n§@¬°²£«~ªº¤ÀªR¤§¥Î )
·Q½Ð±Ð«e½ú,É¥ÑEXCEL¤°»ò¤½¦¡,Sheet1ªº¸ê®Æ,¥i¥H¦Û°Ê±a¥X¦b Sheet2ªº 2011/8/26 ¸ê®Æªº¤U¤@¦C ?! (§Æ±æ¥i¥H¥un¶K¤W¨C¤ÑªºSheet1¸ê®Æ«á,
EXCEL´N¥i¥H¦Û°ÊÀ°§Ú¶×¤J¦bSheet2ªºraw data ¸Ì ; ¦Ó¥i¥H¤£¦A¥Î¤â¤u¤è¦¡ ½Æ»sSheet1¸ê®Æ,¦A¶K¤W¦bSheet2,2011/8/26 ¨º¤@¦C¸ê®Æ ªº¤U¤@¦C¤W )
-----------------------------------------------------------------------------------------------
(Sheet2)
¤é´Á ²£«~A ²£«~B ²£«~C ²£«~D ²£«~F ²£«~G
2011/8/22 328 419 1652 1294 -1324 -875
2011/8/23 439 631 4076 69 -3637 562
2011/8/24 3454 1645 301 415 3153 1230
2011/8/25 111 165 811 1106 -700 -941
2011/8/26 1988 415 352 502 1636 -87
-----------------------------------------------------------------------------------------------
==================================================================================================== |
|
|
|
|
|
|
- ©«¤l
- 40
- ¥DÃD
- 9
- ºëµØ
- 0
- ¿n¤À
- 72
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- office 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-8-19
- ³Ì«áµn¿ý
- 2024-10-28
|
¤£¦n·N«ä¡A´¡ªá¤@¤U¡A¬Ý¤F±zªº´yz¡A¤£ª¾¹D±z¬On±N¤½¦¡©ñ¦bsheet1ÁÙ¬Osheet2©O¡H
É¥ÑEXCEL¤°»ò¤½¦¡,Sheet1ªº¸ê®Æ,¥i¥H¦Û°Ê±a¥X¦b Sheet2ªº 2011/8/26 ¸ê®Æªº¤U¤@¦C ?! (§Æ±æ¥i¥H¥un¶K¤W¨C¤ÑªºSheet1¸ê®Æ«á,
EXCEL´N¥i¥H¦Û°ÊÀ°§Ú¶×¤J¦bSheet2ªºraw data ¸Ì ;James-001 µoªí©ó 2011-8-31 03:16 |
|
|
|
|
|
|
- ©«¤l
- 93
- ¥DÃD
- 18
- ºëµØ
- 0
- ¿n¤À
- 111
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- OFFICE
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW¡E°ª¶¯
- µù¥U®É¶¡
- 2010-10-22
- ³Ì«áµn¿ý
- 2023-3-3
|
¦^´_ 2# gong
¦P¼Ë°ÝÃD½Ð±Ðgongª©¤j¡F
¬On§ä³Ì«á¤@¦C...ÁÂÁÂ... |
|
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X
|
|
|
|
|
- ©«¤l
- 9
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 22
- ÂI¦W
- 0
- §@·~¨t²Î
- Vista
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-8-29
- ³Ì«áµn¿ý
- 2011-9-27
|
¦^´_ James-001
¥²¶·ÂǧUVBA¤~¯à¹F¦¨§Aªº»Ý¨D
Hsieh µoªí©ó 2011-8-31 08:58
Hsieh «e½ú±z¦n! «Üºa«H¦¬¨ì±zªº¦^«H! ¨º·Q½Ð±Ð«e½úVBAn«ç»ò¼g¤~·|¦³§Ú·Qnªºµ²ªG©O ?! ¦b¦¹¸ò±z½Ð¯q¤F,ÁÂÁÂ!! |
|
|
|
|
|
|
- ©«¤l
- 9
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 22
- ÂI¦W
- 0
- §@·~¨t²Î
- Vista
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-8-29
- ³Ì«áµn¿ý
- 2011-9-27
|
¤£¦n·N«ä¡A´¡ªá¤@¤U¡A¬Ý¤F±zªº´yz¡A¤£ª¾¹D±z¬On±N¤½¦¡©ñ¦bsheet1ÁÙ¬Osheet2©O¡H
maxchou µoªí©ó 2011-8-31 09:14
maxchou±z¦n! §Ú¬O·Qn±N¤½¦¡©ñ¦bsheet2¤W,ÁÂÁ±zªº¦^«H!! |
|
|
|
|
|
|
- ©«¤l
- 455
- ¥DÃD
- 8
- ºëµØ
- 1
- ¿n¤À
- 480
- ÂI¦W
- 0
- §@·~¨t²Î
- WINS home
- ³nÅ骩¥»
- OFFICE XP
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥Âí
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2015-1-22
|
sheet1!a2
=offset(sheet2!a$1,counta(sheet2!$a:$a)-1,)¥k©Ô |
|
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I
|
|
|
|
|