List Problem - Index List

Learn
, ,
1

Hi guys,

image
image416×515 7.42 KB

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?

Thanks

2

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

3

Hello @Gabriel2

Used a little LinQ here to achieve the desired result

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