- Need formula for comparing differences of two columns.
- A formula for comparing values in two columns
- Excel - Compare data from two columns
- Compare numbers in two columns in Excel (Solved)
- Compare cells of two columns excel 2007 (Solved)
- Compare values in two columns and return the value from third (Solved)

I'm not sure if I understood well your necessity.

Try to use:

C1 --> =A1-B1

Copy this formula down.

Is that what you want?

I hope it helps.

You could use either:

=C6<>D6

or

=IF(C6<>D6,"","Diff")

The first: place the formula in column E. It will show either a true or false in the fields as you copy it down

The second: will show 'Diff' only if the two cells do not match.

Hope this helps.

=C6<>D6

or

=IF(C6<>D6,"","Diff")

The first: place the formula in column E. It will show either a true or false in the fields as you copy it down

The second: will show 'Diff' only if the two cells do not match.

Hope this helps.

Thanks! Problem solved.

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.