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
Hello,
I have two list of customers on separate excel worksheets. The first list has name, address, etc. in separate columns and about 3000 customers. The same with list two and about 800 customers. Some of the customers will overlap. I need to compare list 2 against list 1 and determine the ones that duplicate. I need to use the address columns to run the comparison. I then need the results to be shown on a third worksheet. Is it possible to have the entire row show on the third sheet?
Thanks
I have two list of customers on separate excel worksheets. The first list has name, address, etc. in separate columns and about 3000 customers. The same with list two and about 800 customers. Some of the customers will overlap. I need to compare list 2 against list 1 and determine the ones that duplicate. I need to use the address columns to run the comparison. I then need the results to be shown on a third worksheet. Is it possible to have the entire row show on the third sheet?
Thanks
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 compare two columns for partial matches - 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)
