I am having a problem setting up a function in Excel (not sure of the
appropriate function to use). The fundtion I use can be used for numbers or
text (no combinations of numbers and text)

I have 6 groups of numbers with each group labeled.

GRP A GRP B

G1 1 2
G2 3 4
G3 5 6
G4 7 8
G5 9 10
G6 11 12

I am trying to pull one number from each of the 6 groups to produce a number
combination of 6. The combinations must stay in number order in the lowest
to the highest. I quess to make it plain I have 12 numbers and i want to
create a combination of 6 numbers making sure I only use one number from each
group. See example below.


COMBN1 COMBN2 COMBN3
G1 1 2 1
G2 3 3 4
G3 5 5 5
G4 7 7 7
G5 9 9 9
G6 11 11 11

i hope what I have displayed is what I am trying to relate in my message and
things are to confusing.

The Deacon