3 max values

  • Thread starter Thread starter Erlandas
  • Start date Start date
E

Erlandas

Hello,
need advice how to get 3 biggest values of each row from table of 10 columns
into new table.
 
Assuming there's no ties in the max values in any one row,
and the source data is in cols A to J in Sheet1, from row1 down

In Sheet2
---------
Select A1:C1
Put in the formula bar and array-enter, i.e. press CTRL+SHIFT+ENTER:
=LARGE(Sheet1!$A1:$J1,{1,2,3})
Fill down as many rows as there is data in Sheet1

A1:C1 will return the 3 largest values from Sheet1's A1:J1
A2:C2 will return the 3 largest values from Sheet1's A2:J2
and so on
 
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

VBA - retrieve data on last create named range from previous inserted named range 0
adding rows into the table 1
Scrabble Value calculation for Welsh words 0
Group List by Values in Column A and combine related row values inColumn B into 1 Cell 7
help on a formula (match and etc..) 1
max 7
Turning Data into a Table 1
Excel Help to copy information from one row at a time to another sheet 1

Back
Top