Forum Discussion
Loop Through Worksheets and Counts Populated Rows
I want to create a macro that I can run each week. I have a workbook and on the first worksheet I want to count how many populated rows there are on the other worksheets. So in this example I want a...
Some of the sheets contained spaces after the names in column A. I've went through the workbook and removed those.
I've also include two possible solutions.
The second option uses REDUCE and calls the Lambda 'Milestone':
=REDUCE(header,manager,Milestone)
Thanks for this - super useful. I probably need to spend a bit of time understand the formulas and playing around with them, as I can't get them to work at my end. I must be doing something wrong. I'm not sure I understand the 'REDUCE' solution. Thanks again