0

I've looked around various forums for comparing two strings and looking for similarity and it appears the best option is to use "Levenshtein Distance" - I've seen other peoples vba code etc but how to I set this up to compare my data in EXCEL?

seen an example here > Levenshtein Distance in VBA

but how do I set up or even begin to use this to compare my data below? the actual data has a lot more detail and some strings up to 100 characters long.

enter image description here

any help would be much appreciated, I believe this is a function in VBA rather than a sub, so don't even know where to start or if levenshtein distance is the answer.

thanks

T_M_
  • 21
  • 6
  • Assuming you have copied the linked code into a module of your workbook, you simply put a formula like `=Levenshtein(A2, B2)` to cell C2 and copy it down. – FunThomas Feb 09 '21 at 11:10
  • @FunThomas thank you Sir, didn't realise it was that simple. Much appreciated! – T_M_ Feb 10 '21 at 09:10

1 Answers1

0

input formula '=Levenshtein(A2, B2)' A2 & B2 being the cells to check

T_M_
  • 21
  • 6