# Count repeat values in a column which are in a series

1. ## Count repeat values in a column which are in a series

In the attachment, you'll see there are a series of numbers. Some are repeated throughout the column. I'd like to set up a formula to find out how many times a certain number repeats. For example, "1a" repeats 4 times throughout the column, "2a" 9 times, etc... Tried a =COUNTIF(A2:A11,"1a") but just returns 0.
Much appreciated!

2. ## Re: Count repeat values in a column which are in a series

Hi,
How about that?

=SUM(--(ISNUMBER(SEARCH(" "&\$B\$1," "&\$A\$2:\$A\$11))))

3. ## Re: Count repeat values in a column which are in a series

Wrong formula

#### Thread Information

##### Users Browsing this Thread

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