How do I revised the formula in cell L2 to do the opposite and display ONLY the duplicates?

[arthurz11]

I want to display the opposite of what the formula does. How do I revised the formula to display the duplicates and not display the ones that are not duplicated?
So on the first roll is should be just -2,-7, row 2 should be blank, row 3 should be blank, and row 4 should be -6,-2.

 

[james_martin001]

COUNTIF, or COUNTIFS with more than one condition?

If COUNTIF of cell A2 is >1, you can indicate if each cell on the row in the first table is a lone value or not. You have to use $ symbols to lock the row range in the table you are refering to, if you are going to drag the formulas to other rows/cells.

Can't comment on your existing formula without access to Excel at the moment.

 

[arthurz11]

Would you please be so kind as to let me know when you can? I really appreciated.

 

[arthurz11]

This is how it should be:

 

[Rick Rothstein]

Why isn't the result for the second row -3 and the result for the third row 0?

 

[arthurz11]

Why isn't the result for the second row -3 and the result for the third row 0?

Because it only checks (x,y) coordinates. (-3,-5) is not the same as (-2,-3) as the same with (0,-6) is not the same as (6,0)

 

[arthurz11]

COUNTIF, or COUNTIFS with more than one condition?

If COUNTIF of cell A2 is >1, you can indicate if each cell on the row in the first table is a lone value or not. You have to use $ symbols to lock the row range in the table you are refering to, if you are going to drag the formulas to other rows/cells.

Can't comment on your existing formula without access to Excel at the moment.

Would you please be so kind as to let me know when you can? I really appreciated.