|
|
#2
10-18-2017, 07:16 AM
|
|||
|
|||
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 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Help with an IF Formula | Cbate | Excel | 1 | 08-17-2017 07:29 AM |
 Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula
|
innkeeper9 | Excel | 2 | 09-13-2016 08:59 PM |
| Help With a Formula | OTPM | Excel | 3 | 05-26-2016 03:42 AM |
| Need help with dragging a formula and changing a reference column as I drag the formula. | LupeB | Excel | 1 | 10-22-2015 03:02 PM |
|
Help with formula please.
|
AndrewSE | Excel | 3 | 04-05-2011 08:50 PM |
Windows 8 
Office 2016
Threaded Mode