How To Compare data in Multiple Columns
Closed
umesh chaudhari
Posts
1
Registration date
Monday March 25, 2013
Status
Member
Last seen
March 25, 2013
-
Mar 25, 2013 at 01:33 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Mar 26, 2013 at 10:38 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Mar 26, 2013 at 10:38 AM
Related:
- How To Compare data in Multiple Columns
- Transfer data from one excel worksheet to another automatically - Guide
- Excel data validation list from table multiple columns - Guide
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
- How to allow multiple downloads in chrome - Guide
- Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Excel Forum
1 reply
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
545
Mar 26, 2013 at 10:38 AM
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