I have been following Leila Gharanis’ You Tube video on OFFSET Function for Dynamic Calculations.
At 10 ins 46 secs into the video, Leila explains how to obtain an average using a drop-down list to select a month for data held in columns.
Is it possible to do the same data held in rows? I have tried several different formulas but to no avail.
What I am trying to achieve on the attached example is;
If I select the month of Jan-20, I get the average for Jan-20, Feb-20, Mar-20 & Apr-20, if I select the month of Feb-20, I get the average for Feb-20, Mar-20, Apr-20 & May-20 and soon.
Any help on this would be greatly appreciated.
Bookmarks