Solved

Sorting group of numbers into smaller groups of three

Posted on 2013-02-03
3
164 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:MichaelGlancy
  • 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:MichaelGlancy
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:MichaelGlancy
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

839 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