A way in Excel to select permutation data only allowing for certain type of sequence?

[cchelise]

I have created an excel doc with every known permutation of the randomly assigned characters S, F, O, P and S', F',O', P' but only wish to look at permutations that turned out looking like this: SS'FP'O wherein the letters with " ' " are separated from each other by regular letters. Can I make excel select for specific place orders and not specific data sets?

[pike]

Hi cchelise
Try this ....

Please Login or Register  to view this content.

[pike]

or this pattern

Please Login or Register  to view this content.