Forum Discussion
jonewman123
Jan 18, 2024Copper 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 ...
- Jan 18, 2024Hi 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.
jonewman123
Jan 18, 2024Copper Contributor
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.
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.
SergeiBaklan
Jan 18, 2024MVP
You are welcome. Check both COUNTIF function - Microsoft Support and COUNTIFS function - Microsoft Support