½Ð°Ý¦b¤é´Á¤Î©m¦W¤U§ä¥X¬ÛÃö¸ê®Æ,
- ©«¤l
- 176
- ¥DÃD
- 98
- ºëµØ
- 0
- ¿n¤À
- 279
- ÂI¦W
- 0
- §@·~¨t²Î
- window 7
- ³nÅ骩¥»
- office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-2-17
- ³Ì«áµn¿ý
- 2020-4-8
|
½Ð°Ý¦b¤é´Á¤Î©m¦W¤U§ä¥X¬ÛÃö¸ê®Æ,
½Ð°Ý¦p¦ó¥Î¤½¦¡§ä¥X 1Sep2016 ªL®Û©úªº Á~ª÷¤Î, ¾¦ì ¬O $16,000 ¤Î ¤åû
½Ð«ü±Ð
¥Í®Ä¤é´Á ©m¦W Á~ª÷ ¾¦ì
01Jan2015 ªL®Û©ú $13,000.00 ¤åû
01Jan2016 ªL®Û©ú $16,000.00 ¤åû
01Jan2017 ªL®Û©ú $17,230.00 ¤åû
01Jan2015 ±ç¥ò¤å $12,000.00 ¤åû
01Jan2016 ±ç¥ò¤å $14,000.00 ¤åû
01Jan2017 ±ç¥ò¤å $17,500.00 °ª¯Å¤åû
01Jan2015 ³¯¤©÷ $13,000.00 ·|p
01Jan2016 ³¯¤©÷ $14,500.00 ·|p
01Jan2017 ³¯¤©÷ $16,100.00 °ª¯Å·|p
01Jan2015 ½²§ÓÃô $13,000.00 ¤åû
01Jan2016 ½²§ÓÃô $12,530.00 ¤åû
01Jan2017 ½²§ÓÃô $14,110.00 ¤åû |
-
-
Sample.zip
(51.6 KB)
|
|
|
|
|
|
- ©«¤l
- 1387
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 1397
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-9-11
- ³Ì«áµn¿ý
- 2024-11-7
|
|
google"EXCEL°g" blog ©Îgoogleºô§}:https://hcm19522.blogspot.com/
|
|
|
|
|
- ©«¤l
- 315
- ¥DÃD
- 51
- ºëµØ
- 0
- ¿n¤À
- 367
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-9-29
- ³Ì«áµn¿ý
- 2021-10-12
|
¥»©«³Ì«á¥Ñ Airman ©ó 2017-10-9 15:37 ½s¿è
¦^´_ 1# enoch
VLOOKUP-¤ñ¹ïÂùÄæ(¦P&¤£¦PSheet).rar (17.3 KB)
ÃD·N»Ý¨D¡J¥H¤u§@ªí¦P¦CªºAÄæ©MBÄ椧²Õ¦XÈ¡A·j´M¹ïÀ³ªºCÄæ©MDÄ椧²Õ¦XÈ
°²³]~Sheet1ªºAÄæ©MBÄ椧¦U²Õ¦XȨS¦³«½Æ~«h
¬Û¦P¤u§@ªí®É¡JSheet1ªºI1¤½¦¡
=IF(OR(G1="",H1=""),"",VLOOKUP($G1&$H1,IF({1,0},$A$1:$A$100&$B$1:$B$100,C$1:C$100),2,))
°}¦C¤½¦¡~¿é¤J¤½¦¡«á~Shift¡BCtrl¡BEnter¤TÁä»ô«ö~
¥k©Ô¨ìJ1¡A¦A¤U©Ô¶ñº¡§Y¥i!
¦bGÄæ©MHÄæ¶ñ¤J·j´Mªº²Õ¦X«á~IÄæ©MJÄæ§Y·|Åã¥Ü¥X¹ïÀ³ªºCÄæ©MDÄæ²Õ¦X
$100¦C¤£°÷¥Î®É¡A¥i¦Û¦æ¼WצC¼Æ¡A¦A±N¤½¦¡«·s©¹¥k©¹¤U©Ô¡C
¤£¬Û¦P¤u§@ªí®É¡J,Sheet2ªºC1¤½¦¡
=IF(OR(A1="",B1=""),"",VLOOKUP($A1&$B1,IF({1,0},Sheet1!$A$1:$A$100& Sheet1!$B$1:$B$100,Sheet1!C$1:C$100),2,))
°}¦C¤½¦¡~¿é¤J¤½¦¡«á~Shift¡BCtrl¡BEnter¤TÁä»ô«ö~
¥k©Ô¨ìD1¡A¦A¤U©Ô¶ñº¡§Y¥i!
¦bAÄæ©MBÄæ¶ñ¤J·j´Mªº²Õ¦X«á~IÄæ©MJÄæ§Y·|Åã¥Ü¥X¹ïÀ³ªºCÄæ©MDÄæ²Õ¦X
$100¦C¤£°÷¥Î®É¡A¥i¦Û¦æ¼WצC¼Æ¡A¦A±N¤½¦¡«·s©¹¥k©¹¤U©Ô¡C |
|
|
|
|
|
|
- ©«¤l
- 61
- ¥DÃD
- 20
- ºëµØ
- 0
- ¿n¤À
- 106
- ÂI¦W
- 22
- §@·~¨t²Î
- winds XP
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2014-1-21
- ³Ì«áµn¿ý
- 2024-10-8
|
|
|
|
|
|
|