Mynda, My apologies for not seeing this question sooner. What I should have said is that I was using VBA to apply the formula to entire colum...
Mynda, Thank you for the direction, that helps very much. Next step is to see if I can model this in VBA but in the mean time, this answers the ma...
Mynda, Thank you for taking some time to look at this issue. I have attached the sample data as requested and added some additional rows to get a ...
Velouria, Simple yet elegant and if my knee could bend backwards, I would kick myself in the shorts for not exploring the other COUNT functions. O...
Euan, Without seeing the actual structure of your data, I made a quick slicer example loosely based on a table of data containing Employee, Te...