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
Hello,

I have the below data in four columns

14 25 36 214
14 785 114 2563

I have to find out if any two value from the columns have difference of >100.

How can i do it???? Please
Related:

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
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
0