|
10-19-2017, 12:39 AM
|
|
Expert
|
|
Join Date: Apr 2011
Location: West Midlands
Posts: 981
|
|
Hi
Many thanks for the quick response but this does not appear to work.
Kind regards
Tony
Quote:
Originally Posted by ArviLaanemets
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
|
|