is this applicable for dates too? I'm looking at range in a row say n2:r2,
if there is a non blank cell with a date then I want it to populate in q2.
Can anyone help please?
thanks
--
Afia


"Gary''s Student" wrote:

=MAX(E4:N4)

if all are blank except one cell
--
Gary''s Student - gsnu200736


"Sal" wrote:

Hi,

I am looking for a formula that will examine cells E4:N4 and return the
value of the one cell that is not blank in that range to cell P4.

Any ideas?

Thanks