ªð¦^¦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¤ñ½Ö§ó¨ü½Ö¡D¤£­n¤ñ½Ö§ó©È½Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD