I have a column with these items:

orange
kiwi
mango
orange
banana
mango
orange
tomato

I need a formula which can count and show the repeating items. In my caseit is orange and mango. I think it should be with conditional formating, but do not know the formula.

Thanks.