theta
04-30-2013, 06:17 AM
Hi all,
I have a column of values and I would like to find repeated patterns using VBA or a formula (preferable for quick tweaking). I am going to group items using the [+] and [-] collapsing frames. I could do this using an exhaustive IF formula going to about 5 levels checking (row1 vs row2), (row1 & row2 vs row3 & row4), (row1 & row2 & row3 vs row4 & row5 & row6) but this is a horrible methods.
Any help appreciated, sample data below :
Hello (recursive 2 levels)
Goodbye (recursive 2 levels)
Hello
Goobye
Hello
Goodbye
Red (recursive 3 levels)
Blue (recursive 3 levels)
Green (recursive 3 levels)
Red
Blue
Green
Apple (recursive 4 levels)
Orange (recursive 4 levels)
Pear (recursive 4 levels)
Banana (recursive 4 levels)
Apple
Orange
Pear
Banana
I have a column of values and I would like to find repeated patterns using VBA or a formula (preferable for quick tweaking). I am going to group items using the [+] and [-] collapsing frames. I could do this using an exhaustive IF formula going to about 5 levels checking (row1 vs row2), (row1 & row2 vs row3 & row4), (row1 & row2 & row3 vs row4 & row5 & row6) but this is a horrible methods.
Any help appreciated, sample data below :
Hello (recursive 2 levels)
Goodbye (recursive 2 levels)
Hello
Goobye
Hello
Goodbye
Red (recursive 3 levels)
Blue (recursive 3 levels)
Green (recursive 3 levels)
Red
Blue
Green
Apple (recursive 4 levels)
Orange (recursive 4 levels)
Pear (recursive 4 levels)
Banana (recursive 4 levels)
Apple
Orange
Pear
Banana