LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services, SEO Consulting Se0 Guy Excel Worksheet Functions 0 March 8th 07 04:08 AM
Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services, SEO Consulting Se0 Guy Setting up and Configuration of Excel 0 March 8th 07 04:08 AM
search for a name from list and then go to relevant records sudip Excel Discussion (Misc queries) 2 December 30th 06 08:51 AM
search and export multiple records Richard R Excel Worksheet Functions 3 January 17th 06 09:48 PM
How do I search excel spreadsheets using multiple search criteria. Kasper Excel Worksheet Functions 4 December 15th 05 12:26 AM


All times are GMT +1. The time now is 04:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"