Cut Duplicate Records based on criteria
 

Hello All
I have a set of records with five columns viz.,
Name Address City State Date Status

All the columns are self-explanatory. The Status column has one of
values (approximate, confirmed, estimates).

The program has to find duplicate records based on the condition that
Name Address City and State are same.

Once, the duplicate records are found, the program has to check for
Status of the record. If the status is confirmed, then the program
should cut the other duplicate records and paste them in another sheet.

If none of the records have Status as confirmed, then the next criteria
is date. The program has to check for the latest date and cut and paste
other records in another sheet.

If more than one record has status as confirmed, then apply the same
above rule.

I know its complex.

Thanks in advance

Shiva