<div>
check this out:<br />
<br />
Find last row, column or last cell<br />
<a href="http://www.rondebruin.nl/win/s9/win005.htm" rel="ugc">http://www.rondebruin.nl/win/s9/win005.htm</a>
</div>


check this out:

Find last row, column or last cell
http://www.rondebruin.nl/win/s9/win005.htm [http://www.rondebruin.nl/win/s9/win005.htm]

<div>
Ryan Chong,<br />
Thanks ,how do i get it by excel formula in the excel worksheet?
</div>


Ryan Chong,
Thanks ,how do i get it by excel formula in the excel worksheet?

<div>
&gt;&gt;how do i get it by excel formula in the excel worksheet? <br />
sorry, i could be missunderstood your question.<br />
<br />
to do it in excel, just use <b>COUNTA </b>function, like:<br />

<pre><code id="code-20-41784506-1">=COUNTA(A1:A1000)</code></pre>
</div>


>>how do i get it by excel formula in the excel worksheet?
sorry, i could be missunderstood your question.

to do it in excel, just use COUNTA function, like:


=COUNTA(A1:A1000)

<div>
where do i actually add <br />
=COUNTA(A1:A1000)
</div>


where do i actually add
=COUNTA(A1:A1000)

28967719.xlsx

<div>
<div class="content wysiwyg-content">
Hello,<br />
How to count number of rows filled with data in an excelsheet?
</div>
</div>


Hello,
How to count number of rows filled with data in an excelsheet?

How to count number of rows in an excelsheet

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.