help with writing a program in excel

goat178

New Member
Joined
Sep 24, 2002
Messages
2
i am an excel beginner and trying to write a short lottery program which would return a certain triple digit value for any combination of the inputed value.

example if inputed = 184
then value = 111

1 8 4

COMBINATIONS
184 841 418
814 481 148

000 111 222 333
363 184
473 435
552 342
406 675
470 188
76 384
115 779
272 216
366 141
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
In my worshee i would like to enter a value in 3 different cells. The values are then calculated to return 6 combinations.

eg. 184 would return
184 841 418
814 481 148

After these combinations are derived there is a triple digit value that should correspond to any one the combinations.

If any one of the combinations are in the list under a specific triple digit, then the program returns that triple digit as the number that corresponds to your inputed values.

000 111 222 333
363 184
473 435
552 342
406 675
470 188
76 384

eg. VALUE 1 8 4 (values placed in seperate cells)

TRIPLE = 111
 
Upvote 0
Hi, could you confirm if this describes your problem:

Set-up
1) I have columns of 3 digit numbers
2) Each 3 digit number will only turn up once in these columns
3) Each column has a column heading (also a 3 digit number)
4) In another area, I have 3 single digit numbers.

Problem
If any permutation of my three single digits turns up in the columns set out in (1), return that column heading?

If this is right, what about where one permutation turns up in one colummn and another permutation in another??? Could you be a little clearer about what the problem is here!

Paddy
 
Upvote 0
would normal lotter code in VBA work, ill post to teh board if so, also search as i have posted this code before a few times as many have

search lottery

JACK
 
Upvote 0

Forum statistics

Threads
1,223,497
Messages
6,172,644
Members
452,467
Latest member
colelkay

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top