Last cell with data, not last cell with formula

I'm setting up a View Only workbook for some users who only need to view the data in another workbook that has users constantly updating.

My view only workbook (VW) is simply links to the WB being updated (UpD). UpD currently has 1000 lines, but will probably wind up with about 4000 by the end of the year, so in VW I link down to row 5000 to be on the safe side.

My problem is that for a Viewer they can't go to, for instance, A1 and hit Ctrl Down Arrow to arrive at the last populated cell, because that takes them to row 5000, whereas the actual data ends at row 1000.

So, I'd like to display a graphic saying something like "Row 1148 is the LAST Populated row" so they'll have an idea of how far down to drop. My problem is I don't know how to formulalaicly determine the last row containing real data.

BTW, I've turned off the display of zeros for links that contain no data, so the cells after the real data appear empty.

Any help would be appreciated.

There are instructions at the top of the page explaining how to attach your sample workbook.

Okay, wasn't going to attach because it has a lot of privileged info, but I stripped it down pretty good, so it's attached now. Hope it helps show the problem.

Try this:

=MATCH("zzz",A:A)

or this:

="Row "&MATCH("zzz",A:A)&" is the LAST Populated row"

Holy Moley, easy and spot on! That solves me.

You know, I was born in England, but left there when I was 2, so never realized how bright some of the people there are. Thanks for enlightening me!

Always pleased to support one of our less able Stateside cousins ...

Bright and sarcastic!

You're allowed to be sarcastic when you're bright enough to carry it off.

But, with that said, I don't think sarcasm is one of the virtues.

I don't really care.

Glad to have helped.