Jack-P-Winner
Member
I have another challenge for the gurus. I want to be able to find all the U's and D's that will follow a group of U's and D's in up to 6 columns and approximately 2500 rows. There will be times I will want to search for say 4 letters, 5 letters and then 6 letters. For example 4 letters will be UDDU, 5 letters DDUUD and 6 letters DDUUDD What I am wanting is to be able to place say a 5 letter DDUUD in a box, hit a search button and it find all the next letters which will be either a U or D in the next row up so it will look like this: Columns A through AK is how the spreadsheet actually is. How can I do this?
DDUUD
and it find for example
DUUUD
DDUUD
DDUUD
and it find for example
DUUUD
DDUUD