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