help with writing a program in excel

goat178

New Member
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

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple
maybe a bit more info would help us here, please explain further.

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

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

I still think further info is required, cannot visualise the problem

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

Replies
3
Views
756
Replies
3
Views
178
Replies
31
Views
3K
Replies
3
Views
134
Replies
4
Views
218

Threads
1,203,632
Messages
6,056,452
Members
444,866
Latest member
cr130

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

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