Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
deduplicate rows matching three columns
I have a worksheet of names, DOB, and address info, among other items. I've
been asked to provide this list, minus another list having lastname, firstname and DOB, and other items not in my worksheet. I can live with small nits. I am probably going to get this request again, or be asked to redo it differently, so I want something that is as good as it gets with data from different sources. I do not see how I can match three different columns with the lookup functions. ________ Greg Stigers, MCSA remember to vote for the answers you like |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
deduplicate rows matching three columns
Look at Example 4:
http://www.contextures.com/xlFunctions03.html Alternative, you could try using a Pivot Table. http://www.contextures.com/xlPivot02.html http://www.contextures.com/xlPivot08.html Regards, Ryan--- "G" wrote: I have a worksheet of names, DOB, and address info, among other items. I've been asked to provide this list, minus another list having lastname, firstname and DOB, and other items not in my worksheet. I can live with small nits. I am probably going to get this request again, or be asked to redo it differently, so I want something that is as good as it gets with data from different sources. I do not see how I can match three different columns with the lookup functions. ________ Greg Stigers, MCSA remember to vote for the answers you like |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
deduplicate rows matching three columns
My worksheet has the following columns:
Last Name, First Name, middle, suffix, DOB, Phone, address1, address2, city, state, zip The worksheet that has the data I need to remove from my worksheet has: Last Name, First Name, DOB The data is small enough that a match in the second sheet is almost certainly the same person as in the first sheet. So if for the three columns in the second sheet, I can remove the corresponding row in the first sheet, that meets the need. In fact, a match on last name and DOB is probably close enough. ________ Greg Stigers, MCSA remember to vote for the answers you like |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 - change columns to rows and rows to columns | Excel Discussion (Misc queries) | |||
Excel 2003 - change columns to rows and rows to columns | Excel Discussion (Misc queries) | |||
matching on columns | Excel Discussion (Misc queries) | |||
deduplicate data in excel | Excel Discussion (Misc queries) | |||
Using EXACT to Deduplicate | Excel Worksheet Functions |