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...
JeffFowlerjfowler72 , say if the data is in columns A~E , then the required formula could be
{=SUM((A:A=B:B)*(A:A=C:C)*(A:A=D:D)*(A:A=E:E)*NOT(A:A=""))}
See attached example file i created with dummy data and verify if your problem was understood correctly or not.
If not, then suggest you to share a sample data, highlighting the valid cases to be counted.