Highlight a selected cell´s row and column


 

4 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. Corry says:

    This will be extremely helpful when analyzing and comparing data. Thank you.

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


 

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


 

3 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)))

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

A quicker A * pathfinding algorithm


 

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

Learn how the MOD function works


 

3 Responses to “Learn how the MOD function works”

  1. dopsz says:

    Hello! Very interesting but the Highlighting every other group Example 1 upon the first column values doesn't actually work as expected. Please try to put i.e. 2 in A7. Any clue why?

    • Leonid says:

      It's rounding issue. To fix it just use INT function:
      =MOD(INT(SUM(1/COUNTIF($A$2:$A2,$A$2:$A2))),2)
      Example 1 would be more representative if we have textual values in column A instead of numbers. In the example as it is we can use simply MOD($A2,2). But with textual values it's much trickier, and the Example 2 is where Oscar's formula realy shows its power.

    • Oscar says:

      dopsz,

      Very interesting but the Highlighting every other group Example 1 upon the first column values doesn't actually work as expected. Please try to put i.e. 2 in A7. Any clue why?

      You are right, I forgot to add that column A must be sorted.

      Leonid,

      Example 1 would be more representative if we have textual values in column A instead of numbers. In the example as it is we can use simply MOD($A2,2). But with textual values it's much trickier, and the Example 2 is where Oscar's formula really shows its power.

      Yes, bad example. I have changed values in column A.

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