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

¤ñ¹ï«~¦W¬O§_¦s¦b

¤ñ¹ï«~¦W¬O§_¦s¦b

½Ð°Ý¦³¤@­Ó¤­­Ó«~¦Wªº¸ê®Æ,­n¥h¤ñ¹ï¬O§_¦b¬Y¤@¯S©w«~¦W½d³ò¬O§_¦³¥X²{,¦³«hÅã¥Ü¸Ó«~¦W.
§Ú­n¥Î¤°»ò¨ç¼Æ¥i¥H¹F¨ì§Ú­nªº»Ý¨D?

¤ñ¹ï¦r¦ê.zip (6.23 KB)

=IF(COUNTIF(A:E,I2)>0,I2,"")
ss

TOP

¦^´_ 2# sunnyso


    ÁÂÁÂ,sunnyso
¦pªG¤ñ¹ïªº¶¶§Ç¦pªG¤£¬Û¦P,¦³¿ìªk¸Ñ¨M¶Ü?

TOP

¦^´_ 3# imingho
F2=LOOKUP(2,1/ISNUMBER(MATCH($A2:$E2,$I:$I,0)),$A2:$E2)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ aer ©ó 2013-5-3 19:37 ½s¿è

¦^´_ 1# imingho

{=IF(OR(EXACT($I2,$A$2:$E$4)),I2,"")}  °}¦C¤½¦¡

TOP

¥»©«³Ì«á¥Ñ imingho ©ó 2013-5-4 16:08 ½s¿è

¦^´_ 4# Hsieh
Hsieh ÁÂÁ±z,¥Ø«e¥X²{¤@µ§ªº°ÝÃD¤v¸Ñ¨M.
¦pªG«~¦W¥X²{2¦¸¥H¤W,¥¦·|¥H²Ä¤G­Ó¬°¥D,¦pªG§â©Ò¦³²Å¦Xªº«~¦W³£¥X²{¦b¤@­ÓÀx¦s®æ.³o¼Ë§@±o¨ì¶Ü?

TOP

¦^´_ 5# aer
aer ÁÂÁ±zªºµª®×¡C

TOP

¥»©«³Ì«á¥Ñ Bodhidharma ©ó 2013-5-5 02:32 ½s¿è

¦^´_ 6# imingho

¦pªG¥i¥H±µ¨üµ²ªG¦b¤£¦P®æªº¸Ü¡A¥i¥Î°}¦C¤½¦¡
  1. =IFERROR(INDEX($I:$I,SMALL(IFERROR(MATCH($A2:$E2,$I:$I,0),""),COLUMN(A1))),"")
½Æ»s¥N½X
¤U©Ô¥k©Ô
¦pªG¤@©w­n¦P¤@®æªº¸Ü¡Aphonetic¨ç¼Æ¦ü¥GµLªk³o¼Ë¥Î¡A¤j·§¥u¯à¥Îconcatenate¤@­Ó¤@­Ó³s¤F¡K¡K
¤ñ¹ï¦r¦ê_sol.rar (6.88 KB)

TOP

¦^´_ 8# Bodhidharma

ÁÂÁÂBodhidharma
³o¼Ë´NÀ°¤F§Ú«Ü¤jªº¦£¤F.

TOP

¦^´_ 6# imingho

®æ¼Æ¤Ö®É¡Aª½±µ¥Î¤gªk·Ò¿û¤è¦¡¯à¤ñ¸û§Ö¤@¨Ç
  1. =MID(IF(COUNTIF(I:I,A2),","&A2,"")&IF(COUNTIF(I:I,B2),","&B2,"")&IF(COUNTIF(I:I,C2),","&C2,"")&IF(COUNTIF(I:I,D2),","&D2,"")&IF(COUNTIF(I:I,E2),","&E2,""),2,99)
½Æ»s¥N½X
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¡i®É¤é²öªÅ¹L¡j¤@­Ó¤H¦b¥@¶¡°µ¤F¦h¤Ö¨Æ¡A´Nµ¥©ó¹Ø©R¦³¦hªø¡C¦]¦¹¥²¶·»P®É¶¡Ävª§¡A¤Á²ö¨Ï®É¤éªÅ¹L¡C
ªð¦^¦Cªí ¤W¤@¥DÃD