List Problem - Index List

Hi guys,

So I have this tabel in excel

I need to take out the values from the table into list and show it in a message box.

After I need to go through the list and show where the duplicate values are in the tabel with a message box which will say: ex: " Number 9 from the pozition C2 was first seen at pozition B2"

I think I must use an index variable to find the cells and show the pozitions but I can’t find a way

Any thoughts?


To detect if a value had already been read in another cell, are you reading from left to right, or from top to bottom?

Hello @Gabriel2

Used a little LinQ here to achieve the desired result

Check the workflow for better understanding and let me know about it (8.2 KB)