Advanced Filter
 

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

Advanced Filter
 

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.

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

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html