View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
G[_2_] G[_2_] is offline
external usenet poster
 
Posts: 4
Default 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