| 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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
excel extract data from one sheet to another
Use a PivotTable and display the top x
http://www.ozgrid.com/Excel/excel-pivot-tables.htm -- Regards Dave Hawley www.ozgrid.com "Rob" wrote in message ... 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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
excel extract data from one sheet to another
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 "ozgrid.com" wrote: Use a PivotTable and display the top x http://www.ozgrid.com/Excel/excel-pivot-tables.htm -- Regards Dave Hawley www.ozgrid.com "Rob" wrote in message ... 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. |
| Reply |
| 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 | |||
Linear Mode
