excel extract data from one sheet to another

  • Thread starter Thread starter Rob
  • Start date Start date
R

Rob

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.
 
Thanks for your Help...Great!! Stuff
Was able to use these , However when I refresh a table once the data has
changed it puts all the data and the rank and not just the first 3?

Thanks Rob
 
Back
Top