Advanced Filter

  • Thread starter Thread starter Soniya
  • Start date Start date
S

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
 
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.
 
Back
Top