Thanks Pete I should be more specific. I have 2 names of bike frames in
Column A. In Column B I have 5 names of Kits that can be put on to each of
those frames. In Column C there are 4 shocks that could go on each frame and
each kit. In Column D I have 10 forks that could go with each frame, each
kit, and each shock. So I need every combination that expands outward from
Column A.
--
Nate


"Pete_UK" wrote:

When you say "data field" do you mean your table of data, i.e. 40
cells? Or do you mean combinations of your 4 cells for each row?

If the latter, then consider your cells containing A, B, C and D - the
combinations would be:

AB
AC
AD
BC
BD
CD
ABC
ABD
ACD
BCD
ABCD

and even more if the order is important, i.e. if BA is different than
AB.

Do you realise how many combinations from 40 cells there would be?

Pete

On Jan 30, 12:27 am, Nate wrote:
Sorry but I'm relatively inexperienced with excel. I have 4 columns with a
word in each cell for about 5 to 10 rows. I need a formula that will give me
every combination of every cell in my data field can anyone help me?
--
Nate