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

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

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

Hi,

=max(A1:J1)


Mike

"Walt" wrote:

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

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

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

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

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(P103IF(O103IF(N103M103,N103,M103),O103,IF( N103M103,N103,M103)),P103,IF(O103IF(N103M103,N1 03,M103),O103,IF(N103M103,N103,M103)))"

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

Thanks Mike!

"Mike H" wrote:

Hi,

=max(A1:J1)


Mike

"Walt" wrote:

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

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

Thanks for trying, Rick.

Mike helped me out.

Walt

"Rick Rothstein (MVP - VB)" wrote:

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