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!
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!