Not sure if possible. Thanks to previous help by the Experts was able to have a Macro that sorted duplicates, but report changed and I need to have this question tweaked. Report now pulls in the Client# and each part for the record. So if each record has 3 part#'s on it then it could have 3 results and then when worked on again the client number's 14th digit changes and will have a repeat of the parts with the new results if any changes occurred.
I need to be able to count based on the most current record, and looking to remove any previous record but without removing any entries on the current record. If that makes sense.
I'm attaching an example of the report. Everything would be based on Column E and can run all macro's before and after for the rest of the information, just this part I need to have for the calculations.
Client Record# Purchase code (example with generic part#) Date of Purchase
13013178910100 i3207 01/01/2013
13013178910100 i3206 01/01/2013
13013178910100 i3205 01/01/2013
13013178910101 i3207 01/08/2013
13013178910101 i3206 01/08/2013
13013178910101 i3205 01/08/2013
13013178910102 i3207 01/15/2013
13013178910102 i3206 01/15/2013
13013178910102 i3205 01/15/2013
so would need to keep all lines ending with 02 and delete the other rows of the same record.