Sorting group of numbers into smaller groups of three

I have a set of six numbers, each in their own individual cell

I have to select all possible combinations of three numbers from this original set of six as shown in the file I have attached.

In worksheet, I have used a simple method of selecting.

Can someone show me how to do this same procedure with a macro ?

(I have millions of sets to work through)

thankyou very much
3group.xls
Europa MacDonaldChief slayer of dragonsAsked:
Who is Participating?
 
n2fcConnect With a Mentor Commented:
1st off you duplicated "cde" twice, resulting in 21 groups instead of 20...

6C3 is 6x5x4/(6) = 20

At this point there is no need for a macro!
All you need do is fill in values in a new row for a-f and then copy the "formulas" in the remainder of the row down!
0
 
Europa MacDonaldChief slayer of dragonsAuthor Commented:
Well I fell the need for a macro, I have millions of sets to work through, but thanks for the advice, I would really prefer help.
0
 
Europa MacDonaldChief slayer of dragonsAuthor Commented:
I've requested that this question be closed as follows:

Accepted answer: 0 points for MichaelGlancy's comment #a38850904

for the following reason:

great
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.