SOLVED

COUNTIF with over 100 different values

Copper Contributor

COUNTIF with over 100 different values

Hi all,

I need to create a column to count how many times an entry has been made (attached sample).  I have highlighted the duplicates for ease of visibility.

Essentially, column 2 needs to count how many times the entry in column 1 appears such that it gives:

4580534151455    2

4580534189441    3

4580534189472    6

etc

 CODE COUNT 4580534151455 4580534151455 4580534151462 4580534151462 4580534151479 4580534151585 4580534151615 4580534151622 4580534152049 4580534152155 4580534189328 4580534189410 4580534189427 4580534189434 4580534189441 4580534189441 4580534189441 4580534189458 4580534189458 4580534189458
4 Replies

Re: COUNTIF with over 100 different values

Did you try

``=COUNTIF(CodeRange, code)``

Re: COUNTIF with over 100 different values

Let's say that the data in the first column are in A2:A200.

In B2:

=COUNTIF(A2:A200, A2:A200)

This will spill to B200.

best response confirmed by jonewman123 (Copper Contributor)
Solution

Re: COUNTIF with over 100 different values

Hi Sergei,

Thanks for the quick reply! I haven't tried that - COUNTIF is quite new to me so I'm not sure what the entire formula should be.

Re: COUNTIF with over 100 different values

1 best response

Accepted Solutions
best response confirmed by jonewman123 (Copper Contributor)
Solution

Re: COUNTIF with over 100 different values

Hi Sergei,

Thanks for the quick reply! I haven't tried that - COUNTIF is quite new to me so I'm not sure what the entire formula should be.