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?

It sounds like it's the other information that is creating unique rows which
would cause every perons's name, b-day and ssn to come up multiple times. If
you are trying to view all the information, but only see each person's name
once, try sorting your data so that these three criteria are together, then
use conditional formatting so that if a cell is equal to the cell above, the
text is white. This way the information will appear to only display once
(though it is still present in the cell).

If you want a report based on each person, with unique information listed
below, you'll probably want to use Access and build a report with the report
hierachy structured to list each individual once, then the extra information
listed below.
--
HTH

JonR


"Steve D" wrote:

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?