每6格 各自不重複名次排序 (14480)

C2=SUMPRODUCT(N(TEXT(OFFSET(B$2,MAX(INT((ROW(A1)-1)/6)*6),,6),"0;;1!E9")-B2<0))+COUNTIF(OFFSET(B$2,MAX(INT((ROW(A1)-1)/6)*6),,MOD(ROW(A1)-1,6)+1),B2)