Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range Search
I have some data in the following format:
D E F G H I J K L .... more 9 a b f f f c c d f I had some code that would search through the range and write the first occurrence of the data into a new cell and then increment a cell to the right. This all worked fine until I got a new set of data in which I had an 'a' in cell L9. So my output showed both a's. I really wanted only one output of 'a' no matter how many times it showed up in any order. How would you code a search routine for my new case? Merry Christmas. Thanks in advance for your help! Ray |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range Search
Ray,
You don't say what type of code you're using for your search, but the Find method in vb has an option to match the case or not. Alternatively, you could assign a variable to the LCase value of the cells contents before checking it. Or, convert the entire range to lower case before searching. HTH, Shockley "Ray Batig" wrote in message link.net... I have some data in the following format: D E F G H I J K L .... more 9 a b f f f c c d f I had some code that would search through the range and write the first occurrence of the data into a new cell and then increment a cell to the right. This all worked fine until I got a new set of data in which I had an 'a' in cell L9. So my output showed both a's. I really wanted only one output of 'a' no matter how many times it showed up in any order. How would you code a search routine for my new case? Merry Christmas. Thanks in advance for your help! Ray |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search range | Excel Worksheet Functions | |||
Search for value in a range | Excel Worksheet Functions | |||
search within a range of cells? | Excel Discussion (Misc queries) | |||
Search range for text not in another range | Excel Discussion (Misc queries) | |||
Search for value in a range | Excel Programming |