Find last text value in column

[arthur w. mohr, jr.]

I have an excel 2000 spreadsheet that has text data in a column. Not all
fields are filled, in other words, there are gaps in the data.

I want to write a formula (not VB code if possible) that allows me to find
the last TEXT value entered in the column.

I have used the offset/max formula described at the MS Knowledge Base but
this formula does not seem to work with text.

Can anyone help?

Thanks. Art.

[Tom Ogilvy]

This is what I posted in Microsoft.Public.Excel.Programming to your post
there:

There are hundreds of Knowledge Base articles, so it would be helpful if you
cited which one or showed the formula you tried.

If you don't want a VB solution, why post in Programming? [Oh, now I see
you posted in more than one group]

=Index($A$1:$A$500,Max(if(istext($A$1:$A$500),Row($A$1:$A$500))),1)

Entered with Ctrl+Shift+Enter rather than just enter display the last text
value in column A. Extend the range if you will have more than 500 rows.

Regards,
Tom Ogilvy

arthur w. mohr, jr. <fam...@mohrtimes.com> wrote in message
news:af1mf3$ob8$01$1...@news.t-online.com...