Possible Combinations of Items

[shiqs28]

Hi,

I have a list of Items e.g,

FISH
CHICKEN
MEAT
CAPSICUM
TOMATO

I'm trying to get all possible combination of these items and also at the same time place them in the next column to each other.
I understand that if I have 5 items, I should be getting 5! = 120 combinations.

I badly need help on this as I'm working on my Final Year Project which due in 3 more weeks.
I have tried online tutorial but still can;t seem to figure out the correct formula.

VBA code or Excel Functions ideas are both appreciated.
Im using Excel 2007.

Hopefully I get an answer by tonight.
Advance Thank You.

[oeldere]

You get better help if you post an Excel-example of your workbook, without confidential information.

[jason.b75]

It's amazing what you can find on google in less time that it would take to post a question

See here.

[shiqs28]

wow... thank u jason.b75 !

That was exactly what i wanted to do..
Gazillion thanks!
God Bless.