ExcelBanter - collecting data from various worksheets

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - collecting data from various worksheets (https://www.excelbanter.com/excel-worksheet-functions/95278-collecting-data-various-worksheets.html)

NM3383

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

Barb Reinhardt

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

All times are GMT +1. The time now is 07:28 PM.