I have a long list of data that includes repeats, something like this: A, B, B, C, D, D etc. What formulas or functions can I use to do the following?
1. Count just the unique items? (in the above example, that would be: 4)
2. Create a list of all the unique items? (in the above example, that would be: A, B, C, D)