• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Finding Duplicates in Excel

R

ridgleye

New Member
I have have ~1500 rows of data. In two columns (in this instance it is "C" & "D") you find the last name and first name, respectively.


I know there are individuals that have multiple entries and would like to delete them out. I don't want to create a conditional format to highlight a single name, i.e. "Young, James", and do that for the entire database.


If possible I'd like to run once to find any/all names that match then delete the entire row(s), leaving just one entry for an individual. Perusing through this I see that some have up to 8 entries.


Thank you in advance for your assistance. The group of individuals on this site are absolutely invaluable. THANK YOU!
 
Fred - When you have ~1350 unique names it isn't that simple. Especially with common last names (i.e. "Smith"). Also, this still raises the issue of going through every one individually which I don't have time for and don't want to repeat each time this spreadsheet needs to be distributed.
 
eh - nevermind. I just used an IF/AND function to capture the data - creating a "1" for matching results, filtered that down and deleted. Still too many steps for my liking but it works.
 
1. column E: column C & column D

2. column F: countif($e$1:e1,e1) copy down. just filter out "1". delete the rest.
 
You must log in or register to reply here.
Back
Top