Hello,
I have data from "A" to "AD" which I sometimes have to sort. Is it possible to sort these 30 letter sequences in both blocks of 3, 4 and 5 rows high so that I get every combination possible in either columns of 3, 4 or 5 rows high depending on what I need.. For example, blocks of 3 rows high would give abc, abd, abe...all the way to aad then bcd, bce, bcf
...all the way to bad. The amount of lines would be astronomical I guess that's why I thought I would ask first.
I have attached a file with a small example.
Thank you,
Blueyes727
SORT.xlsx
I'm not sure I totally understand exactly what you want but I can tell you this much.
For a combination of 3 characters with each character having 30 possible values (from A - AD) you would have 27,000 possible combinations (30^3). For 4 characters you have 810,000 possible combinations (30^4) and for 5 characters you have 24,300,000 possible combinations (30^5).
So, you are correct, the number of possible combinations gets to be "astronomical".
Kyle