Previous Topic Next Topic

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 response

Answer 1 / 1
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

Similar discussions

Comparing columns and returning value
ll -
kittu -

35 responses
Extract identical cells of 2 columns (excel)
Little bit lost -
keliza -

3 responses
Compare columns in two sheets and copy info across
pashnak -
Mazzaropi -

1 response
Find missing data in 2 columns (Excel)
dalami81 -
dalami81 -

2 responses
Macro to Select Multiple Columns by Columns Specific Headings to Delete Dupes
jackied25 -
TrowaD -

2 responses