½Ð°Ý¦p¦ó¥Î¤½¦¡°µ¥X¥h°£«½Æ«áªºÈ
- ©«¤l
- 10
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 50
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office2003
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2011-11-23
- ³Ì«áµn¿ý
- 2012-11-27
|
§Ú¥u·|²Â²Âªº¨â¬q¦¡°µªk¡A§Æ±æ¹ï§A¦³À°§U¡C
D1={=IF(OR(A1=$B$1: $B$3,A1=$C$1: $C$3),65536,ROW(A1))} ¡ö©¹¤U½Æ»s¦ÜD9
E1=OFFSET($A$1,SMALL($D$1: $D$100,ROW(A1))-1,)&"" |
|
|
|
|
|
|
- ©«¤l
- 10
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 50
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office2003
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2011-11-23
- ³Ì«áµn¿ý
- 2012-11-27
|
¦^´_ 4# ookook520
§ÚªºD1¤½¦¡¤]¬O°}¦C¤½¦¡°Õ:L
¥H¬°¥ú¼g{}¡A§A´Nª¾¹D¤F¡A¯u¬O¤£¦n·N«ä¡C
¦Ü©ó§A»¡ªºctrl+shift+enter¬O§_»Ýn¤@ª½«ö¡A
³q±`¥u¦b²Ä¤@¦¸«ö´N¦n¤F¡A¤§«á´N¥Î½Æ»sªº¡C
¤]´N¬O½Æ»s´N·|³s±a±Nctrl+shift+enterªº°Ê§@¤@°_½Æ»s¤F¡C |
|
|
|
|
|
|