Number of times same text is repeated

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

2. Re: Number of times same text is repeated

have a look at the Countif() function

3. Re: Number of times same text is repeated

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

4. Re: Number of times same text is repeated

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 *

5. Re: Number of times same text is repeated

Huge thanks guys. It's almost unfair how simple that was. I can't believe I couldn't come up with it.

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1