Thread: Advanced Filter
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Steve D Steve D is offline
external usenet poster
 
Posts: 22
Default Advanced Filter

I have a large worksheet with names, social security number & birthdate
(multiple entries per person). I am trying to use the Filter/Advanced Filter
and show a persons name, ssn & birthdate only once.

There appears to be something in the columns that is causing "some" of the
names multiple times. I have tried importing the data into Access and it is
having some problems with some of the data element in the columns.

Is there any tool that can correct the data in individual columns?