This video demonstrates how to use Excel's new LET function to create a multi-cell report using a single-cell formula. I saw this used on the excellent ExcelIsFun Channel - https://www.youtube.com/channel/UCkndrGoNpUDV-uia6a9jwVg

The video features the following functions:
LET
UNIQUE
COUNTIF
SUMIF
CHOOSE

02/07/2020. At the time of writing the LET function is only available if you are signed up to Office Insiders.
https://support.microsoft.com/en-us/office/let-function-34842dd8-b92b-4d3f-b325-b8b8f9908999#:~:text=The%20LET%20function%20assigns%20names,defining%20names%20inside%20a%20formula.&text=Improved%20Performance%20If%20you%20write,calculated%20that%20result%20multiple%20times.
------------------------