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

[µo°Ý] °Ñ·Ó¨ú­È

[µo°Ý] °Ñ·Ó¨ú­È

test.zip (10.42 KB)
½Ð°Ý§Ú¦pªG­n¦bsheet1ªºAÄæ¿é¤J³¡ªù
BÄæ´N·|¦Û°Ê¦C¥X¸Ó³¡ªù©Ò¦³­û¤u¡A¦³¿ìªk¥Î¨ç¼Æ°µ¨ì¶Ü?
°Ñ·Ó¦ì¸m¦bsheet2

ªþ¤WªºÀÉ®×sheet1¬°µ²ªG

B1
=IFERROR(INDEX(Sheet2!B:B,SMALL(IF((LOOKUP("ùÕ",A$1:A1)=Sheet2!A$1:A$25),ROW($1:$25),""),ROW()-LOOKUP("ùÕ",A$1:A1,ROW($1:1))+1)),"")&""

°}¦C¤½¦¡¡A¨Ï¥Î¤TÁä¿é¤J(CTRL+SHIT+ENTER)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 2# ML089
«D±`·PÁª©¥DÀ°¦£
¤W¤F¤@½Ò

TOP

ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 4# hcm19522
·PÁ¤j¤j¤À¨É

TOP

        ÀR«ä¦Û¦b : ½_ÁJµ²±o¶V¹¡º¡¡A¶V·|©¹¤U««¡A¤@­Ó¤H¶V¦³¦¨´N¡A´N­n¶V¦³Á¾¨Rªº¯ÝÃÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD