find last row with a value in a column interspersed with blanks

I have a colum of up to 5000 possible entries and I need to find the row number with last non blank value. If row 1 = 'A' , row 5 = 'B' and row 10 = 'C' with rows 2-4, 6-9 blank, I need a combination of functions to come to Row(10). The last value is not the largest and I can't use helper cells to get it into a sorted order.

Thanks for any suggestions

Hi,

Try this array formula:

Formula:

Please Login or Register  to view this content.

To enter an array formula, you must use Ctrl + Shift + Enter, not just Enter. Let me know if you have any trouble getting this to work.

I hope this helps

Thank you, that worked fine.

This is resolved but I can't find the way to close it

You're welcome.

Thread tools --> Mark as Solved

Also, please don't forget to click on the * next to my post to say thanks and add to my reputation