This video describes Excel's new SEQUENCE function and puts it to work to find the average sales across 4 years for a particular branch and particular month. The SEQUENCE function has to team up with MATCH and INDEX to get its task done.
------------------------