I have a large file with numerous duplicates. I would like to remove duplicates, however I need to differentiate which duplicates to remove.
i.e. Linda Glover has 3 entries (some might have many more). I need to keep the entry that shows the highest amount paid but most recently and delete the other entries corresponding to her name.
What is the most recommended (simplest) solution?
[TABLE="width: 550"]
[/TABLE]
Appreciate your time and I thank you in advance
[TABLE="width: 422"]
Customer ID
Last Name
[/td]
[TD="align: left"]First Name
[/TD]
Date
[/td][td]Amount
123456
[/td][td]Louzada
[/td]
[TD="align: left"]Carlos[/TD]
7-Dec-14
[/td][td]-
[/td][/tr][tr][td]44444
[/td][td]Spina
[/td]
[TD="align: left"]Anna[/TD]
7-Dec-14
[/td][td]-
[/td][/tr][tr][td]802307
[/td][td]Spina
[/td]
[TD="align: left"]Domingos[/TD]
7-Dec-14
[/td][td]-
[/td][/tr][tr][td]41807
[/td][td]McKnight
[/td]
[TD="align: left"]David[/TD]
14-Dec-14
[/td][td][/td][/tr][tr][td]45160
[/td][td]Genovese
[/td]
[TD="align: left"]Sherry[/TD]
14-Dec-14
[/td][td]$200.00
619007
[/td][td]Glover
[/td]
[TD="align: left"]Linda[/TD]
15-Jan-14
$275.00
619007
[/td][td]Glover
[/td]
[TD="align: left"]Linda[/TD]
31-May-14
[/td][td]$404.11
619007
[/td][td]Glover
[/td]
[TD="align: left"]Linda[/TD]
11-Dec-14
$271.00
738725
[/td][td]Brunkenhoefer
[/td]
[TD="align: left"]Robert[/TD]
19-Dec-14
[/td][td]$400.00
38725
[/td][td]brunkenhoefer
[/td]
[TD="align: left"]Tracey[/TD]
19-Dec-14
$1,175.00
8887902
[/td][td]Spina
[/td]
[TD="align: left"]Anna[/TD]
20-Dec-14
[/td][td]-
[/td][/tr][tr][td]8887904
[/td][td]Spina
[/td]
[TD="align: left"]Domingos[/TD]
20-Dec-14
[/td][/tr]
[/TABLE]