ExcelBanter - Copy Unique records

On Tue, 25 May 2004 04:16:01 -0700, "Soniya"
wrote:

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.

---------------------------------------------------------
Hank Scorpio
scorpionet who hates spam is at iprimus.com.au (You know what to do.)
* Please keep all replies in this Newsgroup. Thanks! *