Address of the last cell in a column that contains data with blank cells in the column

I would like to have a formula that gives the row number of the last cell containing data in a column.  That column will have blank cells between data in that column.
DavidH7470Asked:
Who is Participating?
 
barry houdiniConnect With a Mentor Commented:
Try this to give the row number of the last populated cell in A1:A1000

=MATCH(2,INDEX(1/(A1:A1000<>""),0))

extend range as required, in Excel 2007 and later versions you can use A:A for whole column.....

regards, barry
0
 
DavidH7470Author Commented:
Great.  Thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.