Hello everyone,

I am a newbie to excel. I wanted to know how to extract duplicate from the range of cells and get its count? I was able to achieve this in pivot table, but I wanted to know if there is a simple and proper way of doing it (using functions if required)?

Example:
Input:

Animals
Tiger
Tiger
Tiger
Tiger
Cow
Cow
Cow
Goat
Goat
Goat

Expected output:

Tiger=4
Cow=3
Goat=3

Many thanks in Advance.