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

½Ð°Ý¦p¦óÁÙ­ì¨Ó·½¸ê®Æ®æ¦¡

Y19=INDIRECT("V" &INT((ROW()-19)/COLUMNS($W$2:$AB$2))+3)
Z19=INDEX($W$2:$AB$2,MOD((ROW()-19),COLUMNS($W$2:$AB$2))+1)

¼Ï¯Ã.zip (4.83 KB)

¨S¨Æ´N¨Ó³}³}

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦¨´N¤@¤Á¡j®É¶¡¥i¥H³y´N¤H®æ¡A¥i¥H¦¨´N¨Æ·~¡A¤]¥i¥HÀx¿n¥\¼w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD