A Formula to Return the best out of two sets of data.

[JonWilf]

Formula Needed.xlsx

I'm struggling with what formula I would need to look at these two columns and return the best (highest) out of the two?

If for example we have -2 and 4 I would like the formula to return the 4, but then if the next row was -10 and -2 I would like the formula to return -2.

I am usually confident with excel, I know the answer is staring me in the face but my mind has gone blank on this one so any help will be appreciated and paid with kindness.


Cheers

[mcmahobt]

As in, you need the highest value out of both of the two columns (14 being the answer in your example data)?

If so, is something like this what you're looking for?

Please Login or Register  to view this content.

If you need a row-by-row comparison, paste into C2 and drag down:

Please Login or Register  to view this content.

[alansidman]

=MAX(A2:B2) and copy down

[JonWilf]

I knew that I knew it, had a blank moment.

As always a quick response. Thank you guys