<div>
<div class="content wysiwyg-content">
I have an excel spreadsheet that is constantly being updated and I need a formula for determining the number of entries in each column. &nbsp;Again, I would much prefer a formula rather than a macro. &nbsp;I don't need to know any values, just the number of populated cells in a column. &nbsp;Note that there are no null cells in the column so essentially I just need to know the index of the last cell (minus 1 for the header).<br />
<br />
Thanks!
</div>
</div>


I have an excel spreadsheet that is constantly being updated and I need a formula for determining the number of entries in each column.  Again, I would much prefer a formula rather than a macro.  I don't need to know any values, just the number of populated cells in a column.  Note that there are no null cells in the column so essentially I just need to know the index of the last cell (minus 1 for the header).

Thanks!

Find Number of Populated Cells in an Excel Column

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.