What type of data is it? Is it text or a number or can it be either?

--
Biff
Microsoft Excel MVP


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