find biggest numbers in row

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joe - 30 Nov 2007 22:30 GMT

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

Reply to this Message

RagDyer - 30 Nov 2007 23:02 GMT

Try this:

=MAX(A:A,C:C)

Signature

HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

> Is there a way in excel to scan across certain columns, per row and find
> the highest value?
[quoted text clipped - 10 lines]
>
> So it would have found 77, 32, 12

Reply to this Message

MartinW - 01 Dec 2007 10:45 GMT

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

> Is there a way in excel to scan across certain columns, per row and find
> the highest value?
[quoted text clipped - 10 lines]
>
> So it would have found 77, 32, 12

Reply to this Message

Rate this thread: