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

¤½¦¡»P°ò¥»§Þ¥©ºt½m

¦^´_ 6# oobird

A2=OFFSET(¦¨ÁZ!A$1,(ROW()-2)*9+1,)&""
C2=IF(B2="","",TEXT(OFFSET(¦¨ÁZ!$D$1,(ROW()-2)*9+COLUMN(A1),)-65,"[>=20]A;C;!B"))

ºî¦Xºt½m.zip (236.96 KB)

1

µû¤À¤H¼Æ

TOP

        ÀR«ä¦Û¦b : §Ú­Ì­n°µ¦nªÀ·|ªºÀô«O¡A¤]­n°µ¦n¤º¤ßªºÀô«O¡C
ªð¦^¦Cªí ¤W¤@¥DÃD