“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

I have a section of my sheet about 400 rows by 16 columns. In some cells, there is text = "High School Presentation". I would like to count how many rows have "High School Presentation" but exclude any duplicates within each row

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