It's really hard to explain.
What I have now:
A B
1 Apple
2 Apple
3 Apple
4 Lemon
5 Lemon
6 Peach
7 Peach
8 Peach
9 Peach
What I want to have:
A B
1 Apple 3
2 Apple 3
3 Apple 3
4 Lemon 2
5 Lemon 2
6 Peach 4
7 Peach 4
8 Peach 4
9 Peach 4
Where B column returns number of instances text from respective A column cell appears in A column.
Thanks in advance
Bookmarks