• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 185
  • Last Modified:

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
Europa MacDonald
Europa MacDonald
  • 2
1 Solution
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!
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.
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:

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.

Join & Write a Comment

Featured Post

Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now