Thanks Ali...is there a way to do it without helper columns too? If not no problem.Create two new columns - Emp A Count and Emp B Count.
Copy this into D2 and drag copy across and down:
For Emp A: =MAX(Table1[Emp A Count])
For Emp B: =MAX(Table1[Emp B Count])
Formula without helper columnsThanks Ali...is there a way to do it without helper columns too? If not no problem.
Hi Peter, continuing on this fine thought of moving towards PQ/PP, I would say that the-need-for-speed is always of essence.@AliGW
Thought for discussion. Now that we have Power Query and Power Pivot, the workbooks that were forever on the verge of collapse under the weight of their data (Calculation Manual) should have migrated away from formula-based manipulation. This means that, for other classes of workbook (model building in particular), optimisation for speed is no longer of primary importance?
This is simply a thought and I would not necessarily claim it to be true.