Wants too count the duplicate values in excel file

[Shubham4323]

Wants too count the duplicate values in excel file, as for example
alphabets
a
b
a
b
c
d
d
output
alphabets values
a 2
b 2
c 1
d 2

[Manjuts90]

@Shubham4323 Please check below link.

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…

[HareeshMR (Hareesh Madasi)]

Just make a pivot table with the data you have and drag the alphabet column to the measures property @Shubham4323

[samir (Samir Mohite)]

Hi @Shubham4323,

How to group the data

yeah, @mashy2 you’re right, this happened because I’ve grouped data according to Name only, So to get the correct output I’d done one change in Linq query as shown in below shot: [updated] here you can see now I’ve grouped according to “Name” as well as “Number”, it gives correct output. here’s the updated workflow, Unique&Count.xaml (10.5 KB) for your better understanding.

[Marcela_Lugo (Marce)]

This works for me! thank you!!

[ahmadLH]

and for me!