Forum Discussion
In Excel Extracting Commonality Across Mutiple Columns and Thousands of Cells of Data
I have 5 daily columns, each with the email addresses of thousands of people who completed a task on each day. I am trying to find a way to display how many people across the five columns/days comple...
You will probably need something like =COUNTIF or =COUNTIFS.
If you could provide an example of your spreadsheet or a screenshot (make sure you blur out or modify the email address for confidentiality purposes) it would be easier to help you.