View Single Post
  #1   Report Post  
shawneyv
 
Posts: n/a
Default find duplicate cells in Excel

I need to eliminate duplicate addresses in a mailing list. I only want to
send to one letter to "family" at each address. I have assigned the last
name column to a range called "Lname" and the full address including
city/st/zip to a range called "Addr". What would be the best formula to
review 60000+ records for duplicate last names at the same address?