Date S/No Name Dept R/No
26/07/09 01 ABC M1 M001
26/07/09 02 DEF S1 S001
26/07/09 03 GHI A1 A001
27/07/09 04 DEF S1 S001
27/07/09 05 ABC M1 M001
27/07/09 06 GHI A1 A002

I have a long list of records as shown above, how can I copy the list to
another range with records for "Name", "Dept" and "R/No" not duplicated and
showing the latest S/No. In other words, Record 1 and Record 2 should not
appear as it is duplicated in Record 5 and Record 4 respectively.

The new list should only shows:

Date S/No Name Dept R/No
26/07/09 03 GHI A1 A001
27/07/09 04 DEF S1 S001
27/07/09 05 ABC M1 M001
27/07/09 06 GHI A1 A002

Thanks for any help i can get.