Forum Discussion
Solved
Editing database of 25000 Names and Addresses
Good morning, I am wondering if anyone could point me in the direction of where to start in removing (nearly) duplicate rows from a names and addresses database? Customers have registered wit...
Yes it can be done. In the attached file you can see the steps i've applied from sheet1 to sheet8.
=COUNTIFS($A$2:$A$19,A2,$B$2:$B$19,B2,$C$2:$C$19,C2)You can try this formula for the attached example. If the result is greater than 1 the dataset for first name, last name and postal code appears more than once. You can adapt the ranges of the formula according to your requirement.
Hi,
Thank you for taking the time to reply.
That would work to identify the duplicates - thank you - but then I will need to delete the duplicates/triplicates etc. Do you think this is possible?
Thank you for taking the time to reply.
That would work to identify the duplicates - thank you - but then I will need to delete the duplicates/triplicates etc. Do you think this is possible?
Yes it can be done. In the attached file you can see the steps i've applied from sheet1 to sheet8.
- Hi,
Thank you so much for your help and I am so sorry to trouble you again but I am stuck at the FILTER FOR GREATER THAN 1 stage and can't get that to work. Are you able to point me in the right direction, please?
Thank you 😃- I have fixed it and removed all my duplicates!
Thank you soooo much for all your help. I thought it was an impossible task but it is now done. 😃