Great video. I knew the functions already, but it was very nice to see some real world examples. And the arraytotext is not a function I have used yet. So, that was fun to see.
Love your videos. Always short and sweet, and a sample file when needed! Single cell solution to Exercise 3: =LET( Hdr,HSTACK("Item","Amount","Invoices"), Itms,SORT(UNIQUE(Table1[Item])), Amts, SUMIFS(Table1[Amount],Table1[Item],Itms), Invc, BYROW(Itms, LAMBDA(rw,TEXTJOIN(", ",TRUE,FILTER(Table1[Invoice],Table1[Item]=rw)))), VSTACK(Hdr,HSTACK(Itms, Amts,Invc)))
Very useful, especially the array to text to give a list rather than the results in separate cells, thanks Paul
Great video. I knew the functions already, but it was very nice to see some real world examples. And the arraytotext is not a function I have used yet. So, that was fun to see.
Love your videos. Always short and sweet, and a sample file when needed!
Single cell solution to Exercise 3:
=LET(
Hdr,HSTACK("Item","Amount","Invoices"),
Itms,SORT(UNIQUE(Table1[Item])),
Amts, SUMIFS(Table1[Amount],Table1[Item],Itms),
Invc, BYROW(Itms, LAMBDA(rw,TEXTJOIN(", ",TRUE,FILTER(Table1[Invoice],Table1[Item]=rw)))),
VSTACK(Hdr,HSTACK(Itms, Amts,Invc)))
Thank you!
How can I change a formula in a cell, without being able to see the cell?