Excel Formula to Remove Duplicates

[@PaulEBrownbill]

Very useful, especially the array to text to give a list rather than the results in separate cells, thanks Paul

[@liquidapathy82]

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.

[@jerrydellasala7643]

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)))

[@ldallakyan]

Thank you!

[@jamerfunk]

How can I change a formula in a cell, without being able to see the cell?