vlookup·í¦³¨âµ§¯Á¤Þ¬Û¦P®É, «ç»ò°Ñ·Ó¥X¤£¦PÈ?
- ©«¤l
- 6
- ¥DÃD
- 2
- ºëµØ
- 0
- ¿n¤À
- 14
- ÂI¦W
- 0
- §@·~¨t²Î
- windows
- ³nÅ骩¥»
- office2003
- ¾\ŪÅv
- 10
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2011-6-8
- ³Ì«áµn¿ý
- 2011-12-24
|
vlookup·í¦³¨âµ§¯Á¤Þ¬Û¦P®É, «ç»ò°Ñ·Ó¥X¤£¦PÈ?
vlookup·í¦³¨âµ§¯Á¤Þ¬Û¦P®É¡Avlookupn¯d¨ì¨âµ§¤£¬Û¦Pªº¸ê®Æ®É«ç»ò°µ?
¸Ô±¡½Ð°Ñ¾\¤Uªí(¦]¬°¤£¯àªþÀÉ)
ªÑ»ù µ§¼Æ ¤½¥q ªÑ»ù¨Ï¥ÎLARGE§ä¥X¥ªªí(ªÑ»ù)«e¤T¦W vlookup¤½¥q¦ý¬O·|¥X²{¨âµ§¬Û¦P ·Qn±o¨ìªºµª®×
1 3 a 6.1 b b
6.1 1 b 6.1 b c
6.1 1 c 1 a a
2 2 d |
|
±Ï±Ï§Ú§a
|
|
|
|
|
- ©«¤l
- 6
- ¥DÃD
- 2
- ºëµØ
- 0
- ¿n¤À
- 14
- ÂI¦W
- 0
- §@·~¨t²Î
- windows
- ³nÅ骩¥»
- office2003
- ¾\ŪÅv
- 10
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2011-6-8
- ³Ì«áµn¿ý
- 2011-12-24
|
¥»©«³Ì«á¥Ñ emmalee ©ó 2011-12-20 23:10 ½s¿è
§Ú¨Ï¥Î¦P¤@Ó¤èªk«á¡A·|¥X²{#VALUE!
=INDIRECT("C"&SMALL(IF($A$2:$A$5=D2,ROW($A$2:$A$5),""),COUNTIF($D$1:D1,D2)+1))
½Ð°ÝþÓ¦a¤è¦³°ÝÃD©O?
ÁÂÁ±z |
|
±Ï±Ï§Ú§a
|
|
|
|
|
- ©«¤l
- 812
- ¥DÃD
- 7
- ºëµØ
- 0
- ¿n¤À
- 862
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¤¤
- µù¥U®É¶¡
- 2010-5-13
- ³Ì«áµn¿ý
- 2019-10-10
|
°}¦C¤½¦¡
CTRL+SHIFT+ENTER |
|
|
|
|
|
|
- ©«¤l
- 6
- ¥DÃD
- 2
- ºëµØ
- 0
- ¿n¤À
- 14
- ÂI¦W
- 0
- §@·~¨t²Î
- windows
- ³nÅ骩¥»
- office2003
- ¾\ŪÅv
- 10
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2011-6-8
- ³Ì«áµn¿ý
- 2011-12-24
|
¥»©«³Ì«á¥Ñ emmalee ©ó 2011-12-22 22:47 ½s¿è
µ{¦¡¤@ª½»¡§Úªº
(SMALL(IF($A$2:$A$5=D2,ROW($A$2:$A$5),""),COUNTIF($D$1:D1,D2)+1))
³o¤@¬q¦³°ÝÃD¡C |
|
±Ï±Ï§Ú§a
|
|
|
|
|
- ©«¤l
- 106
- ¥DÃD
- 35
- ºëµØ
- 0
- ¿n¤À
- 146
- ÂI¦W
- 0
- §@·~¨t²Î
- Window 7
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2011-8-30
- ³Ì«áµn¿ý
- 2024-3-26
|
¦^´_ 2# Hsieh
,¬O§_¥i¥H½Ð±Ð±z, °²¦p¤£°µ " ªÑ»ù¨Ï¥ÎLARGE§ä¥X¥ªªí(ªÑ»ù)«e¤T¦W"³oÓÄæ¦ìªº¸Ü, §Ún«ç»òª½±µ§ä¥X¬Û¦PªÑ»ùªº©O? ´N¬Oª½±µSHOW ·Qn±o¨ìªºµª®×¡C ·PÁÂ! |
|
|
|
|
|
|
- ©«¤l
- 106
- ¥DÃD
- 35
- ºëµØ
- 0
- ¿n¤À
- 146
- ÂI¦W
- 0
- §@·~¨t²Î
- Window 7
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2011-8-30
- ³Ì«áµn¿ý
- 2024-3-26
|
¦^´_ 7# Hsieh
¬O³o¼Ëªº, ·í½s¸¹¬Û¦P®É, §Ú¦p¦ó¦b¦C¦L°Ïªº§â¦P¤@½s¸¹©³¤Uªº¸ê®Æ¤]§ä¥X¨Ó, ¤@¨Ö¦C¦L©O? ·PÁÂ! |
|
|
|
|
|
|
- ©«¤l
- 967
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 1001
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN XP
- ³nÅ骩¥»
- OFFICE 2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-11-29
- ³Ì«áµn¿ý
- 2022-5-17
|
¥»©«³Ì«á¥Ñ register313 ©ó 2012-1-31 12:07 ½s¿è
¦^´_ 8# yc1031
H4=INDEX(B:B,SMALL(IF(COUNTIF($I$1,$A$2:$A$10)>=1,ROW($2:$10),65534),ROW($A1)),)&"" °}¦C¤½¦¡
Book1.rar (2.25 KB)
|
|
|
|
|
|
|
- ©«¤l
- 106
- ¥DÃD
- 35
- ºëµØ
- 0
- ¿n¤À
- 146
- ÂI¦W
- 0
- §@·~¨t²Î
- Window 7
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2011-8-30
- ³Ì«áµn¿ý
- 2024-3-26
|
¦^´_ 9# register313
¯uªº©êºp, §ÚªºÅvÁÙ¤£¨ì¯à¤U¸ü~ ©Ò¥HµLªk¬Ý±zªº½d¥»¡C
§Ú観¥Î±zªº¤½¦¡, ¦ý¦ü¥G¶]¤£¥X¨Ó, §Ú¦A¸Õ¬Ý¬Ý¦n¤F, ·PÁÂ! |
|
|
|
|
|
|