Formula to pull the last cell in a column

[Daniid03]

Good Afternoon,

I am working on a multiple tab worksheet where I am using a formula to count all the blanks in a column. I am using the formula =COUNTBLANK(D2:D500). However, since my file has multiple tabs with all different row counts, I would like a formula that would automatically pull the last row #. Is there a formula to add to the end of the count black formula so it'll automatically pull the last cell that has text?

Hopefully that makes sense. Thank you for your help.

[Tsjallie]

Have you considered using tables instead of ranges? Then it would be easy.
Can't think of a way of doing it in a formula with just ranges.

[dosydos]

question: The cells that have text, are they separated by blank cells throughout or do the blank cells start to occur after the last cell of text?

[Tony Valko]

This will return the last (bottom-most) row number that contains a TEXT entry...

=MATCH("zzzzz",D:D)

[Daniid03]

Thank you for your response and good question! There are blanks all through the column so I want to count those blanks, however, do not want to count the blanks that appear after the last cell of text, if that makes sense.

[Daniid03]

That helps so much. Thank you!!

[Tony Valko]

You're welcome. Thanks for the feedback!