Help - Names, Names, Names "Spell Checker" ?

P

petewelch

Hi. I receive competition results which contain individuals' names, clu
names, rank, scores and want to publish them using the "correct
individuals' name, i.e. their "registered" name.

Results are submitted by coaches / volunteers who may know and recor
the individual using their "friendly" name.

For example, a name like Rebecca can be a nightmare if you consider th
variants: Rebekah, Becky, Beccy, Becci, Beccie, Becca, Beka etc. not t
mention genuine spelling mistakes.

So the task is to get the names into a standard form and then forma
the data associated with that name into columns.

I've been playing with VLOOKUP, but don't know how to use it to chec
these alternative spellings / forms.

Any ideas ?

Pet
 
A

Alex Delamain

You're going to need to build a table of all the possible variations
ie:

Becca Rebecca
Becci Rebecca
Beccie Rebecca
Beccy Rebecca
Becky Rebecca
Rebecca Rebecca
Rebekah Rebecca

then =vlookup(-name-,a1:a7,2,false)

If it returns #N/A then you know that the name typed is not in the lis
and will need to be adde
 
Top