How to count in each filter value in excel using uipath

[Raja.G (Mr.RPABot)]

Hi Guys,

I need to count in each filter value in excel using uipath

for example,
column1
aa
bb
cc
aa
column 2
gg
ff
gg
gg

Result:
aa count is 2
gg count is 3

Please anyone help this

Regards,
Raja G

[nadim.warsi]

Have a look at this thread

How to count the presence of duplicate values in the excel file and pass that count value in another excel file?

You need to understand the For Each loops. They are looking at each row, but you tell it which column to cycle through. row.Item(“Name”).ToString So just update the column name to that which you are looking to count duplicates in. As for the comparing that against another column for duplicates, you can just update the CheckDup variable in a similar way. I don’t know what you mean by the select query question. If you are looking to use the information output, e.g “Name: Sandeep Count: 3”, the…

[Raja.G (Mr.RPABot)]

Hi @nadim.warsi,

I want below output , please anyone help this

Regards,
Raja G

[nadim.warsi]

Let me try and create a sample for you.

[nadim.warsi]

here is a sample xaml which achieves the output.

it check only colmun 2 for duplicates.
Duplicate.xaml (41.3 KB)