# Get instant live expert help on I need help with excel count words

“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 would like to create a character counter that will automatically count once I type the words in a cell.
Solved by X. J. in 24 mins
I have two different columns with some words. I need to excel 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
=INDEX(A1:A17,SMALL(IFERROR(ROW(INDIRECT("1:"&COUNT(A1:A17)+COUNTBLANK(A1:A17)))*IF(A1:A17="","",1),""),ROW(INDIRECT("1:"&COUNT(A1:A17))))) Can you help me explain in words what this formula is doing?
Solved by B. J. in 25 mins
I need to count the occurrence of every word in my spreadsheet. Or get a list of unique words in the spreadsheet so I can isolate the ones i need to count the occurrence of.
Solved by S. W. in 21 mins
I NEED A FORMULA TO CONBINE COLUMN D WITH I BUT IF D HAS DIFRENT WORDS LIKE ANSH AND AFNW but I just want to count ANSH and with the column I COUNT THE ONES WITH GREEN CONBINE WITH THE ANSH D CELL..
Solved by I. Q. in 25 mins