| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare two lists; return only unique records | Excel Worksheet Functions | |||
| Return Unique Records ... No Blanks | Excel Discussion (Misc queries) | |||
| extract unique records from one column | Excel Worksheet Functions | |||
| unique filter results in some non-unique records. | Excel Discussion (Misc queries) | |||
| In column A I have duplicate records. How do I tag an unique reco. | Excel Discussion (Misc queries) | |||
Threaded Mode
