第一列為A="第"&(TEXT(RANK(A1,A:A),"[dbnum1]")&"名")不喜歡“一十”可把公式改為="第"&IF(LEFT(TEXT(RANK(A1,A:A),"[dbnum1]"),2)="一十",SUBSTITUTE(TEXT(RANK(A1,A:A),"[dbnum1]"),"一","",1),TEXT(RANK(A1,A:A),"[dbnum1]"))&"名" 那你的意思是要=LARGE(A:A,ROW())&"第"&IF(ISERR(FIND("一十",TEXT(ROW(),"[dbnum1]"))),TEXT(ROW(),"[dbnum1]"),SUBSTITUTE(TEXT(ROW(),"[dbnum1]"),"一十","十"))&"名"如果計算排名用的第一行資料不在A1，公式要改為=LARGE(A:A,ROW(A1))&"第"&IF(ISERR(FIND("一十",TEXT(ROW(A1),"[dbnum1]"))),TEXT(ROW(A1),"[dbnum1]"),SUBSTITUTE(TEXT(ROW(A1),"[dbnum1]"),"一十","十"))&"名"