I am filtering a list for unique values using Advanced Filter. Once I filter
the first value shows up in the list twice....
A1 Cat
A2 Cat
A3 Dog
A4 Bird
A5 Snake

If I reference the first occurence of Cat (A1) in a formula in B1 such as
=a1 ="Cat", the formula is changed to EXTRACT = "CAT". What is this and how
do I get rid of it. I dont need 2 occurences of CAT

Thanks