I want to list every possible combination from of a selection of numbers or letters. Can I do this on excel?

Question

I want to list/generate every combination from of a selection of numbers or letters.

for example, 6 days of the week out of a possible 7:

T, W, Th, F, Sa, Su

M, W, Th, F, Sa, Su

M, T, W, F, Sa, Su

M, T, W, Th, Sa, Su

M, T, W, Th, F, Su

and so on...

Is there a way of doing this on excel? Or any other tool I can use?

Thank you

Answer 1

The web page at at URL

http://en.allexperts.com/q/Excel-1059/Ex...

has complete code that will do what you want with only slight modification.

Use the link above to get to the web site.

The URL is broken up below so you can see all of it

http://en.allexperts.com

/q/Excel-1059/Excel-VBA

-list-combinations.htm