| Home |
| Search |
| Today's Posts |
|
#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 |
| 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 | |||
Threaded Mode
