Get instant live expert help on how many rows are there in excel

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I have a huge dataset. There are many GEO ID numbers in the large data set, with corresponding crucial information in their respective rows. However, there are about 4x too many numbers in that data set; I have another excel spreadsheet with the GEO ID numbers of the ones that I actually need, but that sheet doesn't have the crucial information that exists in the larger one, in their rows.
Solved by Z. H. in 24 mins
Need to count how many rows with specific data are shown as late in other column
Solved by I. D. in 28 mins
I have a large Excel file, about 150MB, with many formulas. In excel 2007, we were able to insert and delete rows fine. In our current Excel, v2016, inserting or deleting rows takes anywhere from 30 seconds to a few minutes. Is there any way we can solve this? The delay in inserting/deleting rows makes many macros unusable.
Solved by M. C. in 25 mins
Hey, I've got a question. I have about columns consisting of 315 rows. Some rows have values in them, some don't. How can I create a formula to show me how many values are in all three rows, combined?
Solved by C. C. in 18 mins
I am trying to count how many rows in individual columns have a specific background color. is there a simple way of doing this?
Solved by Z. W. in 29 mins