Unique string values in range
- by Dean Smith
I have some spreadsheets where there are large number of cells that have essentially been used for free text.
There is a finite set of values for this free text and most, if not all repeat.
eg.
A B C D
1 Monkey Gorilla Cat Dog
2 Dog Cat Gorilla Gorilla
3 Dog Dog Dog Cat
There are probably…