Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 60
  • Last Modified:

How to count number of rows in an excelsheet

Hello,
How to count number of rows filled with data in an excelsheet?
0
RIAS
Asked:
RIAS
  • 3
  • 3
1 Solution
 
Ryan ChongCommented:
check this out:

Find last row, column or last cell
http://www.rondebruin.nl/win/s9/win005.htm
0
 
RIASAuthor Commented:
Ryan Chong,
Thanks ,how do i get it by excel formula in the excel worksheet?
0
 
Ryan ChongCommented:
>>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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
RIASAuthor Commented:
where do i actually add
=COUNTA(A1:A1000)
0
 
Ryan ChongCommented:
where do i actually add
=COUNTA(A1:A1000)
just make it as an Excel formula...
28967719.xlsx
0
 
RIASAuthor Commented:
Brilliant mate!!Cheers!
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now