| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel extract data from one sheet to another
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| extract data from sqlplus into excel sheet | Excel Programming | |||
| Extract Data by keyword and export to new Excel sheet | Excel Worksheet Functions | |||
| Help me, compare 2 sheet and extract the match data into the new sheet. | Excel Discussion (Misc queries) | |||
| how to extract data in .txt format from the excel sheet in a fixed length ascii forma | Excel Programming | |||
| Best way to extract data on one sheet & populate it on another sheet?????? | Excel Programming | |||
Threaded Mode
