Is it possible to produce a top 10 using a column range across mutiple worksheets within a workbook.
Q quality831 Apr 22, 2005 #1 Is it possible to produce a top 10 using a column range across mutiple worksheets within a workbook.
P Peo Sjoblom Apr 22, 2005 #2 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))
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))
