I believe you're getting closer. With this formula, Excel will only
recognize the starting range, but not anything else.

What I have is a list of bills in Column C, their dates in Column D, their
amounts in Column E. In Column F, I have the formula:

=if(B#<"",B#,"") - where # represents the cell I'm working on (I then do
this with Columns D & E ). What this does is, if B# is checked, Excel will
display the name of C, D, E.

After this, I had a formula:

=IF(D5<"",D5,IF(D6<"",D6,IF(D7<"",D7,"")))

Excel would display in the cells of Column D.

Thanks to CLR, I was able to get away from having to check mark Column B,
before anything displaying somewhere else. Now if I could figure out how to
display the contents of Column D without typing all those if statements, it
would be great.

Personally, with your help, I'm getting closer to solving this problem
that's been bugging me for days (problem with Excel that is, not my mental
one :) )

Thanks again for your help.




"Stefi" wrote:

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