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

How To Compare data in Multiple Columns
Data validation multiple columns - Guide
Excel - Compare data from two columns - How-To - Excel
Comparing data in 3 columns on a Microsoft Excel spreadsheet ✓ - Forum - Excel
Compare data in seperate columns to find likely matches ✓ - Forum - Excel
Comparing dates in multiple columns and using one that matches ✓ - Forum - Excel

1 reply

Answer 1 / 1

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

Subscribe To Our Newsletter!