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

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