excel extract data from one sheet to another

[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.

 

[ozgrid.com]

Use a PivotTable and display the top x
http://www.ozgrid.com/Excel/excel-pivot-tables.htm

 

[Rob]

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