fuzzy search

I have a list of alpha/text strings in a column (5000 to 30,000 long)

I want to show a list of all remaining possible matches as I type in a search string, so I can just select one if its what I wanted.

example

input ABC
table
abc123 (shows)
1abc23 (shows)
123abc (shows)
1234bc (doesn't show)

Ideas?

Here's an example of how to show the data you want, without knowing what you want to do with it.

Please Login or Register  to view this content.

It's always good to clarify your thread title as well as including a workbook example of how you want it to look both before and after.