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

[µo°Ý] ¸ê®Æªí°ÝÃD

¦Ñ®v½Ð°Ý¤@¤UIF(ROW($A1)>COUNTIF(Sheet1!$BB,sh),"",ROW($A1)) ¤¤ªºsh¬O§@¤°»ò¥Îªº

TOP

©w¸q¦WºÙ

¨ì
´¡¤J>¦WºÙ>©w¸q>©w¸q¦WºÙ
¬Ý¬Ý¬O«ç»ò¤@¦^¨Æ
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

½Ð°Ý¦U¦ì¦Ñ®v Hsieh¦Ñ®v ªþ¥ó¤½¦¡ =IF($A2="","",INDIRECT("Sheet1!R"&SMALL(IF(Sheet1!$B$2:$B$65536=sh,ROW($2:$65536),""),°]°È²Õ!$A2)&"C[-1]",0))   ¨ä¤¤ Sheet1!R ¤°»ò·N«ä¡A¥t¥~©w¸qùØ=MID(CELL("filename",!$A$1),FIND("]",CELL("filename",!$A$1))+1,255) ¬°¤°»ò¥Î "]" ¬O¤°»ò·N«ä

TOP

CELL("filename",!$A$1)ªºµª®×¬Ý¤@¤U¦A¥h¤F¸ÑFIND¨ç¼Æªº¥Îªk´Nª¾¹D¬°¤°»ò­n¥Î"["
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¤f»¡¦n¸Ü¡B¤ß·Q¦n·N¡B¨­¦æ¦n¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD