Forum Discussion
Checking for criteria in whole column
Agreed, there are better layouts. To be told in triplicate that there are three occurrences would seem to be excessive. Mind you, your skills are soon to be overtaken by
= PIVOTBY(uniqueCode, type, type, COUNTA, ,0, ,0)
So far I don't use these two aggregation functions due to compatibly. Played a bit and keep for the future.
I see your point.
Perhaps it depends on whether you are writing for the past, present or future!
- Most readers do not like change and will be most comfortable with the past
- The present is the most useful
- The future stretches the imagination
The new functions provide amazing flexibility for pivot-table-like output
Re: Is now the time to abandon the concept of relative referencing? - Microsoft Community Hub
but also can figure in the core calculation task. For me, practice is going to be necessary!
Major part of what I'm doing I share with other people. Major part of such people are on Current channel. On this resource I assume the same, if only it's not clear from the content that the person is on legacy Excel, actually or mentally. Or, in opposite, on Beta.
Thus the assumption is people are in present. Agree, that's great if someone tries to prepare them for the future.
As for pivoting I still prefer data model based PivotTables. Lot of flexibility, especially with complex models, easier to slice & dice, more flexible formatting. Main cons is Refresh.
For the relatively simple models new functions could be more preferrable. When they are in production.