If I understand what you want, try this array formula** :

=MAX(IF((D2:D20<"")+(E2:E20<"")+(F2:F20<""),C2: C20))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.

--
Biff
Microsoft Excel MVP


"IanC" wrote in message ...
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
--