Try this:
=IF(ISERROR(MATCH("*",D:D,-1)),"all cells in column D are
empty",INDEX(D:D,MATCH("*",D:D,-1)))

Regards,
Stefi

€žTrackeous€� ezt Ã*rta:

Thanks for replying, but no cookie yet. Right now, Excel is giving me an
"N/A". I need to do some research on the "Index" to see what it does and how
it works. To bad that I can't use something simple like:

=text(d1:d2000)

Oh well, life is not always that simple, is it?

Thanks again,

Scott

"Stefi" wrote:

If there is only one entry in Column D then

=INDEX(D:D,MATCH("*",D:D,-1))

will return it.

Regards,
Stefi

€žTrackeous€� ezt Ã*rta:

Is there an easier way to write a formula that does the same other than:

=IF(D1<"",D1, IF(D2<"",D2, IF(D3<"",D3, Etc,""))))

so that Excel will display the contents of anything displayed in Column D?
Generally, there should only be one entry in Column D.

Thanks