a b c
Name Vault Rank
Blake, Jasmine 7.900 1
Fattouche, Chloe 7.600 3
Fattouche, Nicole 7.700 2
Pratt, Erika 6.100 5
Salem, Alexandra 6.300 4
Mills, Sara 7.700 2

Ranked compares each via
=SUMPRODUCT(--(C5<$C$5:$C$148),1/COUNTIF($C$5:$C$148,$C$5:$C$148&""))+1


This data is on one sheet and already calculated the rank. Need to pull the
top three and put on seprate work sheet. Including ties.


Name Vault Rank
Blake, Jasmine 7.900 1
Fattouche, Nicole 7.700 2
Mills,Sara 7.700 2
Fattouche, Chloe 7.600 3

list are really biggerjust a clip and have to do from 4 events.