Like Operator

Leave a Reply

How to add vba code to your comment:
[vb 1="vbnet" language=","]
your code
[/vb]

How to add a picture to your comment:
Upload picture to postimage.org
Add picture link to comment.

Contact Oscar

You can contact me through this webpage


Build a stock chart with two series

Leave a Reply

How to add vba code to your comment:
[vb 1="vbnet" language=","]
your code
[/vb]

How to add a picture to your comment:
Upload picture to postimage.org
Add picture link to comment.

Contact Oscar

You can contact me through this webpage


Calendar – monthly view

2 Responses to “Calendar – monthly view”

  1. Diana says:

    Excellent, excellent job Mr. Oscar !!!

Leave a Reply

How to add vba code to your comment:
[vb 1="vbnet" language=","]
your code
[/vb]

How to add a picture to your comment:
Upload picture to postimage.org
Add picture link to comment.

Contact Oscar

You can contact me through this webpage


Round-robin tournament

One Response to “Round-robin tournament”

  1. Guy says:

    Oscar
    Thank you for this work. This is exactly what I need for a small / local table football league we have just started. Thank you very much.
    Guy

Leave a Reply

How to add vba code to your comment:
[vb 1="vbnet" language=","]
your code
[/vb]

How to add a picture to your comment:
Upload picture to postimage.org
Add picture link to comment.

Contact Oscar

You can contact me through this webpage


List permutations with repetition and how many to choose from

2 Responses to “List permutations with repetition and how many to choose from”

  1. jimmy munisi says:

    I have 17 games to bet, and am suppose to choose win, loose and draw.
    How can I create a table with 17,matches with win,lose and draw? How many table will appear?

    • Oscar says:

      jimmy munisi,

      The outcome is either win, lose or draw, three possibilities.
      There are 17 games. 3^17 = 129 140 163 permutations.
      If you want to list all permutations in a workbook, each sheet has 1 048 576 rows.
      129 140 163 / 1 048 576 = 123.1 sheets
      You need 124 worksheets in a workbook to list all permutations.

Leave a Reply

How to add vba code to your comment:
[vb 1="vbnet" language=","]
your code
[/vb]

How to add a picture to your comment:
Upload picture to postimage.org
Add picture link to comment.

Contact Oscar

You can contact me through this webpage