ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

½Ð°Ý¦p¦ó¥Î¤½¦¡°µ¥X¥h°£­«½Æ«áªº­È

½Ð°Ý¦p¦ó¥Î¤½¦¡°µ¥X¥h°£­«½Æ«áªº­È

¥»©«³Ì«á¥Ñ ookook520 ©ó 2011-11-28 00:40 ½s¿è

[¦U¦ì¤j¤j
½Ð°Ý¦p¦ó¥Î¤½¦¡°µ¥X¥h°£­«½Æ«áªº­È:)

\·PÁ¸U¤À

¬¡­¶Ã¯1.zip (3.65 KB)

§Ú¥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,)&""

TOP

=INDEX(A:A,SMALL(IF(COUNTIF($B$1:$C$3,$A$1:$A$9),65534,ROW($1:$9)),ROW(A1)))&""
°}¦C¤½¦¡

TOP

¥»©«³Ì«á¥Ñ ookook520 ©ó 2011-11-28 17:32 ½s¿è

·PÁ¨â¦ì¤j¤j
¤p§Ì¤£¤~ ÁÙ¬O¨S¦³¿ìªk°µ¥X
¬O§_¥i¥H¦A¸Ô­z

davidoff ¤j¤j±z´£¨Ñ¦b¤U´N·P¿E¤£ºÉ
¤½¦¡¦b¤U¿é¤J¥X²{¿ù»~°T®§


ANGELA ¤j¤j ¤]·PÁ±z
¬O§_¬O¦bD1¿é¤JµM«áªº°Ê§@¬O?
¬O§_ÁÙ±o¤@ª½«ö C+S+ENTER
¯à¦³¤£¥Î«öªº¤è¦¡¶Ü?

·P¿E¸U¤À

TOP

¦^´_ 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

TOP

¦^´_ 5# davidoff

ÁÂÁ¤j¤j©Ò¥Hºâ¬O¦b­I´º½Æ»s¤F
·PÁÂ

TOP

        ÀR«ä¦Û¦b : ¦¨¥\¬OÀuÂIªºµo´§¡A¥¢±Ñ¬O¯ÊÂIªº²Ö¿n¡C
ªð¦^¦Cªí ¤W¤@¥DÃD