All Possible Combination From List 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.

[Cutter]

Duplicate thread: http://www.excelforum.com/excel-prog...-of-items.html