The 1st item in the Unique list is considered the heading so it takes 'Cat'
in A1 as the Heading then looks at the rest of the list [A2:A5], sees 'Cat'
in the 'detail' and lists it again. To correct this, either add a heading in
Cell A1 and drop the list down one row or put a blank in Cell A1 and drop the
list down one row.
--
Hope this helps.
Thanks in advance for your feedback.
Gary Brown


"Steve" wrote:

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