https://community.blueprism.com/t5/Product-Forum/Duplicate-Values-in-a-Collection/m-p/66463#M19068 Thanks John..... Think I've stumbled upon it..... now my task is to add a random ALPHA Character to the end of it haha! Wed, 13 Dec 2017 20:38:00 GMT TomMason 2017-12-13T20:38:00Z https://community.blueprism.com/t5/Product-Forum/Duplicate-Values-in-a-Collection/m-p/66461#M19066 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 Wed, 13 Dec 2017 16:09:00 GMT https://community.blueprism.com/t5/Product-Forum/Duplicate-Values-in-a-Collection/m-p/66461#M19066 TomMason 2017-12-13T16:09:00Z https://community.blueprism.com/t5/Product-Forum/Duplicate-Values-in-a-Collection/m-p/66462#M19067 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. Wed, 13 Dec 2017 18:20:00 GMT https://community.blueprism.com/t5/Product-Forum/Duplicate-Values-in-a-Collection/m-p/66462#M19067 John__Carter 2017-12-13T18:20:00Z https://community.blueprism.com/t5/Product-Forum/Duplicate-Values-in-a-Collection/m-p/66463#M19068 Thanks John..... Think I've stumbled upon it..... now my task is to add a random ALPHA Character to the end of it haha! Wed, 13 Dec 2017 20:38:00 GMT https://community.blueprism.com/t5/Product-Forum/Duplicate-Values-in-a-Collection/m-p/66463#M19068 TomMason 2017-12-13T20:38:00Z