| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Select max value from 9 cells, copy cell col heading to other cell
Hi,
I've selected the maximum value from 9 cells in a row using: =IF(BA3="","",MAX(DQ3,DR3,DS3,DT3,DU3,DV3,DW3,DX3, DY3)) and placed that max value in cell DZ3. I now want to auto-insert the column heading from above that max value cell (DQ3 to DY3) into cell EA3 (Again if cell BA3="" (blank), I want "" returned Can't use a nested IF formula as 9 IFs being tested (only 7 allowed in Excel 2003). Can anyone help with a formula please? Regards, Steve. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| select dependent cells in the result cell | Excel Discussion (Misc queries) | |||
| How do I randomly select cells regardless of cell content? | Excel Worksheet Functions | |||
| Using formulas to select cells (Ex: Select every nth cell in a col | Excel Discussion (Misc queries) | |||
| How to copy single cell into cell that is merged from two cells? | Excel Discussion (Misc queries) | |||
| Select cell, Copy it, Paste it, Return to Previous cell | Excel Discussion (Misc queries) | |||
![Struggling in Sheffield[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
