Solved

How to count number of rows in an excelsheet

Posted on 2016-09-05
6
38 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 49

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 49

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
How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

 

Author Comment

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

Accepted Solution

by:
Ryan Chong earned 500 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

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
This article will show you how to use shortcut menus in the Access run-time environment.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

706 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now