排名 不同欄 (13283)

F2=RANK(OFFSET(A2,,LOOKUP(1,0/(B2:D2<>""),{1,2,3})),B$2:D$9)

另解=COUNTIF(B:D,">"&OFFSET(A2,,LOOKUP(1,0/(B2:D2<>""),{1,2,3})))+1

另解=RANK(SUM(B2:D2),B:D)