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 December 27, 2022 - Mar 26, 2013 at 10:38 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Mar 26, 2013 at 10:38 AM
Related:
- How To Compare data in Multiple Columns
- Display two columns in data validation list but return only one - Guide
- How to lasso multiple objects in photoshop - Guide
- Tmobile data check - Guide
- How to delete multiple files on mac - Guide
- Beyond compare - Download - File management
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
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
