Forum Discussion
Solved
Excel Formula
Is there a Formula that can return the most used word in a Column? Ex. Column E is preferred language. How can I get excel to return the most used language in Column E
The formula doesn't work if the range contains blanks.
Here is an alternative that works even with blanks:
In F2:
=COUNTIF($E$2:$E$170,$E2)
Adjust the range if necessary, then fill down.
In G2:
=MAX(F2:F170)
In H2:
=INDEX(E2:E170,MATCH(G2,F2:F170,0))
I tried that earlier, I get #N/A error
The formula doesn't work if the range contains blanks.
Here is an alternative that works even with blanks:
In F2:
=COUNTIF($E$2:$E$170,$E2)
Adjust the range if necessary, then fill down.
In G2:
=MAX(F2:F170)
In H2:
=INDEX(E2:E170,MATCH(G2,F2:F170,0))
- It worked.. Thank you so much. 🙂
- I used your example and added columns, it worked!!! TY