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

tata211

¤U¸ü (67.4 KB)

2017-1-24 16:50

¦p¹Ï©Ò¥Ü­n¨D
½Ð°Ý­n¦p¦ó¹F¨ì©O?

®w¦s«~ºØ¬°¤U©Ô²M³æ
¦Ó¥B¬d¸ß¿é¤J¦ì¸m¥ç¬°¬Û¦Pªº¤U©Ô²M³æ
¿ï¦n«á¤U­±´N·|§â¤£¦P¤À­¶¤º(3­Ó¤À­¶)ªº¸ê®Æ¾ã¦æ¶K¦b¤U­±
³Ì¦nÁÙ¥i¥HÅã¥Ü¤@¦@¦h¤Ö¦æ

§Æ±æ¦³¤j¤jÀ°¦£¤U

tata211

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

¤U¸ü (44.93 KB)

2017-2-23 12:06

tata211

¦^´_ 27# naruto018


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

¦A¦¸·PÁ§A

naruto018

·|¥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)))}
½Ð´ú¸Õ¬Ý¬Ý

tata211

¤U¸ü (50.63 KB)

2017-2-22 12:04

²{¦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

naruto018

§ÚÁÙ¦³¤@­Ó°ÝÃ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)))}

naruto018

¦^´_ 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)))&""}

tata211

¦^´_ 21# naruto018

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

¤U¸ü (105.63 KB)

2017-2-9 16:52

tata211

¦^´_ 20# hcm19522


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

naruto018

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