Performing a "fuzzy" look-up by row

[Jon_London]

Hi everyone

I have a long spreadsheet with just 1 column (and around 8,000 rows) which has the names of Educational institutions in it. I would like to perform a fuzzy-type lookup on the data to see if there are any similarities.

An example would be where I have one row saying University of London and another saying University of Lodnon.

I've tried to use the Fuzzy Lookup extension, but this only seems to work where there's more than 1 column.

Could anyone please suggest any methods of doing this?

Many thanks
Jon

 

[Legacy 436357]

Maybe sort the data and then do a spell checker to organize?

 

[Yongle]

I have not used Fuzzy Lookup Extension but if it needs 2 columns ...
- copy column A to column B
- now you have 2 columns

Perhaps that will work

 

[Jon_London]

Hi both

Thanks for your answers, but unfortunately neither options work.

Unfortunately Fuzzy Lookup simply looks at two datasets and compares them, so in this case there is ALWAYS a match. I need something that fuzzy matches on rows, but that doesn't seem to exist.

Ho hum.... thank you again.

Jon