Number of times same text is repeated

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

have a look at the Countif() function

=b1&" "&countif(b:b,b1)

Try this formula in C2 and drag it down..

Formula:

Please Login or Register  to view this content.

then in D2

Formula:

Please Login or Register  to view this content.

Copy down..
after that you can copy the result column and then paste values in the B columns..

Don't forget to click *