| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
exact match in a string
i1 = " week1, week2, week5, week16, week18, week24 "
i2 = " week16 " If InStr( i1, i2 ) 0 Then When I put above code in a loop to check all rows in my sheet not only " week16 " responds but also " week1 " comes in. How can I avoid "week1" ? Or " week2 " while looping for " week24" ? Any idea ? Thank you very much. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find an exact match and go to that match | Excel Discussion (Misc queries) | |||
| Find Exact Match using INDEX, MATCH | Excel Worksheet Functions | |||
| vlookup and finding text string that's not an exact match | Excel Discussion (Misc queries) | |||
| Getting an exact match | Excel Worksheet Functions | |||
| Test for exact match in string | Excel Programming | |||
![rumkus@hotmail.com[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
