Hello,
need advice how to get 3 biggest values of each row from table of 10 columns
into new table.
Hello,
need advice how to get 3 biggest values of each row from table of 10 columns
into new table.
=large(A1:A10,1)
=large(A1:A10,2)
=large(A1:A10,3)
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
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"Erlandas" <[email protected]> wrote in message
news:[email protected]...
> Hello,
> need advice how to get 3 biggest values of each row from table of 10
columns
> into new table.
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks