Test within a loop

Discussion created by Raymond on May 6, 2018
Latest reply on May 9, 2018 by Raymond

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.