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 24580534189441 34580534189472 6 etc Is this possible please? CODECOUNT4580534151455 4580534151455 4580534151462 4580534151462 4580534151479 4580534151585 4580534151615 4580534151622 4580534152049 4580534152155 4580534189328 4580534189410 4580534189427 4580534189434 4580534189441 4580534189441 4580534189441 4580534189458 4580534189458 4580534189458

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.

Copper Contributor

Jan 18, 2024

Solved

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

Is this possible please?

jonewman123
Jan 18, 2024
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.