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

How to transpose columns to rows and insert new rows to fill down data in Excel?

Solved by G. Q. in 18 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 have a number of words in different rows and columns and I'm trying to use a pivot table to tell me how many times the individual words are repeated in each of the columns. I thought I had it counting that, but it was actually counting how many times the word came up in the first column and then how many times any of the words came up in the same row in later columns. Does that make sense?

Solved by F. F. in 27 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

I need to analyze how many rows contain certain sets of data. For example how many rows contain only 1s vs rows that contain 2s and 3s as well.

Solved by T. J. in 22 mins