Solved

Sorting group of numbers into smaller groups of three

Posted on 2013-02-03
3
176 Views
Last Modified: 2013-02-13
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
Comment
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
  • Learn & ask questions
  • 2
3 Comments
 
LVL 20

Accepted Solution

by:
n2fc earned 500 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

by:Europa MacDonald
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

by:Europa MacDonald
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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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…
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question