How to Sum up multiple similar entries of a specific column in a New column

Occasional Visitor

Hi Community,


I have an Excel sheet that has multiple similar entries under a specific column and I am trying to count the number of occurrences of my unique values in a new column i.e. on Column C. I would appreciate support in this regard. Enclosed the excel for your reference and I need the data in column C.






1 Reply

@dhruba005 solution attached