View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
WRC WRC is offline
external usenet poster
 
Posts: 15
Default search for records

I need to find a way to search for records, in the list fo 3,000 item numbers
in one column:

1. Have only one character different from a given search string.
2. The different character can be at any position on the string of the
records found.
3. If none of the records have one character different from the given
string, search for records have two characters different from the search
string.
4. If none of the records have two characters different from the given
string, search for records have three characters different from the search
string.
5. If none of the records have three characters different from the given
string, search for records have four characters different from the search
string.
6. If none of the records have four characters different from the given
string, search for records have five characters different from the search
string.
7. If none of the records have five characters different from the given
string, search for records have six characters different from the search
string.
8. If none of the records have six characters different from the given
string, search for records have seven characters different from the search
string.
9. If none of the records have seven characters different from the given
string, search for records have eight characters different from the search
string.



Thanks