Different Combinations of text

Hi,

I have a list of 5 words and I want to know the different combinations of these words.

The List is:
Stp (Yes/No)
Shp (Yes/No)
Ld (Yes/No)
Geo (Yes/No)
Gas (Yes/No)


e.g. for Stp
Stp Shp Ld Geo Gas
Yes No No No No
Yes Yes No No No
Yes No Yes No No
Yes No No Yes No
Yes No No No Yes
Yes Yes Yes No No
Yes Yes No Yes No
Yes Yes No No Yes

And so on......

I have found the attached spreadsheet that may do it but despite trying I couldnt get it to list all combinations.

Can anyone get the attached to help solve my problem or point me in the direction of a simlar model? (Original post: http://www.excelforum.com/excel-misc...ent-words.html)

Paul