稱呼 1~12年級 含年度 (14494)

日期：

B2(隨年度 自動更改){=LOOKUP(MATCH(A2,SUBSTITUTE(TEXT(ROW($1:$12),"[DBNUM1]"),"一十","十")&"年级",),{1,7,10},{"小學","國中","高中"})&YEAR(NOW())-MID(123456123123,MATCH(A2,SUBSTITUTE(TEXT(ROW($1:$12),"[DBNUM1]"),"一十","十")&"年级",),1)+1&"级"



留言

張貼留言