Excel tables

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


Rotating unique groups with no repeat

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


Time sheet for work

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


Extract cell references from a formula

One Response to “Extract cell references from a formula”

  1. Oscar says:

    I managed to simplify the regular expression to this:
    '?([a-zA-Z0-9\s\[\]\.])*'?!?\$?[A-Z]+\$?[0-9]+(:\$?[A-Z]+\$?[0-9]+)?

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


Filter rows where a cell contains a numeric value

5 Responses to “Filter rows where a cell contains a numeric value”

  1. John says:

    Hello Oscar
    I place lots of pictures in word 2016 files. As a person reads the report, I would like a button in the line to open a picture. The picture would relate to the text that was just read. Like you did with Excel (Show / Hide). It would be great if I could change the pictures with ease. Could you write this program? What would be the cost?
    John

  2. SACHIN says:

    Dear Oscar,
    I Need solution to get summary of days on which the specific leaves have been taken by an employee. Suppose on Ist and 2nd day he availed two casual leaves so summary of days should be come up like 1,2(days) in same row and same applicable for Present days, Festival Holidays.

    1 2 3 4 5 6 7 CL FH P
    CL CL P P P NH NH 1,2 14,15,16 3,4,5,

    Would be grateful to you.

    Warm Regards
    SACHIN

  3. Abbasabdulla says:

    Hello Oscar, Honestly you are one of the most skilful, intelligent people in excel/vba field. You have unique way of teaching others and communicating knowledge. Simply you awesome. Thank you very much. I am regular reader of your site and I find it very useful learning resource.

  4. M. Saad says:

    dear Oscar, many thanks for your support & efforts
    i need your help,
    i have excel sheet as follow
    AAA 18-Jan-17
    AAA 19-Jan-17
    AAA 20-Jan-17
    AAA 18-Mar-17
    AAA 22-Jan-17
    AAA 23-Jan-17
    BBB 24-Jan-17
    BBB 25-Jan-17
    BBB 18-Mar-17
    BBB 27-Jan-17
    BBB 28-Jan-17
    BBB 29-Jan-17
    BBB 30-Jan-17
    CCC 31-Jan-17
    CCC 1-Feb-17
    CCC 2-Feb-17
    CCC 18-Mar-17
    CCC 4-Feb-17
    CCC 5-Feb-17

    column A has over than 30000 rows consist of duplicate values and in column B the date corresponding to this value.
    i wish to create conditional format formula to identify the most recent date only.
    in the above example i wish to highlite only the date of 18-March-17.

    hope to hear from you soon

    kind regards

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