I create a list based on numbers and transaction dates and has been sorted by numbers (descending) and trans dates (ascending). I need to have the script to test the number and should there be a second similar number it is to be omitted from the original foundset.
The New found set will comprise a list of Numbers with the most recent transaction.
I have included an excel sheet to help explain.
Within the loop I need to test for the number and in the next record should the number reoccur then that record is to be omitted and so on.
I have tried all sorts of things without an success.
Any Input and guidance would be apreciated.