Appending a numeric value if the value already exist in one column of excel

[shekhawat.arjun1307]

Hi Team,

I have an interesting problem where in I need to iterate through one column of excel and check if a particular value has already occurred in that column before if so I need to add _numeric value to it as shown in the image below -

Before updating -

After updating

[NIVED_NAMBIAR (NIVED N)]

Hi @shekhawat.arjun1307
I think this would work for you
Main.xaml (14.9 KB)

Regards,
Nived N

[shekhawat.arjun1307]

Hi @NIVED_NAMBIAR

It works for me, but I have some doubts, what each of these snips actually doing. Please bear with me as I have only worked in python have no experience in C#.