|
|
#7
10-19-2017, 05:03 AM
|
|||
|
|||
The formulas work!
In returned workbook, into columns J:K new values for both columns are calculated. In cell N1 FALSE indicates, that there are differences with values in original table - so copy values from J2:K17 into D2:E17 (Use PasteSpecial>Values to copy only values, not formulas!) When after that in N1 the formula returns TRUE, then there aren't any duplicate rows in D2:E17 anymore, otherwise repeat coping values from J2:K17 into D2:E17. 
|
|
|
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