find biggest numbers in row

  • Thread starter Thread starter Joe
  • Start date Start date
J

Joe

Is there a way in excel to scan across certain columns, per row and find the
highest value?

EG:

Col1, Col2, Col3, Col4
24, 88, 77, 66
32, 72, 21, 88
11, 98, 12, 29

I want it to only look at Col1 and Col3 and return the highest value and
place it at the bottom of my sheet.

So it would have found 77, 32, 12
 
Hi Joe,

It's not entirely clear what you are trying to achieve.

=MAX(A1,C1)
placed in any cell on your sheet and then dragged down
will return the correct result as per your example.

Or do you want it to achieve the same result when you drag
it across rather than down? Or do you want the result
all in one cell?

I think we need some more info here. What exactly
do you mean by place it at the bottom of my sheet?

HTH
Martin
 
Back
Top