pairs/triples

[normski2]

was googling for a program to pick pairs/triples from data i have for my football bets.
i came across a formula but have no idea how to put it on an excel spreadsheet.
can anyone on here do it or point me in the right direction.
i dont mind paying
any help would be appreciated.
this is the formula

[Mumps1]

Do the following: Hold down the ALT key and press the F11 key. This will open the Visual Basic Editor. In the menu at the top click 'Insert' and then click 'Module'. Copy and paste the macro into the empty code window that opens up. Press the F5 key to run the macro. Close the code module window to return to your sheet. There are other quicker ways to run the macro such as assigning it to a button that you would click on your sheet or assigning it to a short cut key. I am assuming here that the code works properly.

[normski2]

thanks mumps.
tried it but it comes up compile error and syntax error
any ideas where i could get a program or formula which would find the pairs and triples from the data i have?
thanks for your help.

[zbor]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[normski2]

hi wasn't too sure what you meant so have edited 1st post and deleted formula as i couldn't get it to work.