Hi, I have a helper cell that I need to get the current month. For example
Data is on one row , columns are month names.
Jan, Feb, Mar, Apr helper cell
10, 20, 26, 12 =Current month, so this would display 10
14, 27, 21, 82 =Current month, so this would display 14
66, 23, 25, 22 =Current month, so this would display 66
76, 25, 22, 11 =Current month, so this would display 76
10, 20, 76, 12 =Current month, so this would display 10
98, 20, 25, 18 =Current month, so this would display 98
So two questions here
If I average the month range to get one value, in the new month how do I move the average of 4 months to the new month, but drop the old month
Second question - How do i get the value of the last month at any given time? even when new months are added the cell needs to change to the current month
Data is on one row , columns are month names.
Jan, Feb, Mar, Apr helper cell
10, 20, 26, 12 =Current month, so this would display 10
14, 27, 21, 82 =Current month, so this would display 14
66, 23, 25, 22 =Current month, so this would display 66
76, 25, 22, 11 =Current month, so this would display 76
10, 20, 76, 12 =Current month, so this would display 10
98, 20, 25, 18 =Current month, so this would display 98
So two questions here
If I average the month range to get one value, in the new month how do I move the average of 4 months to the new month, but drop the old month
Second question - How do i get the value of the last month at any given time? even when new months are added the cell needs to change to the current month