I’m part of a small employee engagement committee at my place of work, we decided to play scattergories over email. Instead of counting each individual word, I was curious if there was a way to assign the word a numerical value of 1 while omitting the duplicate words. I know how to conditional format to highlight the cell to show the duplicate values, but I don’t know how to get excel to count words-especially omitting the duplicate values.