View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sahafi sahafi is offline
external usenet poster
 
Posts: 108
Default Filter for unique values in multiple columns

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.