How to count the number of duplicates?

Question

excel

We have an array of X text entries that contains duplicates. For example
dough
dough
meat
dough
juice
meat
beer
meat
dough
How to count the number of duplicates. Each one separately.
Those. you need to get an answer of the form:
meat - 3
dough - 4
Any ideas? Thanks in advance

Answer 1

Everything turned out to be simple. We have a column with data, copy it to a new column, in which we get rid of duplicates (within the column). In the third column, we count according to the formula (screen). Thanks to all!

Answer 2

as one of the options:
next to each line, put 1
insert menu - a pivot table,
select the name of the products and the quantity of each line
, indicate where to insert a new table (current sheet or new)
on the right in the menu, select the name of the columns