ExcelBanter - Excel - Can i get a top 10 across a range of data in multiple wor.

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel - Can i get a top 10 across a range of data in multiple wor. (https://www.excelbanter.com/excel-discussion-misc-queries/23157-excel-can-i-get-top-10-across-range-data-multiple-wor.html)

quality831

Excel - Can i get a top 10 across a range of data in multiple wor.

Is it possible to produce a top 10 using a column range across mutiple
worksheets within a workbook.

Peo Sjoblom

If you copy this down 10 rows you will get the 10 largest values
if there are ties they will be included (of course if there are 3 10th
values only the first will be included)

=LARGE(Sheet1:Sheet3!$A$1:$A$10,ROW(1:1))

--
Regards,

Peo Sjoblom

"quality831" wrote in message
...
Is it possible to produce a top 10 using a column range across mutiple
worksheets within a workbook.

All times are GMT +1. The time now is 03:43 PM.