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.