| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting text into numerous cells for many different files | Excel Discussion (Misc queries) | |||
| want to apply function to numerous cells | Excel Discussion (Misc queries) | |||
| Cells User Select Locked after upgrade to Excel 2002 | Excel Discussion (Misc queries) | |||
| Copying Info Into Numerous Cells | Excel Discussion (Misc queries) | |||
| How do I add the same text to numerous existing cells | Charts and Charting in Excel | |||
Hybrid Mode
