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