I'm having problems using the "Unique record" function in the "advanced auto filter".
When trying to filter a list of values, it is not completelly filtering the first value in the list.
If I have a list of...
A
A
A
B
B
B
C
C
C
... the filtered result will come up as...
A
A
B
C
...leaving 2 instances of the first value.
I've also tried using a wider range including one empty cell above the list, but the result is the same.
I didn't have this problem before!!
WHAT IS GOING ON?
Thanks for your advice.
Bookmarks