»Ýn±N¦P¤@¤H¦³¼Æµ§¸ê®Æ¥u¨ú¨ä¤¤¤@µ§¸ê®ÆȪº¤èªk
- ©«¤l
- 43
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 74
- ÂI¦W
- 0
- §@·~¨t²Î
- windows 7
- ³nÅ骩¥»
- office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-1-17
- ³Ì«áµn¿ý
- 2020-8-24
|
F4 ¸Ìªº"°}¦C¤½¦¡" =INDEX(B$2:B$7,SMALL(IF($A$2:$A$7=$G$2,ROW($B$2:$B$7)-ROW($B$1)),ROWS($E$4:$E4)))
©¹¥k©¹¤U½Æ»s§Y¥i
|
|
|
|
|
|
|
- ©«¤l
- 43
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 74
- ÂI¦W
- 0
- §@·~¨t²Î
- windows 7
- ³nÅ骩¥»
- office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-1-17
- ³Ì«áµn¿ý
- 2020-8-24
|
¥»©«³Ì«á¥Ñ handmuch ©ó 2011-4-7 21:43 ½s¿è
¦^´_ 4# tatsun
§AÀ³¸Ó¬O¨S¦³«öCtrl+shift+Enter¡A³o¬O°}¦C¤½¦¡®@!!
¤£µMvlookup ¤]¥i¥H¥Î¡A¥u¤£¹Ln¼W¥[»²§UÄæ¡CA2ªº¤½¦¡=B2&C2
G4,G5,G6 ¦Û¤v¥´©Î½Æ»s¤W¥h¡AH4¤½¦¡=VLOOKUP($H$2&G4,$A$2:$D$7,4,0)¦A¦V¤U©Ô
|
|
|
|
|
|
|