Hi all,.
Could someone suggest what I need in my formula to keep a rolling work out over the last 6 months when I add a new month column in my sheet?
I have a formula in P13 looking at the 2nd lowest number in a range of 6 months,
=SMALL($J$13:$O$13, 2)
but when I add a new month in column P the formula doesn't change to K13:P13. (i tried without the $ signs too).
Anyone able to let me know what I need to add into my formula? Many Thanks.
Could someone suggest what I need in my formula to keep a rolling work out over the last 6 months when I add a new month column in my sheet?
I have a formula in P13 looking at the 2nd lowest number in a range of 6 months,
=SMALL($J$13:$O$13, 2)
but when I add a new month in column P the formula doesn't change to K13:P13. (i tried without the $ signs too).
Anyone able to let me know what I need to add into my formula? Many Thanks.