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