Forum Discussion
Re: How to dynamically total/count across multiple columns of a dynamic array
Yes indeed many options!
I’m really using this as an excuse to get better with dynamic arrays so if I can learn to build this as a one formula table, that would be great.
I’d rather avoid pivot tables as I find them inflexible if you’re trying to use the output for another process.
The output for this will eventually populate a csv for a journal import.
Great responses - I’ll spend some time digesting and learning some of the functions I haven’t used yet.
I’m really using this as an excuse to get better with dynamic arrays so if I can learn to build this as a one formula table, that would be great.
I’d rather avoid pivot tables as I find them inflexible if you’re trying to use the output for another process.
The output for this will eventually populate a csv for a journal import.
Great responses - I’ll spend some time digesting and learning some of the functions I haven’t used yet.
1 Reply
IMHO, spill, PivotTable in tabular form and structured table returned by Power Query will give exactly the same csv output. From that point of view no difference.
