Forum Discussion
Checking for criteria in whole column
Depends on in which form you'd like to have the result. As variant
with
=LET(
types, TOROW(SORT(UNIQUE(type))),
codes, SORT(UNIQUE(code)),
VSTACK(
HSTACK("",types),
HSTACK(codes,
MMULT(--(TRANSPOSE(TOROW(codes)=code)),
--(type=types))
)
)
)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!
