Recommend a Fuzzy Duplicate Finder for Excel

Digger

Hi

Please can you help me.

I think I am right in saying I need a Fuzzy Duplicate Finder for Excel but please correct me if I'm wrong. I need something to find duplicate entries on a spreadsheet, including those where some entries may have been mistyped. And be able to delete/correct them.

Preferably a free download as not sure how much I will use it after I have done this task.

I did google it (that's where I found out what it's called) but I worry about picking a free download at random and messing up my computer.

Thanks for reading and hope someone can help a non-techie.

More4me

Why not use some Excel's functionality to trace duplicate values.
construct a pivot table for the column of values and and choose "count of" in the data section, the pivot table will give you number of occurance for each value, for all items greater than one amend/delete from the list.
another option is to use conditional formating, say your data are in A2;A15, highlight the range A2:A15, click Format then Conditional Formating in the popup window select Formula is then enter formula =COUNTIF($A$2:$A$15,A2)>1 and click format/pattern and choose the colour of your choice, OK, OK. this will highlight all the duplicate values.
As long as you have the right to amend the spreadsheet you can make all the changes you like.
Hope this helps

Digger

Wow - Thanks More4me, sounds like both of those will do the job of finding duplicates, that's excellent. I saw the pivot table function when I was looking around on Excel - never come across it before so will be interesting to see how I get on. I'll have a go on Monday and let you know. Thanks for taking the time to reply, it's much appreciated. With regard to finding the 'fuzzy' ones, where I have mistyped one letter, I guess I'd better start brushing up my typing skills so it doesn't happen in the first place!!

More4me

I am glad that you think it will work for you. as for the typos it is difficult to suggest the solution without seeing the values, however, if it is relating to upper/lowercase than use one of the text function to convert the values.