I have information in twelve columns (months) on multiple rows.
Some months there are no data entered.
I want to make a formula that calculates the average of the three most recent values (new values always entered to the right of the most recent) which means that sometimes it's the 3 most right cells and on other months it takes many more cells in order to find three values to make an average from. If there aren't three values to be found it can average the values found the last 12 months.
Thanks in advance
Some months there are no data entered.
I want to make a formula that calculates the average of the three most recent values (new values always entered to the right of the most recent) which means that sometimes it's the 3 most right cells and on other months it takes many more cells in order to find three values to make an average from. If there aren't three values to be found it can average the values found the last 12 months.
Thanks in advance