How To Compare data in Multiple Columns
Closed
umesh chaudhari
TrowaD
- Posts
- 1
- Registration date
- Monday March 25, 2013
- Status
- Member
- Last seen
- March 25, 2013
TrowaD
- Posts
- 2884
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 21, 2022
Related:
- How To Compare data in Multiple Columns
- Data validation multiple columns - Guide
- Excel - Compare data from two columns - How-To - Excel
- Comparing data in 3 columns on a Microsoft Excel spreadsheet ✓ - Forum - Excel
- Compare data in seperate columns to find likely matches ✓ - Forum - Excel
- Comparing dates in multiple columns and using one that matches ✓ - Forum - Excel
1 reply
TrowaD
Mar 26, 2013 at 10:38 AM
- Posts
- 2884
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 21, 2022
Mar 26, 2013 at 10:38 AM
Hi Umesh,
Issue remains how you want to see the result.
Conditional format could be an option. Use formula like:
=OR(A1-A2>100,A2-A1>100)
Best regards,
Trowa
Issue remains how you want to see the result.
Conditional format could be an option. Use formula like:
=OR(A1-A2>100,A2-A1>100)
Best regards,
Trowa