How To Compare data in Multiple Columns

[Closed]
Report
Posts
1
Registration date
Monday March 25, 2013
Status
Member
Last seen
March 25, 2013
-
Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
-
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

1 reply

Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
486
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