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
2884
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 21, 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

1 reply

TrowaD
Posts
2884
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 21, 2022
512
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