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

­Y¬O¨S¦³¤å¦r¡A¬O§_¥i¥HÅã¥Ü¡u¥H¤UªÅ¥Õ¡v¡H

­Y¬O¨S¦³¤å¦r¡A¬O§_¥i¥HÅã¥Ü¡u¥H¤UªÅ¥Õ¡v¡H

¦U¦ì¤j¤j¦n

§Ú°µ¤F¤@­ÓexcelÀɮסA¦³2­Ó­¶ÅÒ
¤@­Ó¬O¡u¦í¤á¤ÏÀ³¡v¥t¤@­Ó¬O¡uºû­×³æ¡v

¥Ø«e¦³¥Îvlookup§â¡u¦í¤á¤ÏÀ³¡v¤¤ªº¤º®e¨Ì¤á§O¨Ó¥h§ä¸ê®Æ¦b¡uºû­×³æ¡v¤¤
¥i¬O¦]¬°¤£¬O¨C¤@¦¸ªººû­×¤º®e³£«Ü¦h¡A©Ò¥H·Q°Ý¦U¦ì¤j¤j¡A­Y¤µ¤Ñ¥u¦³¤@¥ó»Ý­n§ïªº¸Ü
¥i§_¦³¤èªk¦b²Ä¤GÂIªº®É­ÔÅã¥Ü¡u¥H¤UªÅ¥Õ¡v¡H

ºû­×³æ.zip (23.5 KB)

¦^´_ 1# ÄÉ¡C

¦b"ºû­×³æ"ªºA5Àx¦s®æ¿é¤J¡G
=IF(LEN(VLOOKUP($B$3,¦í¤á¤ÏÀ³!$A$2:$M$15,ROW()+1,FALSE))>1,VLOOKUP($B$3,¦í¤á¤ÏÀ³!$A$2:$M$14,ROW()+1,FALSE),IF(OR(OFFSET(A5,-1,0)="¥H¤UªÅ¥Õ",OFFSET(A5,-1,0)="",),"","¥H¤UªÅ¥Õ"))

©¹¤U½Æ»s~

TOP

=IF(OR(B$3="",A4={"","(¥H¤UªÅ¥Õ)"}),"",TEXT(VLOOKUP(B$3,¦í¤á¤ÏÀ³!A:R,ROW(A6),),"[=](¥H¤UªÅ¥Õ)"))

TOP

ÁÂÁ¨â¦ì¤j¤jªºÀ°¦£

TOP

¦^´_  ÄÉ¡C

¦b"ºû­×³æ"ªºA5Àx¦s®æ¿é¤J¡G
=IF(LEN(VLOOKUP($B$3,¦í¤á¤ÏÀ³!$A$2M$15,ROW()+1,FALSE))> ...
tku0216 µoªí©ó 2016-3-20 18:11


¤j¤j¡A¦A½Ð°Ý¤@¤U¡A¡u¥H¤UªÅ¥Õ¡v¬O§_¥i¥H¸m¤¤¡H
ÁÂÁÂ:-)

TOP

¤j¤j¡K·Q¦A½Ð°Ý¤@¤U¡A¦]¬°­Y¬O¡u¤á§O¡v¬°ªÅ¥Õ
¤U­±ªº¤½¦¡¥þ³¡·|Åã¥Ü¡u#N/A¡v
¬O§_¦³¤èªk¥i¥HÅý#N/AÅܦ¨ªÅ¥Õ©O¡H
ÁÂÁÂ

TOP

=IFERROR(­ì¤½¦¡,"")

TOP

=IFERROR(­ì¤½¦¡,"")
fengetianxia µoªí©ó 2016-3-22 15:30


·PÁ±zªº¨ó§U~~~¸ê®Æ§¹¦¨!!!:)

TOP

        ÀR«ä¦Û¦b : µêªÅ¦³ºÉ¡D§ÚÄ@µL½a¡AµoÄ@®e©ö¦æÄ@Ãø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD