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

[µo°Ý] ¤£°÷¿n¤À, ¦ý«Ü·Q°Ý­ÓEXCEL·j´M¤Î½g±Æ°ÝÃD

¦^´_ 20# tata211


   ¤½¦¡§ï¦¨³o¼Ë¸Õ¸Õ¬Ý
{=INDEX(INDIRECT("'" & $C$2 & "'!A:A"),SMALL(IF(INDIRECT("'" & $C$2 & "'!$C$2:$E$500")=$B$2,ROW(A$2:C$200),4^8),ROW(A1)))}

TOP

¦^´_ 20# hcm19522


ÁÂÁÂÀ°¦£
¦ý³o­Ó®M¥Î¤W¥h¦n¹³¤£¦æ©O

TOP

¦^´_ 21# naruto018

¤j¤j§A¯uªº«Ü§Q®`
¤£¹L³o­Ó¬O§_¥u¯à¥Î¦b¤é´Á¨º¬q?
§Ú©Ô¨ì®ÇÃä¥Í¦¨ªº³£¥u¥X¤é´Á

TOP

¦^´_ 23# tata211


     §Ú§Ñ°O¤§«eªº¤é´Á°ÝÃD¤F
§Ú¬O¥H¤é´Áªº¤½¦¡¥h­×§ïªº
¤§«e¤é´Á¥h±¼&""¤F
©Ò¥H¨ä¥L¤½¦¡­n¸É¦^¥h

¤é´Á¤½¦¡
{=INDEX(INDIRECT("'" & $C$2 & "'!A:A"),SMALL(IF(INDIRECT("'" & $C$2 & "'!$C$2:$E$500")=$B$2,ROW(A$2:C$200),4^8),ROW(A1)))}

¨ä¥L¤½¦¡
{=INDEX(INDIRECT("'" & $C$2 & "'!A:A"),SMALL(IF(INDIRECT("'" & $C$2 & "'!$C$2:$E$500")=$B$2,ROW(A$2:C$200),4^8),ROW(A1)))&""}

TOP

§ÚÁÙ¦³¤@­Ó°ÝÃD¤½¦¡¬õ¦â³¡¤À´N­nÅܦ¨¦Û¤v§ï¤F¡A¨Sªk¥Î©Ôªº
§Ú¤W¦¸EXCELÀɧR±¼¤F
©Ò¥H¨Sªk´ú¸Õ

¨ä¥L¤½¦¡
{=INDEX(INDIRECT("'" & $C$2 & "'!A:A"),SMALL(IF(INDIRECT("'" & $C$2 & "'!$C$2E$500")=$B$2,ROW(A$2:C$200),4^8),ROW(A1)))&""}

©Î¬O§â¤½¦¡§ï¦¨¸Õ¸Õ¬Ý
{=INDEX(INDIRECT("'" & $C$2 & "'!" &CHAR(COLUMN(A:A)+64) & ":"&CHAR(COLUMN(A:A)+64)),SMALL(IF(INDIRECT("'" & $C$2 & "'!$C$2E$500")=$B$2,ROW(A$2:C$200),4^8),ROW(A2)))}

TOP


²{¦bÅܦ¨¥þ¬O¤é´Á;P
¦ý·Pı¦n¹³§Ö­n¦n¤F
¤j¤j¯à¥h§ÚNAS¤U¸ü¥hÀ°¦£³Ì«á­×§ï¤@¤U¶Ü?
·PÁ§A


H+T+T+P+S://gofile.me/3nwob/ehO7xcb6f
¬õ¦r­n¤â°Ê§ï¤@¤U

TOP

·|¥X²{§A»¡ªº­ì¦]¬O¦]¬°¤½¦¡ªº³¡¤À   A:A  Åܦ¨¤å¦r
©Ò¥H­nÅܦ¨¤â°Ê§ï
§Ú¤W¦¸¦^µª¦³»¡©ú
¤U­±·s¤½¦¡¥i¥H§ïµ½³o°ÝÃD
{=INDEX(INDIRECT("'" & $C$2 & "'!" & LEFT(ADDRESS(1,COLUMN(A:A),4,1),LEN(ADDRESS(1,COLUMN(A:A),4,1))-1)&":"&LEFT(ADDRESS(1,COLUMN(A:A),4,1),LEN(ADDRESS(1,COLUMN(A:A),4,1))-1)),SMALL(IF(INDIRECT("'" & $C$2 & "'!$C$2E$200")=$B$2,ROW(B$2$200),4^8),ROW(B1)))}
½Ð´ú¸Õ¬Ý¬Ý

TOP

¦^´_ 27# naruto018


°Ú°Ú°Ú°Ú
¤Ó·PÁ¤j¤j§AªºÀ°¦£
²{¦b¯uªº¬O§¹¬üª©¤F
±µµÛ´N¥ß§Y®M¥Î¨ì­ì¥»ªºÀɮפ¤

¦A¦¸·PÁ§A

TOP

¹ï¤F¤W¦¸¬Ý¤£À´ªº­ì¦]¬O
¤j¤jµ¹ªº¤½¦¡¤¤¹Ï¦³2­Óªí±¡¤½¥J
­è¤~¤~§Ë©ú¥Õ
­ì¨Ó¥¦¬O  : D ©M : $ ªº·N«ä

TOP

        ÀR«ä¦Û¦b : ­n¥Î¤ß¡A¤£­n¾Þ¤ß¡B·Ð¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD