Copy Unique records

[Soniya]

Hi All,

whenever i use advance filter option to copy unique
records form my column a to column c the first record
always comes twice. all the remaining is ok.

can any one help me on why this hapen?

Soniya

 

[Hank Scorpio]

whenever i use advance filter option to copy unique
records form my column a to column c the first record
always comes twice. all the remaining is ok.

can any one help me on why this hapen?

Best guess; you don't have a column header at the top of column A.
When you first select the range, do you see a message which begins
"Excel cannot determine which row in your list... contains column
labels"? If so, and you go ahead and select [OK], Excel will interpret
the first row as being the header. It will therefore come across
twice; once as the header, and once as one of the data items. The
solution is to put a header (or title, call it what you want) at the
top of column A before you perform the operation.