Forum Discussion
Count and tabulate number of unique values
Hi, My starting point will be a column of annual payment amounts in a month and what I would like to do is calculate the number of monthly amounts and return them in a table. I could /12 in a...
If you have Microsoft 365 or Office 2021, you can use dynamic array formulas - see the attached demo workbook.
- Many Thanks for this Hans.
I will give it a try later and see how I get along.
Best Wishes
James.
