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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to produce a top 10 using a column range across mutiple
worksheets within a workbook.
 
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))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Look up across multiple sheets 1
Showing Letters For Column Headers Rather Thann Numbers ? 1
Excel How do I delete images in a specific range 1
Conditional Formatting Across Spreadsheets 3
Comparing Data Across Cell Ranges 2
version differences in excel 2007 - use of macros & range names 1
How do i use the same name multiple times in repeating worksheets 1
Require formula to search across multiple worksheets 2

Back
Top