View Single Post
  #2  
Old August 31st, 2004, 02:51 AM
Bob Umlas, Excel MVP
external usenet poster
 
Posts: n/a
Default

Excel assumes that the top entry is a header. If it's ALL data, you'd be
better off if you insert a row and enter headers.

"L Mehl" wrote:

Hello --

I want a list of unique values in a column (one column in a worksheet) for
further processing.

I use Advanced Filter - Unique Records Only in a recorded macro and it
correctly processes the list, except for showing the first value twice; the
remaining unique values are correct.

Macro code is:
Range("app_category").AdvancedFilter _
Action:=xlFilterCopy, _
CriteriaRange:=Range("criteria"), _
CopyToRange:=Range("extract"), _
Unique:=True

Values in the source column "app_category" are sorted.
The Criteria range is two stacked cells; the top cell is named "criteria";
the cell below that is blank.
The Copy To range is named "extract" and is blank. I did not enter a column
name because only one column is being processed. If I enter the column name
there, the macro generates the error "The extract range has a missing or
illegal field name."

Can anyone suggest what is causing the duplicate of the first entry?

Thanks for any help.

Larry Mehl