Question description:
This user has given permission to use the problem statement for this
blog.
I need to count the number of data/rows in a sheet
Solved by O. U. in 37 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
User
14/06/2018 - 03:53
Hello!
Excelchat Expert
14/06/2018 - 03:53
Hello, welcome to got it pro.
User
14/06/2018 - 03:53
Here is the file, please downlaod
User
14/06/2018 - 03:53
https://drive.google.com/file/d/1QeBpD_Bkkx5Jirtt1oNkUux5g__lFsEP/view?usp=sharing
Excelchat Expert
14/06/2018 - 03:54
Wow, this is a big file indeed.
Excelchat Expert
14/06/2018 - 03:54
Downloading now.
User
14/06/2018 - 03:55
sorry, just seen the size of the file
Excelchat Expert
14/06/2018 - 03:56
I would take 8/10 minute on my pc to download the file. :'(
User
14/06/2018 - 03:57
ok np
User
14/06/2018 - 03:58
just to brief you about the project
Excelchat Expert
14/06/2018 - 03:58
I'm listening...
User
14/06/2018 - 03:58
there are around 34 sheets in the file.. 33 with the data in it + 1 with the overview and link to all file
User
14/06/2018 - 03:59
what I need is
User
14/06/2018 - 03:59
I want to know the number till where the last row of a sheet is filled
User
14/06/2018 - 04:01
like if sheet1 have data in it from A1 to H1 till A100 to H100....sheet2 A1 to H1 till A200 to H200
User
14/06/2018 - 04:02
I want to see in overview sheet: Sheet1 = 100 and sheet2=200 and so on
User
14/06/2018 - 04:02
Am I making anysense?
Excelchat Expert
14/06/2018 - 04:02
Yeah totally.
Excelchat Expert
14/06/2018 - 04:03
I'm just not sure If I can do that or if it is possible to do with formula.
User
14/06/2018 - 04:03
great :)
Excelchat Expert
14/06/2018 - 04:03
Please give me some time.
User
14/06/2018 - 04:03
ok
User
14/06/2018 - 04:03
please try
User
14/06/2018 - 04:03
sure, take you time :)
Excelchat Expert
14/06/2018 - 04:03
I'm trying my best. I think it would take another 3/4 minutes to finish the download and then I will make attempt.
Excelchat Expert
14/06/2018 - 04:05
I have read your problem overview again, you just looking for the row count, right? Please correct me if I'm wrong.
User
14/06/2018 - 04:06
yes correct
User
14/06/2018 - 04:06
row count till where the data is fille
Excelchat Expert
14/06/2018 - 04:06
Thank you for confirming.
User
14/06/2018 - 04:06
*filled
Excelchat Expert
14/06/2018 - 04:07
download finished.
User
14/06/2018 - 04:07
great!
User
14/06/2018 - 04:09
please work on it and I will be away from the system for few mints
User
14/06/2018 - 04:09
hope, I have cleared everything up
Excelchat Expert
14/06/2018 - 04:09
Everything is clear.
User
14/06/2018 - 04:09
I am extending the time for you
Excelchat Expert
14/06/2018 - 04:09
Please extend the time before you go.
Excelchat Expert
14/06/2018 - 04:09
Thank you.
User
14/06/2018 - 04:10
Done
User
14/06/2018 - 04:10
Welcome :)
Excelchat Expert
14/06/2018 - 04:19
=COUNTA(INDIRECT("'"&A2&"'!A:A"))
Excelchat Expert
14/06/2018 - 04:20
Please use this formula in D2 of Kutools for Excel sheet.
Excelchat Expert
14/06/2018 - 04:20
And then copy the formula for the rest of the cells to get count for every other sheets.
User
14/06/2018 - 04:24
D2?
User
14/06/2018 - 04:25
ok
User
14/06/2018 - 04:25
got it
Excelchat Expert
14/06/2018 - 04:25
=COUNTA(INDIRECT("'"&A2&"'!A:A")) this formula will give you the count of rows in sheet name of cell A2.
User
14/06/2018 - 04:25
thanks :)
Excelchat Expert
14/06/2018 - 04:26
Great.
Excelchat Expert
14/06/2018 - 04:26
I'm happy to be able to help.
Excelchat Expert
14/06/2018 - 04:27
Do you have any question?
User
14/06/2018 - 04:27
just want to know was that a easy task or use of Kutools helped you. I want to see whether buying the software was useful for me or not :)
Excelchat Expert
14/06/2018 - 04:28
I have no idea what kutools offering. But yeah, it was easy for me to write the formula once I got the problem clearly.
Excelchat Expert
14/06/2018 - 04:29
And of course I haven't used Kutools never even this time.
User
14/06/2018 - 04:29
ok :)
Excelchat Expert
14/06/2018 - 04:29
Anything else?
User
14/06/2018 - 04:29
thanks for your quick solution
Excelchat Expert
14/06/2018 - 04:29
Thanks for your patience, my apologies for the relatively slow internet connection I'm using.
Excelchat Expert
14/06/2018 - 04:30
Otherwise I would have provided the solution much earlier.
User
14/06/2018 - 04:30
I got the solution..All good
Excelchat Expert
14/06/2018 - 04:30
Please close this chat now.
User
14/06/2018 - 04:30
ok bye
Excelchat Expert
14/06/2018 - 04:30
Thanks and have a great day!
User
14/06/2018 - 04:30
have a nice day..cheers!!!!
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.