Look up function and Max function
 

I have
21 columns A to U, and 600 rows.

I want use look up function for the maximum to return the value from the
first column (A) from the same position in each column without ordering each
one . Do you know a quick easy way to do it?

Means I want to get the maximum value in each column and match it with the
corresponding cell (same row but from Column A).

Best

Hi,

Try this:

=INDEX($A$1:$A$100,MATCH(MAX(B$1:B$100),B$1:B$100, 0))

Regards,
KL


"karim" wrote in message
...
I have
21 columns A to U, and 600 rows.

I want use look up function for the maximum to return the value from the
first column (A) from the same position in each column without ordering
each
one . Do you know a quick easy way to do it?

Means I want to get the maximum value in each column and match it with the
corresponding cell (same row but from Column A).

Best

Maybe:

=index($A1:$A600,match(max(b1:b600),b1:b600,0))

copy it across for all the columns to U

"karim" wrote:

I have
21 columns A to U, and 600 rows.

I want use look up function for the maximum to return the value from the
first column (A) from the same position in each column without ordering each
one . Do you know a quick easy way to do it?

Means I want to get the maximum value in each column and match it with the
corresponding cell (same row but from Column A).

Best