Advanced Filter

[Soniya]

Hi all,

When I use Advanced filter to copy Unique items Excel
always take the first item appears reapeated (twice)? !!!

I am useng office XP

TIA
Soniya

 

[Debra Dalgleish]

The first cell at the top of the list should contain a heading, not the
first item. If you don't have a heading on your list, the first item is
treated as a heading and, if it appears again in the list, it will be
added as a unique item.