Narrowing result to only NEW (and updated) entries

[Andrewstupendo]

Hello All,
I am in need of a formula that will enter only the new/updated data in Column C of the attached. I've tried many different multiple conditions formulas, but I can't seem to get this one right.
As you can see from my attached example, the formula (in column C) must determine which entries should appear. If previous entries appear in column B and if column B equals column A, then a zero will appear, otherwise a non-zero number will appear in column C. Column A lists all entries (previous, new and updated). Column B lists only previous entries. Column C lists only new/updated entries.

Best,
Andrewstupendo

[azumi]

Hope this right, put in D2 then copied down

=IF(A2=B2,0,A2)

[TMS]

Try:

Please Login or Register  to view this content.

[TMS]

Thanks for the rep.