Combination- List Of 10 Of My Favorite/lucky Numbers That I Want To Play In The Lottery
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
ADVERTISEMENT
Jun 3, 2008
I have 49 lottery numbers split in 3 segment and 5 groups separated by coma
In cell Range from B2:F4,
I enter 5 numbers from draw result in to cells B9:F9
What I want to highlight the ticket numbers that have been drawn a in lottery, In this example the ticket numbers are in cells B2:F4, and the drawn numbers are entered in cells B9:F9
Example is below
A B C D E
G1G2G3G4G5Seg12, 5, 6, 8, 915, 1921, 25, 2637, 38, 4042, 45, 48Seg23, 4, 711, 13, 1827, 3047, 50Seg31, 1012, 14, 16, 17, 2022, 23, 24, 28, 2931, 32, 33, 34, 35, 36, 3941, 43, 44, 46, 49Lottery Result Below:57142049
View 9 Replies
View Related
Mar 1, 2007
Tracking winning lottery numbers using conditional formating on a worksheet.CF only allows 3 formats I need 10 is there a way around this.In cell B2 I choose Conditional Formatting from the Format menu.I select Formula is from the drop down menu,and enter the formula =COUNTIF($N$2:$S$2,B2)>0 Then I hit OK.I then click on the Painter button on the toolbar and apply this formatting to the rest of the lotto numbers.I can do this 2 other times but i need it to work 10 more times,if there is no way around this, is this formula possible in VBA and how do I enter it.
View 9 Replies
View Related
Oct 10, 2006
I am setting up a spreadsheet with two columns. The first column will contain a persons name the second column will contain four numbers.
Name Numbers
Joe 1,3,12,24
John 4,12,23,24
Jill 6,14,19,26
I need to be able to search to find the following: the correct sequence of numbers e.g. if 1,3,12,24 were pulled out then that search is easy. If I was looking for someone who had the numbers 1,12,24 then I have a problem. I was thinking about putting the four numbers in to four separate columns but my Excel knowledge is poor.
View 4 Replies
View Related
Sep 3, 2009
I need a vba that can generate all set of 6 number combinations with the total sum of 100.
For example: 3, 6, 4, 15, 35, 37 = 100.
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
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
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
Sep 20, 2012
I have the below code that i am using to generate a random number between a user defined lower limit and upper limit (these limits are set in cells "B3" and "B4" in worksheet "DRAW"), the random number that is generated displays in cell "B7" on worksheet "DRAW".
The code also allows for the draw result to be stored on a second sheet called "DRAW HISTORY", on this sheet the draw result, date and time are recorded (the date and time are stored on sheet "DRAW" in cells "C20" & "C21" and these values are pulled to the result sheet by the macro).
What i would like to happen though is instead of the random number displaying instantly i would like the numbers to cycle for 3 seconds before stopping and the result being recorded. A much better visual effect than an instant BANG here is the winner.
here is the code i am using to generate the random number and record the result:
Sub testRandom()
Dim aRow As Long
Sheets("DRAW").Range("B7") =
[Code]....
View 3 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
Apr 18, 2014
how can I retrieve a unique list coming from a combination of 2 columns. Using VBA would be much better.
e.g.
Col1Col2
RED 1
RED 2
BLUE 1
BLUE 1
RED 1
BLUE 3
BLUE 2
BLUE 1
RED 1
Result will be
RED 1
RED 2
BLUE 1
BLUE 3
BLUE 2
View 3 Replies
View Related
Oct 20, 2013
I have a list in excel with ten values, but I need to get all combinations possible, picking 4 of 10 each combination. This must be as a combination and no permutation or variations either, I mean, values can't be repeated in a single combination.
I'm struggling to do this in a Macro but I don't get it.
View 9 Replies
View Related
Nov 3, 2013
I want to create a spreadsheet for figuring the cost of some of my favorite recipes. Right now I have a table of basic ingredients (milk, sugar, etc) along with cost of same.
What I want to do is be able to set up a recipe that calls for "3 eggs, 1 sugar, 1 milk" and automatically figure the cost for me.
Ideally, I'd like this to be a "building block" spreadsheet - where I can have a recipe for "roux" (1 flour, 1 butter), and then a recipe for "broth" (1 chicken, 3 water), and then a recipe for "gravy" (1 roux, 2 broth) - where the spreadsheet is smart enough to do the math for me - and if the price of chicken goes up, I can change that in my basic list and it will carry down. And obviously, I want to be able to add ingredients and recipes easily.
View 3 Replies
View Related
Feb 11, 2009
some of your favorite Methods/Properties exposed by the Range Object. How's bout some that you just can't live without?
Have an tricks for example that you can do with XLS03 that for example couldn't do with XLS2K or perhaps XLS07 that you couldn't do with XLS03?
View 9 Replies
View Related
May 25, 2009
Let`s assume that I have numerous "Serial Number" in "Sheet1" : http://i40.tinypic.com/2iqbspt.jpg
Now I want to create some cards in "Sheet2" that each card have a serial number that related serial number there is in "Sheet1" : http://i43.tinypic.com/34fz690.jpg. Need easy solution for doing it while when I drag one card to copying it then related serial number in sheet1 would be appear in required field. I mean first card has first serial number of sheet1 and second card has second serial number of sheet 1 ; but I want to doing it quickly with dragging.
View 4 Replies
View Related
Nov 5, 2007
I run the company office pool / lottery. A person selects 6 numbers 1-49. Twice a week the provincial draw is held. if your number matches the drawn number i would highlight your number on the spreadsheet. When all of your numbers are highlighted, you win. This usually takes 3-4 draws to cover all your numbers. Ideally i would like to simply enter the drawn numbers & have excel automatically highlight the number next to each persons name if they have selected that number.
View 9 Replies
View Related
May 30, 2008
Does anyone know of an Excel macro or function that can generate say 1000 strings of 6 numbers from 1 to 49, without repeating the same combinations?
Kind of like the random picks that lottery machines generate.
View 9 Replies
View Related
Aug 2, 2008
I am tring to list and count how many pairs in a 4 digit lottery?
no duplicates ...
View 13 Replies
View Related
Dec 7, 2008
I am trying to set up a lottery spreadsheet, where I enter the results and matching numbers would be highlighted
View 9 Replies
View Related
Mar 29, 2002
You must install "Analysis TookPak-VBA" before doing this; check in your Excel's Tools/Add-Ins menu. Paste this long function (see below) in an Excel's worksheet (any cell) and press F9 (calculate) until you see at least 2 identical numbers. Real life's lottery does not have repeating numbers. I can disable this repetition by using cells relation but I want to use just one (1) cell. Any expert wants to challenge? If not, you can use VBA. But it still requires one (1) line of codes.
=RANDBETWEEN(1,50)&" "&RANDBETWEEN(1,50)&" "&RANDBETWEEN(1,50)&" "&RANDBETWEEN(1,50)&" "&RANDBETWEEN(1,50)&" "&RANDBETWEEN(1,50)
View 9 Replies
View Related
Feb 25, 2009
is it possible to play dos games through excel? i want to somehow play my old championship manager games in excel whist at work (i don't actually want to work!!)
View 4 Replies
View Related
Oct 16, 2008
This is what I have,
Private Declare Function PlaySound Lib "winmm.dll" _
Alias "PlaySoundA" (ByVal lpszName As String, _
ByVal hModule As Long, ByVal dwFlags As Long) As Long
Const SND_SYNC = &H0
Const SND_ASYNC = &H1
Const SND_FILENAME = &H20000
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If UCase(ActiveSheet.Range("S41").Value) > 99 Then
FName = "C:windowsmediading.wav"
Call PlaySound(FName, 0&, SND_ASYNC Or SND_FILENAME)
End If
End Sub
but I cant get it to work!
All I want is for it to play a sound when My Value in S41 goes over the Value 99
the value is part of a simple formula of sums.
View 9 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
Jul 13, 2013
Just want to know if there is a way to play a sound based on the value of a cell. In this case, if the cell says "S" then the sound is a low note and if the cell says "L" then the sound is a high note. If the cell is "" then there is no sound.
View 1 Replies
View Related
Mar 26, 2014
How do I get my spreadsheet to play wav files I have saved according to certain criteria?
i.e. if certain value is entered into the cell, or on opening of the spreadsheet
I have message boxes appearing for the values in certain cells, however, don't know how I would add in the playing of a wav file to enhance this.
View 3 Replies
View Related
Oct 4, 2007
I have the following data in excel (just an example):
X | Y1 | Y2
-3 | 9 | 1
-2 | 4 |
-1 | 1 | 1.5
0 | 0 |
1 | 1 | 1.5
2 | 4 |
3 | 9 | 1
I want to play Y1 and Y2 against X. Y2 does not appear on the chart because it's not continuous. I would like to plot Y1 (as a continuous graph) and a Y2 as dots (or scattered as excel lables it).
View 4 Replies
View Related
Jun 25, 2009
I am trying to make a sound play in excel. I have the following code in an excel spreadsheet on my computer at home. When I do the same code on my computer at work, the sound will not play.
Private Sub Worksheet_Change(ByVal Target As Range)
If Range("joe").Value > 100 Then
For x = 1 To 3
Beep
Next x
End If
End Sub
Any thoughts as to what the problem is?
View 7 Replies
View Related
Oct 17, 2007
I would like to create a macro that plays a sound every 45 seconds or so. In other words, I would like to have a countdown timer that counts from 45 seconds down to 0 seconds and at the end it plays a sound file(could be mp3, wav, etc) to signal the end. After that it should automatically reset itself back to the start of 45s and count down again. This would be repeated about ten to eleven times. What is the easiest way of doing this? It's too confusing. Lets say the audio file was located in: C:my soundseep.wav
View 2 Replies
View Related
