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
3
Medium Priority
?
182 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 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

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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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…

704 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