Group by and Count is Microsoft Excel

Sometimes, we may need to group data in a Column in Excel and take the distinct values and the count of their occurrence.

Refer below data.

In the above data, if we need distinct values and the number of occurrences, follow the below steps:

1. First get the distinct values to another column. Refer detailed instructions here.
2. Then, use COUNTIF function to get the count of occurrence.

COUNTIF usage:

COUNTIF takes two parameters, 1st is a range where data is present multiple times, and 2nd is the value whose count needs to be found.

Syntax:

=COUNTIF(A1:A12, B1)

For more Tips & Tricks in Excel, Click Here.