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...
If that's something like this
Power Query could work especially taking into account that's thousands of records. Query the range, unpivot all columns, group by with count on days as aggregation, filter on count 5.