Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 209
  • Last Modified:

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.
0
DavidH7470
Asked:
DavidH7470
1 Solution
 
barry houdiniCommented:
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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now