Every Possible Combination Of A Group Of Numbers

The numbers are file attributes, as you know these are

Normal = 0
Read Only = 1
Hidden = 2
System = 4
Volume = 8
Directory = 16
Archive = 32

These numbers are cumulative, so if a file has an attribute of 5 it is Read Only and System (1 + 4), it can't be anything else. Or if it has an attribute of 6 it can only be Hidden and System (2 + 4).

What I need is a spreadsheet that calculates every possible combination of these numbers, so I can check my Select Case statement has covered all possible combinations.

If it was just a one off project I could just work it out "by hand", but I have realised that there are several other projects I have that this would be useful in.

e.g. I am doing a skills matrix at work. If I give each skill a number, then give each employee a cumulative total number then I can have a spreadsheet that shows their skills. For each employee number there will only be one possible combination of skill that add up to that number.

My employer often adds new skills, so each time this happens I will have to check every combination is covered.

So I really need a spreadsheet solution, something I can input a group of numbers and it will show me a list of every possible combination of those numbers. The number of numbers in the group will vary, so a solution that only works for a group of (say) 6 numbers won't work. It has to work on a variable group of numbers.