|
01-27-2012, 08:03 AM
|
|
Novice
|
|
Join Date: Sep 2011
Posts: 5
|
|
Quote:
Originally Posted by Catalin.B
There is more you can do:
Select the column C, which has formulas, right click on selection then paste back in the same range, but paste only values, so there will be no formulas on column C. Same thing on column E formulas, replace them with the values.
Then , with values in C and E columns,
put this formula in an empty column, same row: 1027:
=SUBSTITUTE(E1027;SUBSTITUTE(C1027;D1027;"");"")
This will remove from column d the data which exists on columns C and E.
Then select this range of substitute formulas, copy, paste only values back on column D.
|
That formula isn't working correctly. When I enter it in all it does is give me the same value that is in column E and doesn't delete anything from column D.
|