½Ð°ÝVLOOPUP¦p¦ó§ä¥X«½Æªº¬Y¤@µ§¸ê®Æ
- ©«¤l
- 1
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 2
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- offiec2010
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2015-5-27
- ³Ì«áµn¿ý
- 2015-5-27
|
½Ð°ÝVLOOPUP¦p¦ó§ä¥X«½Æªº¬Y¤@µ§¸ê®Æ
½Ð°Ý¦U¦ì«e½ú¡G
¨Ï¥ÎVLOOKUP¨ç¼Æ¦b¤@¤j°ï¸ê®Æ¤¤§ä¥X¥X³f¸ê®Æ¤¤¤é´Á³Ìªñªº¤@µ§n¦p¦ó°µ¡H
¨Ò¡G¤é´Á ³f¸¹ ³æ»ù
110325 B234 500
150405 C001 200
130411 C001 180
140103 C001 190
..............................................
°²³]³f«~«Ü¦h¡A§Ún¬d³Ìªñªº¤@µ§¡A¥Î¤°»ò¤èªk¥i¥H§ä¨ì¡C |
|
|
|
|
|
|
- ©«¤l
- 2025
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 2053
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- Office2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¥«
- µù¥U®É¶¡
- 2011-3-2
- ³Ì«áµn¿ý
- 2024-3-14
|
=VLOOKUP(MAX(A:A),$A:$C,COLUMN(A1),)
¥k©Ô |
|
{...} ªí¥Ü»Ýn¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡
|
|
|
|
|
- ©«¤l
- 5
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 7
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- Win7
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2015-5-22
- ³Ì«áµn¿ý
- 2015-9-26
|
E2:F2:- =INDEX(C:C,MATCH(MAX(IF(B:B=E2,A:A,))&E2,A:A&B:B,))
½Æ»s¥N½X ¼Æ²Õ¤½¦¡ |
|
|
|
|
|
|
- ©«¤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-3
|
http://blog.xuite.net/hcm19522/twblog/350269851 |
|
|
|
|
|
|