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.
Bookmarks