Duplicate Values in a Collection

[TomMason]

Hi All, Just look for a quick win here.... I have an Excel sheet that I am using to populate a Collection. However, one of the Columns could contain a duplicate figure. I need to be able to look at the row of the collection and then look at the next one and identify whether this is a duplicate or not, and then input an Alpha character at the end. eg. 73098428 73098428 79098248 73168188 73250942 to 73098428A 73098428B 79098248C 73168188 73250942 Any ideas? Cheers Tom

[John__Carter]

Hi Tom - you need to keep track of the previous row. Capture the value of the current row in a data item called something like 'Previous Value', then when you've looped to the next row, compare it with the data item. Feel free to call me if that doesn't make sense.

[TomMason]

Thanks John..... Think I've stumbled upon it..... now my task is to add a random ALPHA Character to the end of it haha!