Filtering Unique Customers

[vijaydsk1970]

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

 

[Max]

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$22=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.