Masterexcel1 and excel2 are the need to add data in masterexcel1 and if accoutn is repeted need to increase the coutn

Hi All,

I do have excel1 and need to add in masterExcel1, if any account in masterExcel2 is repeated its need to increase the count.You can see below

this today file excel1
image

we need to add in masterexcel1

image

so today i run the file and while adding rows in the masterexcel1 if account is repeted need to increase the count

image

what the logic I need to use here and how to get the count value base one account number

Thank you

There are lots of posts here about these kind of things, and the forum search works great.

hi @vineelag

i have shared the Zip file which i have done sample

uipathtask.zip (8.9 KB)

hope this helps

Happy automation

1 Like

Hi @Shiva_Nikhil,

thank you, will check