| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#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)) -- 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| How do I create a list in excel that contains external data? | Excel Discussion (Misc queries) | |||
| How can I check if data in an external data range is changed afte. | Excel Worksheet Functions | |||
| Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel | |||
| How do I check for duplications in a range of data (excel)? | Excel Worksheet Functions | |||
Linear Mode
