Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2011-09-08
2
Medium Priority
?
206 Views
Last Modified: 2012-05-12
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
Comment
Question by:DavidH7470
2 Comments
 
LVL 50

Accepted Solution

by:
barry houdini earned 2000 total points
ID: 36504817
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
 

Author Closing Comment

by:DavidH7470
ID: 36505045
Great.  Thank you.
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

885 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question