| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional MAX
I need to find the maximum value in column C where there is also data (a
date) in column D,E or F. How do I find the row number for the maximum value in columns D-F? I need to find the value of column C in this row. Alternatively, how can I find the maximum value in column C in black characters (other data appears in blue)? Aternatively, how do I find the last row containing data in column D,E or F? Many thanks. -- Ian -- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| New Conditional Format Overriding Previous Conditional Format | Excel Discussion (Misc queries) | |||
| Conditional Rank (or rather, Conditional Range) | Excel Worksheet Functions | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
![IanC[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
