May 4

The Excel Lab: Soundex Search

0  comments

The Excel Lab: Soundex Search

Every once in a while, I have a spreadsheet that sits in my ‘lab’ for way too long. At a certain point, I have to admit that I’m never going to finish it completely or do a full blog post on it. I’ve decided just to release one such spreadsheet as is. Perhaps you will be the one to carry it forward? (or, write to tell me I’ve wasted my time?)

Soundex Search

I while ago, I read about a phonetic algorithm called Soundex. Soundex is useful (well, there’s some argument about that) for searching through a list of surnames while compensating for common misspellings in those names. Using a dummy dataset and UDF developed by Richard Yanco, I created the following:

Soundex

As the animation demonstrates, you can type in your search term into the ActiveX textbox and both the listbox and graph will automatically update to show you relevant search results and corresponding values. I’ve added some additional search functionality beyond Soundex as well. For each name in the dataset, I’ve assigned a random value to plot.

I’m rather unconvinced of the usefulness of this. I’ll put it you to see if you have any luck with it. For what it’s worth, the mechanism is formula driven. I didn’t use VBA except to set the original Soundex values for each surname (which, you could also probably do without VBA if you were so inclined.)

Download the source file:

soundex.xlsm

Loved this? Spread the word


About the Author

Jordan Goldmeier

Related posts

Microsoft Excel Visio Data Visualizer Add In for Excel: A Quick Guide

Read More

Highlighted Timeline Chart in Excel Without VBA: Raw and Uncut

Read More

Make Your Excel Spreadsheet into a Bitmap Image With This Excel Magic Trick

Read More

Excel Data Visualization: Presidential Approval Ratings with Slicers & Power Query – Chart Tricks

Read More
{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

Subscribe to our newsletter now!

>