Group data by quarters


 

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.

How to upload a file
Upload file

Copy filtered excel tables in vba


 

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.

How to upload a file
Upload file

Highlight a selected cell´s row and column


 

5 Responses to “Highlight a selected cell´s row and column”

  1. shimaa01234 says:

    Great job and is very useful
    Thank you very much Mr. (Oscar)

  2. mahmoudlee123 says:

    Work more than wonderful, because you are a wonderful person

  3. Manish says:

    Dear Oscar
    i want to highlight the row if checkbox in my customised menu is clicked.
    please help & provide code.

  4. Olvavila says:

    Dear Oscar

    In your first example Excel highlights all rows until last column (XFD). I need highlight from column A to column R. Is it possible?

    Thanks!

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.

How to upload a file
Upload file

Optimize pick path in a warehouse


 

One Response to “Optimize pick path in a warehouse”

  1. domain says:

    You're so interesting! I do not think I've truly read something
    like this before. So good to discover somebody with a few
    unique thoughts on this subject matter. Really..
    thanks for starting this up. This site is something that
    is required on the internet, someone with a little originality!

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.

How to upload a file
Upload file

Compare two lists and filter unique values where the sum in one column doesn’t match the other column


 

4 Responses to “Compare two lists and filter unique values where the sum in one column doesn’t match the other column”

  1. mahmoud-lee says:

    All formulas that belong to you wonderful

  2. Sean says:

    Thanks Oscar. Works great. Is there a way to include items that are not in list B in the same formulas. For example C would have avalueof 4 in list A, but it's not in list 2.

    • Oscar says:

      Sean,

      Thanks Oscar. Works great. Is there a way to include items that are not in list B in the same formulas. For example C would have a value of 4 in list A, but it's not in list 2.

      Array formula in cell B10:
      =IFERROR(INDEX($E$3:$E$7, MATCH(0, COUNTIFS($B$3:$B$7, $E$3:$E$7, $C$3:$C$7, $F$3:$F$7)+COUNTIF($B$9:B9, $E$3:$E$7), 0)), INDEX($B$3:$B$7, MATCH(0, COUNTIFS($E$3:$E$7, $B$3:$B$7, $F$3:$F$7, $C$3:$C$7)+COUNTIF($B$9:B9, $B$3:$B$7), 0)))

  3. Pablo says:

    Thanks so much for this invaluable resource, Oscar! I have a question which I don't think is answered by your posts on this topic. Here's an example:

    Apples 1
    Apples 1
    Oranges 2
    Apples 3
    Apples 3
    Bananas 4
    Bananas 4

    I'm trying to create a formulate that would generate the following list:

    Apples
    Oranges
    Apples
    Bananas

    That is, I want the formula to use the second column as a criterion for generating the unique list, but the first column as the range for the corresponding values. I hope this is clear, but I'm happy to elaborate if it isn't. Thanks again!

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.

How to upload a file
Upload file