|Ref How To Find Duplicate Records|
Many thanks for your reply; my problem is there are over 20.000 records I have at this stage come up with a solution
I Added the number and three names together using =C4&D4&E4&F4
I then get 14556JamesJohnMcCabe
I then used the formula =IF(COUNTIF($H$4:H4,H4)>1,"Duplicate Name",0)
If I populate this formula down I can find the duplicates.
If I Data sort Col C I then get all the duplicates with the same ID number grouped together, so it’s easier to remove what are 100% duplicates.
The problem yet to overcome is what constitutes a duplicate for example if the middle name is missing in another record, it will not return a duplicate, although it’s more than likely is.