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
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

Muhasin AM Posts 2 Registration date Thursday July 11, 2013 Status Member Last seen July 11, 2013
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)
0