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.
SergeiBaklan
Jan 18, 2024Diamond Contributor
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.
- SergeiBaklanJan 18, 2024Diamond Contributor
You are welcome. Check both COUNTIF function - Microsoft Support and COUNTIFS function - Microsoft Support