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

x
?
Solved

How to count number of rows in an excelsheet

Posted on 2016-09-05
6
Medium Priority
?
57 Views
Last Modified: 2016-09-05
Hello,
How to count number of rows filled with data in an excelsheet?
0
Comment
Question by:RIAS
  • 3
  • 3
6 Comments
 
LVL 54

Expert Comment

by:Ryan Chong
ID: 41784478
check this out:

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

Author Comment

by:RIAS
ID: 41784502
Ryan Chong,
Thanks ,how do i get it by excel formula in the excel worksheet?
0
 
LVL 54

Expert Comment

by:Ryan Chong
ID: 41784506
>>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)

Open in new window

0
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 

Author Comment

by:RIAS
ID: 41784507
where do i actually add
=COUNTA(A1:A1000)
0
 
LVL 54

Accepted Solution

by:
Ryan Chong earned 2000 total points
ID: 41784511
where do i actually add
=COUNTA(A1:A1000)
just make it as an Excel formula...
28967719.xlsx
0
 

Author Closing Comment

by:RIAS
ID: 41784519
Brilliant mate!!Cheers!
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article describes a serious pitfall that can happen when deleting shapes using VBA.
This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
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