Filtering Unique Customers
 

I have more than 30 thousand records in a sheet with name and address1,
address2..... to address 5 in different columns. i want to filter and
identify with red colur fill, the duplicate records where name, address1
........ address5 matches. Either VBA or UDF will sort out my problem.

Thanks in Advance

Filtering Unique Customers
 

One venture using a helper col to flag duplicates (predicated by 6 cols as
per post) for autofilter ..

Assume source data in cols A to F, from row2 down
Set the calc mode to manual first (Tools Options Calculation tab)

Put in G2:
=IF(COUNTA(A2:F2)=0,"",IF(SUMPRODUCT((A$2:A2=A2)*( B$2:B2=B2)*(C$2:C2=C2)*(D$2:D2=D2)*(E$2:E2=E2)*(F$ 2:F2=F2))1,"X",""))
Copy down to last row of data, G30001?. Press F9 to calc. When calc
completes (it would take some time), select col G and do an "in-place" copy n
paste special as values. Then do an autofilter on col G, filter out "X".
These will be the duplicate lines.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"vijaydsk1970" wrote:
I have more than 30 thousand records in a sheet with name and address1,
address2..... to address 5 in different columns. i want to filter and
identify with red colur fill, the duplicate records where name, address1
....... address5 matches. Either VBA or UDF will sort out my problem.

Thanks in Advance