Yes.

In C2:

=Countif($B$2:$B$500,B2)

And drag down

Or, create a summary table below or to the right of your data using advanced
filter, copy uniques to another location, then replace B2 with the location
of the top item of the summary table and drag down.

"Simone" wrote:

I have a spreadsheet with two columns like below.
I'd like to get a total of column B. For instance, Apple=4, Mango=2,
Pineapple=1/
Is this possible?

Orchard Fruit
A Apple
A Mango
B Apple
B Mango
C Pineapple
D Apple
E Apple