排序 依英文年月日 (13579)

日期：

C2{=INDEX(A:A,RIGHT(SMALL(MMULT(TRIM(MID(SUBSTITUTE(SUBSTITUTE(LEFT(A$2:A$16,LEN(A$2:A$16)-4),"years",REPT(" ",99)),"months",REPT(" ",99)),{1,2,3}*99-98,99))*1,10^{6;4;2})+ROW($2:$16),ROW(A1)),2))



留言

張貼留言