Thread: Conditional MAX
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
IanC[_2_] IanC[_2_] is offline
external usenet poster
 
Posts: 157
Default 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
--