Wants too count the duplicate values in excel file

[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.