Excel 2002: How to Select Greater Value of Numerous Cells?

[Guest]

I have created a saving comparison spreadsheet. I have 5 vendors bidding to
provide replacement OEM parts at a reduced price. Now I need to select the
vendor (cell) which has the greatest savings (value).

So, I want to look at 10 cells in a row and select the cell which has the
greatest value number.

Thank-you in advance!

Walt

 

[Guest]

Hi,

=max(A1:J1)


Mike

 

[Rick Rothstein \(MVP - VB\)]

I have created a saving comparison spreadsheet. I have 5 vendors bidding to

provide replacement OEM parts at a reduced price. Now I need to select the
vendor (cell) which has the greatest savings (value).

So, I want to look at 10 cells in a row and select the cell which has the
greatest value number.

I'm not sure I understand your layout... you have 5 vendors but want to look
at 10 cells in a row?

Rick

 

[Guest]

WOW!

That works great. I knew there must have been a simple formula for this
task. Just to let you know how I ended up doing this I am going to paste my
partial solution to do the same task. I had to break this formula into halves
because one formula for eight cells was too large.

"=IF(P103>IF(O103>IF(N103>M103,N103,M103),O103,IF(N103>M103,N103,M103)),P103,IF(O103>IF(N103>M103,N103,M103),O103,IF(N103>M103,N103,M103)))"

Can you believe this humongous formula does the same thing a
"=MAX(M103103)" ;-)

Thanks Mike!

 

[Guest]

Thanks for trying, Rick.

Mike helped me out.

Walt