Locate suit formations after typing the desired digits in a field .

piter

Active Member
Joined
Jul 22, 2011
Messages
314
Office Version
  1. 2016
Platform
  1. Windows
Locate suit formations after typing the desired digits in a field
Then in a huge left list with over 10,000 suits
* Macro will filter according to selected or selected digits
* De = 0 1 2 3 4 5 6 7 8 9
* Example selection = 0 1 2 3 4 5 6 7 8 9
********************** Suit = 01 34 781,6,5,7,0,2 is not showing the formations with the digitios 1,6,5,7,0,2
16 52 70
10 62 75
...
The a macro has to show in a list next to the formations of the 6 unrepealed digits
= digit in the field = 1,6,5,7,0,2, the macro will look for all the suits with the six digits ok
29 45 67
29 45 76
29 45 73
29 45 63
29 45 71
29 45 61
29 46 50
29 46 70
29 46 80
29 46 58
29 46 78
29 46 57
29 46 75
29 46 73
29 46 53
29 46 71
29 46 51
29 47 50
29 47 60
29 47 80
29 47 58
29 47 68
29 47 56
29 47 65
29 47 63
29 47 53
29 47 61
29 47 51
29 48 50
29 48 60
29 48 70
29 48 67
29 48 57
29 48 56
29 48 76
29 48 75
29 48 65
29 48 73
29 48 63
29 48 53
29 48 71
29 48 61
29 48 51
29 50 68
29 50 78
29 50 67
29 50 76
29 50 64
29 50 74
29 50 73
29 50 63
29 50 71
29 50 61
29 58 60
29 60 78
29 57 60
29 60 75
29 54 60
29 60 74
29 60 73
29 53 60
29 60 71
29 51 60
29 58 70
29 68 70
29 56 70
29 65 70
29 54 70
29 64 70
29 63 70
29 53 70
29 61 70
29 51 70
29 67 80
29 57 80
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Forum statistics

Threads
1,213,506
Messages
6,114,025
Members
448,543
Latest member
MartinLarkin

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