Performing a "fuzzy" look-up by row

Jon_London

New Member
Joined
Jan 24, 2019
Messages
6
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
 

Some videos you may like

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
L

Legacy 436357

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

Yongle

Well-known Member
Joined
Mar 11, 2015
Messages
6,746
Office Version
  1. 365
Platform
  1. Windows
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

New Member
Joined
Jan 24, 2019
Messages
6
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
 

Watch MrExcel Video

Forum statistics

Threads
1,109,001
Messages
5,526,203
Members
409,686
Latest member
Tori83

This Week's Hot Topics

Top