View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
bseeley bseeley is offline
external usenet poster
 
Posts: 4
Default Filer for unique records and return all column data for unique rec

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!