# Every Possible Combination Of A Group Of Numbers

Apr 26, 2009
The numbers are file attributes, as you know these are

Normal = 0

Read Only = 1

Hidden = 2

System = 4

Volume = 8

Directory = 16

Archive = 32

These numbers are cumulative, so if a file has an attribute of 5 it is Read Only and System (1 + 4), it can't be anything else. Or if it has an attribute of 6 it can only be Hidden and System (2 + 4).

What I need is a spreadsheet that calculates every possible combination of these numbers, so I can check my Select Case statement has covered all possible combinations.

If it was just a one off project I could just work it out "by hand", but I have realised that there are several other projects I have that this would be useful in.

e.g. I am doing a skills matrix at work. If I give each skill a number, then give each employee a cumulative total number then I can have a spreadsheet that shows their skills. For each employee number there will only be one possible combination of skill that add up to that number.

My employer often adds new skills, so each time this happens I will have to check every combination is covered.

So I really need a spreadsheet solution, something I can input a group of numbers and it will show me a list of every possible combination of those numbers. The number of numbers in the group will vary, so a solution that only works for a group of (say) 6 numbers won't work. It has to work on a variable group of numbers.

View 9 Replies
ADVERTISEMENT
Oct 28, 2011

I'm looking for another excel game changer (for the work I do anyway).

I have a dollar amount, and I want to know if any combination of dollar amounts in a particular range of cells will equal that dollar amount. Is this possible in Excel?

Example: I have 20 different dollar amounts in a column. I want to know what combination of those 20 different dollar amounts, if any, will equal $257.97. The dollar amount I'm looking for and the numbers in the range will change with each use. I'm hoping for a formula, but VBA will work too as I could just make a template and copy / paste the numbers in.

View 6 Replies
View Related
Aug 9, 2006

My store uses a retail price "code" wherein a price like 99 in expressed as a

code like "PP"--exchanging the number digits 1-0 as letters.

Is there a function to do this automatically?

View 9 Replies
View Related
Jun 22, 2007

I have a list of numbers from 1-7 would look like this each number in a seperate cell.

3 5

1 2 3 5 6 7

2 4 5 6 7

6 7

4 6

6

I want to use one number from each row (which there is only 6 rows) and then find every number from 1-7 that will complete the sequence 1-7. So with the numbers above (using one number from each row) the only other numbers that could be used would be 3 or 5.

The combos that would work:

row 1 use 3 ----------- row 1 use 5

row 2 use 1 ----------- row 2 use 1

row 3 use 2 ----------- row 3 use 2

row 4 use 7 ----------- row 4 use 7

row 5 use 4 ----------- row 5 use 4

row 6 use 6 ---------- row 6 use 6

5 would complete ---------- 3 would complete

Remember the numbers and how many numbers in each row can change but will always be 1-7 and I always need to find every number that can complete the sequence 1-7 by using one number from each row.

View 9 Replies
View Related
Feb 10, 2006

I am trying to show the all possible combinations of a set of numbers in Excel, in my case I think permutations are more appropriate to use. For example: there are three numbers 1, 2, 3 I want to show results like:

1, 2, 3

1, 3, 2

2, 1, 3

2, 3, 1

3, 2, 1

3, 1, 2

The functions in Excel available only give the total number, but I want to see these combinations!

View 6 Replies
View Related
Dec 18, 2007

If I have A1 = 1, A2 = 3, A3 = 5, A4 = 7, and A5 = 9 in column A, Would someone know how to get the combination of numbers in column A that equal 13, or 24 for example?

View 9 Replies
View Related
Jan 30, 2009

Is there anyway to use Excel to determine which of a set of numbers equals a total? I encounter this issue when dealing with accounts receivable. We receive payments with no details on what is being paid. I have a list of open items and a total being paid. I would like to have Excel determine which combination of invoices can be added together to match the payment.

View 4 Replies
View Related
Jan 13, 2008

I have provided an attachment. what I am trying to accomplish. I am trying to have a worksheet that if I input multiple 3 number combinations into the input cell range, after pressing the sort button, it would then sort, rank and count each 3 number combination for me. So as my attached file illustrates, the input cells would be A9:D14. In this sample the ranking consists of cells A19 - A31 as the ranking columns. Cells F19 - F31 show the counted and sorted results and are ranked accordingly. I need a sort button as illustrated in cell F10 to make the worksheet function after the 3number combinations are inputted in cells A9:D14. How do I get started to make this work? I do not know VBA codes or macros so I will need guidance along the way if this is what is needed. I do have some working knowledge of formulas (e.g. countif, rank, etc.)

View 8 Replies
View Related
Aug 25, 2007

I have a list of 10 of my favorite/lucky numbers that I want to play in the lottery. The lottery picks 5 numbers total. I need a way to show me all the possible combinations of my 10 numbers picked in a 5 number draw (hope that makes sense). There are no repeat combinations- for example- I DO NOT WANT 1-2-3-4-5 and 5-4-3-2-1 to come up as separate combinations- so each of my favorite #s needs to be used only once in each combination, and each set used once.

I have searched this board for 2 hours now- read tons of other posts, but not finding a real solution. The output will be a list of all the possible combinations (no repeats, and no permutations) using my 10 favorite numbers. Another example-

1-2-3-4-5

1-2-3-4-6

1-2-3-4-7

1-2-3-4-8

1-2-3-4-9

1-2-3-5-6

1-2-3-5-7

and so on.

How do I create this? I realize the resulting table will be quite a large number of combinations- but we're going to have fun with it and pick a few at random.

View 9 Replies
View Related
May 16, 2007

I have 4sets of 5 numbers. In each set if 3 numbers make 10 or 20 then i'd like to rearrange these to upper row. But results are not like desired.

View 4 Replies
View Related
Jan 29, 2014

I'm trying to find a way to sort or use a formula to group same numbers that are positive and negative together for reconciliation purposes. What part of my spreadsheet looks like is this:

TypeAmount

SA-10000

SA-500

DM10000

SA-20000

DM500

DM20000

What I am trying to make it look like is this: (each SA has a corresponding DM entry)

TypeAmount

SA-10000

DM10000

SA-500

DM500

SA-20000

DM20000

I know there is a VBA method but i'm not very familiar with VBA so am trying to find a formula if there is one.

View 4 Replies
View Related
Feb 27, 2012

i have a range of numbers, 800 000 from 2 600 000 but i need to get them into numerical order packs, so i might end up with 100's of packs due to the ranges of numbers.

View 4 Replies
View Related
Aug 1, 2013

I have numbers in 7 groups in cell B2:H8 and winning numbers in cells B11:H27 The function below works fine with: For example if I select cell A2 (G1) numbers are in this row in the cells B2:H2 highlight perfect in the winning numbers in cells B11:H27 As shown in the picture below

A

B

C

D

[Code]....

View 6 Replies
View Related
Nov 29, 2011

I have a list of 400 numbers. I wish to filter down the list to those 500 and then of that list get the 95 percentile.

I have tried

=IF('GRML ECP 01'!O$2:O$584 500 I get a blank. When I run the function manually on the numbers > 500 I get 1800.

View 3 Replies
View Related
Jan 27, 2007

I have groups of data in a spreadsheet, I need to assign a value in column f for each piece of data in column e. The value needs to be a relative value for the rest of the group. For example if one group of data has 10 rows I need values 1 - 10 in column F, 10 being for the largest value in the respective row in column E and 1 being for the smallest value.

Each group does not have the same number of rows.

If need be I can add blank rows so the space between each group is equal, (if you can tell me an easy way to do this I would appreciate it as theres quite alot of data).

View 9 Replies
View Related
Feb 9, 2008

I have 7 cells containing strings but not numbers on a row.

Now I want to list out all the combinations of drawing out 3 cells out of these 7 cells while the remaining cells that haven't been drawn out could also be listed out one column next to the drawn cells.

For example, I got 7 cells like this.

A B C D E F G (each letter in ONE cell)

And I want to list out all the combinations like this:

ABC DEFG

ABD CEFG

ABE CDFG

ABF CDEG

etc.

For more details, please refer to the attached sample (an .xls file being zipped).

View 14 Replies
View Related
Mar 25, 2013

How do I do "conditional formatting" to high light the numbers which bigger than average + 2 * stdev in a data group?

View 4 Replies
View Related
Jun 28, 2013

I am looking to count group numbers that are bound to a nomenclature number. So I have made an example below. The nomenclature number is bound to 1. So I want to count all the 1's that are bound to 0912, which would be 5. and the same goes for 1234. the 2 is bound to the nomenclature 1234, so i want to count all the 2's that are bound to 1234. Which would be 3.

Group

nome

1

0912

1

1

2

2

2

1234

1

1

View 3 Replies
View Related
Dec 18, 2008

i have a spreadsheet with 21,000 part numbers. I am trying to group the like part numbers, then leave a space between the unlike part numbers. right now my spreadsheet has a space between each part number and i want to eliminate that. but also keeping the part's qty, date, etc. with it.

View 14 Replies
View Related
Jan 29, 2013

So we had a month long, company paid (woohoo!) "weight watchers" challenge. On 1 worksheet ("Stats"), I have the Name of every Employee (A Column), then their Start Weight (B Column), End Weight (C Column), Department (D Column) and finally Location (E Column).

I know how sensative some people can be about their weight, so I locked the page and created another worksheet named "UI", which will display the "Average End Weight" for each department. So Human Resources would be the department in cell A2 on the UI sheet, with City 1 being the Column Header in cell B1. There are 8 cities (offices) and 23 departments.

So, for cell B2, I want to scan through the "Stats" worksheet and locate all of the cells in the department and location columns that read "Human Resources" and "City 1" respectively. Then grab the "End Weight" for every row that meets these 2 criteria, add them up, and divide by the number of "End Weights" that were grabbed.

My solution would be to make a separate column for each department (and then each city, so essentially 8 columns to represent all the cities for each department), use a nested (maybe 4) IF statements to then list only the end weight if that particular row meets the criteria, then at the bottom of each separate column, add all the shown numbers up and divide, then draw the information from THAT number into the "Average" cell on the UI worksheet. But it isn't very dynamic and if i want to use this sheet next year, there will be more employee info to be added and it would be a mess..further more, it would be...what...23 Departments x 8 Cities x 155 employees = ~28,500 added cells.

View 7 Replies
View Related
Apr 28, 2014

Cells in row C have numbers (number of days between date a and date b)

I want to group the days so I can run a usable pivot table as follows:

Up to 7 days between update date and today (ie 1 week) 8-14 days between update date and today (ie 2 weeks) 15-21 days (ie 3 weeks) 4 weeks +

My attempt is as follows but only give two results and not 4?

=IF(OR(C2<=7),"1-7days",IF(OR(C2>=8,C2<=14),"8-14days",IF(OR(C2<=21,C2>=15),"15-21days","Over4weeks")))

View 3 Replies
View Related
Jul 31, 2012

I am currently using Excel 2010. How to Count Singles, Doubles, Triples and Quadruples in a group of number.

Frankie

0

1

2

9

Count how many single numbers (numbers all different). Example: 0129

7

8

8

8

4

8

3

6

[Code] .......

Count how many double numbers (two numbers the same in a draw). Example: 8830

9

2

6

2

8

3

5

4

[Code] ......

Count how many triple numbers (three numbers the same in a draw). Example: 7888

8

6

1

2

9

5

9

6

[Code] ......

Count how many quadruple numbers (all numbers the same in a draw). Example: 2222

6

4

5

1

5

1

0

2

[Code] .........

View 9 Replies
View Related
Feb 9, 2014

How do I enter a formula in excel 2010 that will give the total amount of times each number is in this group. Example : how many times (total) the number 12 showed up , how many times the number 27 showed, and so on for each number that is in the entire group of numbers, from 1 to 80 .

Here is the page I will copy and paste into a workbook sheet from the internet that i want to evaluate the times each number was called.

Very new to all this , I am a bit aged and need not to learn excel A to Z, just need to know what correct statements /formulas have to be entered to do what i desire.

I am only interested in the total count of the small bold numbers 1 to 80, each single digit 1 to 9 and double digits 10 to 80 will be in their separate cells. The large bold three digit numbers and dates/times will have to be erased (manually) before the calculation takes place.

298

2/9/2014 12:28:02 PM

37

77

[Code]....

View 6 Replies
View Related
Jul 12, 2012

I have a formula that I can't get to paste successfully in the forum - it keeps getting cut off?!? ... but I think I can probably simplify my explanation to get the answer I want anyway.

I need to only show the value from AUS!$H$2:$H$17 if the C2 & D2 combination are the same as the AUS!$B$2:AUS!$B$17 & $AUS!$C$2:AUS!$C$17 combination.

View 9 Replies
View Related
Mar 17, 2014

I am trying to write VBA code that groups cells between blank rows and inserts a message if a string of text (a name) is missing from the entire group. I want the code to search cells in column A and group the cells between blank cells. Use the name I input in an input box as the search criteria and insert a message in the Column C next to the last blank cell in the group and then move on to the next group and highlight the cell in red with bold text. I am including a spreadsheet with an example of what the sheet should look like before and after the code is run.

View 11 Replies
View Related
Nov 12, 2009

I have date fields as column labels in a pivot table. When I try to group them I'm only given the option to group by integers and not by months, years etc.

I've had a look at the format settings of the column and they are formatted as date fields.

View 9 Replies
View Related
Feb 10, 2014

I have several groups of data in the same sheet. Each group has two blank rows above the first row of data. Each group has column "B" in common (e.g., "Phone" in the example attached). I'd like to add a title/label of "Phone" to the first column in the row immediately preceding the first row of data for that group.

View 1 Replies
View Related
Jan 17, 2013

how to use the group box to group a number of option buttons together.

Question is, lets say, i have a total of 4 group box. if i want it to work in such a way where by once 2 option buttons are being selected (1 option selected from each group box), the rest of the option buttons in the 4 group box will be greyed out. is that possible?

View 2 Replies
View Related
May 28, 2014

In Col X of the attachment, I have manually entered the count of the rows within each sub group, as determined by the counter in Col W. How can I do this automatically? I need this because when I filter the spread sheet by Rank, I need to know how many selections, of the filter Rank query, were in a sub group of ? number.

View 2 Replies
View Related
Apr 18, 2014

I have this massive spreadsheet, with the maximum rows excel will fit on one sheet. In the interest of simplicity, this is what the raw data looks like:

Last First Amount

Jones Jim $1000

Jung Joe $700

White Jon $100

Jones Jim $200

Jones Jan $300

Jung Joe $800

White Jon $200

What I want to do is automatically get excel to group all the same names together. Then I want it to sum all the values for each name, then order by largest total value for each person, then order that by name alphabetically. In other words, the above would look like this after the sort:

Last First Amount

Jung Joe $800

Jung Joe $700

Jones Jim $1000

Jones Jim $200

Jones Jan $300

White Jon $200

White Jon $100

Or, if necessary, there could be sum total rows under each name...although I don't have spare rows, so IDK. I could delete some rows if I had to, but would rather not.

View 1 Replies
View Related