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

[µo°Ý] ¸ó¤u§@ªí¸ê®Æ·J¶°

[µo°Ý] ¸ó¤u§@ªí¸ê®Æ·J¶°

§Ú¦³¤T­Ó¤u§@ªí¡AA¤u§@ªí ¼Æ¦r1¨ì5¡AB¤u§@ªí ¼Æ¦r6¨ì10
C¤u§@ªí·|§âA¤u§@ªíªº1¨ì5¼Æ(¤@ª½§ì¨ì³Ì«á¤@µ§)§ì¨ì¤u§@ªíC¡A¤§«á¦A§âB¤u§@ªí
©Ò¦³¸ê®Æ§ì¨ì¤u§@ªíC
¦p¹Ï

½Ð°Ý¦³¤°»ò¨ç¼Æ¥i¥H¥Î

=IFERROR(INDIRECT("Sheet"&TEXT(SMALL(IF((N(INDIRECT("Sheet"&{1,2}&"!A"&ROW($1:$99)))=0)*(T(INDIRECT("Sheet"&{1,2}&"!A"&ROW($1:$99)))=""),"",{1,2}*100+ROW($1:$99)),ROW(A1)),"0!!A00")),"")

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

TOP

        ÀR«ä¦Û¦b : ¤Hªº¤ß¦a¬O¤@²¥¥Ð¡A¤g¦a¨S¦³¼½¤U¦nºØ¤l¡A¤]ªø¤£¥X¦nªºªG¹ê¡C -
ªð¦^¦Cªí ¤W¤@¥DÃD