| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
collecting data from various worksheets
hello,
can anyone help... i need to find the top 5 performers from 8 worksheets, the only data that is relevant to this particular search is the total of a selection of data on each sheet. The collection of the top 5 needs then to be on a new sheets so that it can be viewed seperately. Is there any way that i can set this up? Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
collecting data from various worksheets
I'd use the LARGE function to do this.
"NM3383" wrote: hello, can anyone help... i need to find the top 5 performers from 8 worksheets, the only data that is relevant to this particular search is the total of a selection of data on each sheet. The collection of the top 5 needs then to be on a new sheets so that it can be viewed seperately. Is there any way that i can set this up? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match and Sort for two range of data on different worksheets? | New Users to Excel | |||
| Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
| Macro pulling data from 2 worksheets | Excel Discussion (Misc queries) | |||
| sharing rows of data across multiple worksheets within a workbook | Excel Worksheet Functions | |||
| data entry on multiple worksheets | Excel Discussion (Misc queries) | |||
Linear Mode
