How can I filter for unique values in a particular column (disregarding the values in the other columns for that row, and so the first instance of a new value would be fine)?
So, for example:
1 2 3
A 10 a a2
B 10 g a3
C 20 h a3
D 20 k a3
E 20 l b4
F 40 m n6
G 40 q q2
I would want my filter to show just rows A, C, and F.
Is there an easy way to do this?
Best Answer