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

10 Responses to “Calendar – monthly view”

  1. Diana says:

    Excellent, excellent job Mr. Oscar !!!

  2. Ray says:

    Thankyou Oscar,

    I am very impressed with your Excel examples. The one that tops it all for me was your detailed Pivot Table - a masterclass...

    Regards,

    Ray

  3. Hung says:

    I do not know why the hyperlink in column J sheet Monthly view does not work(?) please help. Thanks

    • Oscar says:

      Hung,

      You are right, thanks for telling me.
      My blog (WordPress) has changed the name of the workbook when I uploaded the file, the hyperlink function uses another workbook name and that won't work.
      Anyway, I have uploaded a new workbook and this time it seems to work.

  4. Hung says:

    Sorry I don't know how to use Recurring event. Please help. Thanks

    • Oscar says:

      Monthly formula:
      =IF(DAY(TODAY())>3, DATE(YEAR(TODAY()), MONTH(TODAY())+1, 3)+11/24, DATE(YEAR(TODAY()), MONTH(TODAY()), 3)+11/24)
      Change the bolded numbers above to select a day in a month. The example above uses the 3rd in every month. 11/24 is 11 AM. A day has 24 hours.

      Weekly formula:
      =TODAY()+IF(WEEKDAY(TODAY())< =3, 3-WEEKDAY(TODAY()), (10-WEEKDAY(TODAY())))+15/24

      Change number 3 above to select a weekday, 1 is Sunday, 2 is Monday and so on. 15/24 is 3 pm.

      The daily formula is self explanatory.

      To use a recurring event, go to sheet schedule and select a cell in column "Day and Time" on an event you want to recur. Change the value to the desired formula.

  5. Hung says:

    wow, I got it :) thanks a lot

    one small thing need to change in macro Add Event: row 5 to row 6

    Worksheets("Schedule").Range("B" & Lrow) = ActiveSheet.Range("N5")
    Worksheets("Schedule").Range("C" & Lrow) = ActiveSheet.Range("M5")
    ActiveSheet.Range("M5:N5") = ""

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