Need formula for comparing differences of two columns.
Solved/Closed
oduana777
Posts
7
Registration date
Thursday January 12, 2017
Status
Member
Last seen
March 23, 2017
-
Jan 12, 2017 at 05:15 PM
oduana777 Posts 7 Registration date Thursday January 12, 2017 Status Member Last seen March 23, 2017 - Feb 4, 2017 at 05:21 PM
oduana777 Posts 7 Registration date Thursday January 12, 2017 Status Member Last seen March 23, 2017 - Feb 4, 2017 at 05:21 PM
Related:
- Need formula for comparing differences of two columns.
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Display two columns in data validation list but return only one - Guide
- Excel grade formula - Guide
- Number to words in excel formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
3 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Jan 12, 2017 at 08:58 PM
Jan 12, 2017 at 08:58 PM
oduana777, Good evening.
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.
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.
voniej
Posts
1
Registration date
Friday January 13, 2017
Status
Member
Last seen
January 16, 2017
Jan 13, 2017 at 10:13 AM
Jan 13, 2017 at 10:13 AM
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.
oduana777
Posts
7
Registration date
Thursday January 12, 2017
Status
Member
Last seen
March 23, 2017
Feb 4, 2017 at 05:21 PM
Feb 4, 2017 at 05:21 PM
Thanks! Problem solved.