Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
Solved

# Sorting group of numbers into smaller groups of three

Posted on 2013-02-03
Medium Priority
182 Views
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
0
Question by:Europa MacDonald
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• 2

LVL 20

Accepted Solution

n2fc earned 2000 total points
ID: 38849574
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

Author Comment

ID: 38850904
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

Author Comment

ID: 38885729
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

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
###### Suggested Courses
Course of the Month6 days, 22 hours left to enroll