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

how to make horizontal coloum to vertical

Solved by T. B. in 20 mins

how to do v look up, how to make amount in words,

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

Column C has the word Jump I am looking for. Column F has the word USA I am looking for. How do I find the count for the exact 2 words from 2 different columns. I hope I make sense. Read it a few times

Solved by K. J. in 16 mins

I have two different columns with some words. I need to count rows where: 1) in the first column's cell there is one word of a set of some words OR 2) in the second column's cell there is one word of a different set of some words What formula can I use?

Solved by Z. H. in 21 mins