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
- Tweetdeck larger columns - Guide
- Display two columns in data validation list but return only one - Guide
- How to delete columns in word - Guide
- Insert a new sheet at the end of the tab names and paste the range names starting in cell a1. autofit columns a:b and name the worksheet as range names. ✓ - Excel Forum
- Excel Macro - Set and autofill a range? ✓ - Excel Forum
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)
