Comparing Columns
Closed
djoell
Posts
1
Registration date
Wednesday July 10, 2013
Status
Member
Last seen
July 10, 2013
-
Jul 10, 2013 at 08:19 PM
Muhasin AM Posts 2 Registration date Thursday July 11, 2013 Status Member Last seen July 11, 2013 - Jul 11, 2013 at 01:35 AM
Muhasin AM Posts 2 Registration date Thursday July 11, 2013 Status Member Last seen July 11, 2013 - Jul 11, 2013 at 01:35 AM
Related:
- Comparing Columns
- Excel data validation list from table multiple columns - Guide
- Excel compare two columns for partial matches - Guide
- Google sheets right to left columns - Guide
- Excel change columns to numbers - Guide
- Tweetdeck wider columns - Guide
1 response
Muhasin AM
Posts
2
Registration date
Thursday July 11, 2013
Status
Member
Last seen
July 11, 2013
Jul 11, 2013 at 01:35 AM
Jul 11, 2013 at 01:35 AM
To use a worksheet formula to compare the data in two columns, follow these steps:
Start Excel.
In a new worksheet, enter the following data (leave column B empty):
A1: 1 B1: C1: 3
A2: 2 B2: C2: 5
A3: 3 B3: C3: 8
A4: 4 B4: C4: 2
A5: 5 B5: C5: 0
Type the following formula in cell B1:
=IF(ISERROR(MATCH(A1,$C$1:$C$5,0)),"",A1)
Start Excel.
In a new worksheet, enter the following data (leave column B empty):
A1: 1 B1: C1: 3
A2: 2 B2: C2: 5
A3: 3 B3: C3: 8
A4: 4 B4: C4: 2
A5: 5 B5: C5: 0
Type the following formula in cell B1:
=IF(ISERROR(MATCH(A1,$C$1:$C$5,0)),"",A1)