Hi,
I am looking for one formula which gives me Average of given range according to YTD level.
If my range is till Dec and My YTD is May then it should give me average till may and as I change my YTD to june next month it change accordingly.
Sheet attached for further reference.
Thanks
I am looking for one formula which gives me Average of given range according to YTD level.
If my range is till Dec and My YTD is May then it should give me average till may and as I change my YTD to june next month it change accordingly.
Sheet attached for further reference.
Thanks