Comparing Columns

Closed
Posts
1
Registration date
Wednesday July 10, 2013
Status
Member
Last seen
July 10, 2013
-
Posts
2
Registration date
Thursday July 11, 2013
Status
Member
Last seen
July 11, 2013
-
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

1 reply

Posts
2
Registration date
Thursday July 11, 2013
Status
Member
Last seen
July 11, 2013

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)