Filer for unique records and return all column data for unique rec

B

bseeley

I have thirteen columns and 18,000+ rows of data. What I would like to do is
filter for unique records based on two of the columns and then copy those
unique records to another location along with the remaining corresponding
column data for that unique record. I am hoping to use two columns for
filtering, that way I am less likely to remove clients with the same name but
not the same DOB. So for example:

Beginning with . . .

Client Name DOB Ethnicity
Jane Smith 8/13/1991 White
Maria Hernandez 1/03/1980 Hispanic
Jane Smith 8/13/1991 White
Maria Hernandez 2/16/1980 Hispanic

And get . . .

Client Name DOB Ethnicity
Jane Smith 8/13/1991 White
Maria Hernandez 1/03/1980 Hispanic
Maria Hernandez 2/16/1980 Hispanic

Is that possible? Thank you!
 
D

Dave Peterson

If you're using xl2007, you copy the entire range and then choose the "remove
duplicates" on the data group of the ribbon.

If you're using an older version, you could add another helper column with a
formula like:
=a2&"..."&text(b2,"mm/dd/yyyy")

Then I could drag that down as far as I needed and use that to filter my data.

Then add another helper column with a formula like:
=countif($x$2:$x2,x2)
(where x was the column letter for the first helper column.)

Drag down and filter by this column to show just the 1's.

Then copy those visible cells to a new location.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top