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