#5 from cbatrody

In Column M: RANK(L10,$L$10:$L$26,0)+COUNTIF($L$10:L10,L10)-1
Change the L in D =>

In Column M: RANK(D10,$D$10:$D$26,0)+COUNTIF($D$10:D10,D10)-1