Combination formula

Hi there,

I hope you clever Excel guys can help me.

I need to find a way to contain all possible combination/ permutation of 11 items, hopefully by using some sort of formula.

So, in more detail, I have a list of 11 items that I currently have in a drop down list, using a data validation list. But that only covers one item in one instance. I need to be able to potentially select all 11, or just 3 of them or a different set of 3 of them etc etc.

The only thing that i have been able to do so far, is to add the extraneous items onto separate rows, but that throws out my reporting.

If anyone has any idea on how to tackle it, i would be most grateful, as I am tearing my hair out with this!!

Cheers
Angela

Hi ChemistB

I actually need excel to return every single permutation of all 11 in the set. Sorry, I am terrible at explaining this type of thing :s

Any info will be really gratefully received.

I realised that I was over complicating things, and have opted for a different way of solving this. Thanks anyway.