Wants too count the duplicate values in excel file

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

@Shubham4323 Please check below link.

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

Hi @Shubham4323,

1 Like