On fly, let's assume your datarange is D2:E10
Into F2 enter the formula
=$D2 + AND(COUNTIFS($D$2:$D2,$D2)>1,COUNTIFS($E$2:$E2,$E2 )>1)*0,3
Into G2 enter the formula
=$E2 + AND(COUNTIFS($D$2:$D2,$D2)>1,COUNTIFS($E$2:$E2,$E2 )>1)*0,3
Copy F2:G2 down to F10:G10
|