E2:M13{=SUBSTITUTE(SUBSTITUTE(TEXT(SUM(ABS(IF({1,0},,$B$2)-LARGE(IF(MOD($B$2-ROW($1:$199)-3,12)+1=FIND($D2,"鼠牛虎兔龍蛇馬羊猴雞狗豬"),$B$2-ROW($1:$199)+1),COLUMN(A1)))*{1000,1})+1,"0年000歲"),"年0","年"),"年0","年")
另解{=LARGE(IF(MOD($B$2-ROW($1:$199)-3,12)+1=FIND($D2,"鼠牛虎兔龍蛇馬羊猴雞狗豬"),$B$2-ROW($1:$199)+1),COLUMN(A1))&"年"&$B$2-LARGE(IF(MOD($B$2-ROW($1:$199)-3,12)+1=FIND($D2,"鼠牛虎兔龍蛇馬羊猴雞狗豬"),$B$2-ROW($1:$199)+1),COLUMN(A1))+1&"歲"
D2:E13格式化=LEFT($E2,4)-$B$2=0
留言
張貼留言