Sorry, I meant to say it 'DOES WORK on a range'

"Sheeloo" wrote:

Advance Filter does not work on a range
Select your range with headers
Choose Data|Filter|Advanced Filter
Select Unique Records
Click on Col A after clicking on Criteria Range...

"sahafi" wrote:

I have a data list on 10 columns. I'd like to fitler and remove the the
duplicates based on col A only. Advance filter will filter single col. How
can I keep unique codes on col A and remove all the duplicates codes in colA
along with the rest of the records on the other 9 colunms?

Thanks.
--
when u change the way u look @ things, the things u look at change.