excel extract data from one sheet to another

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy Application.Union(c.Offset(0, 1), c.Offset(0, 2)... to a list onsame & another sheet 27
Copying specific rows to another sheet 2
RANKING alters when data is filtered 4
move data w/o blank data to another sheet 1
Transpose & reorg data from 2 WS to new WB 2
Copying Data from One sheet to another 6
Copy data from one sheet to another 2
MS Excel VBA Copy and Paste from external workbook data to central worksheet 1

Top