Dear Excel Gurus,
Firstly apologies for the terrible title of this post, I didn't know how to quickly sumarise what I am trying to achieve. I have been working on this for hours and finally decided I needed help.
I have a list of numbers, typically around 20 (in lets say A3:A22). What is important to me is an average of the four entries next to each other, so A3:A6, A4:A7, A5:A7... etc... to A19:A22.
I'd like to find the maximum and minimum of the average subsets inside the overall range.
Ideally I'd like it so the total size of the range could change, normally within the limits of around 10 to 30.
Many Thanks in advance for any help
Thanks Brian
Firstly apologies for the terrible title of this post, I didn't know how to quickly sumarise what I am trying to achieve. I have been working on this for hours and finally decided I needed help.
I have a list of numbers, typically around 20 (in lets say A3:A22). What is important to me is an average of the four entries next to each other, so A3:A6, A4:A7, A5:A7... etc... to A19:A22.
I'd like to find the maximum and minimum of the average subsets inside the overall range.
Ideally I'd like it so the total size of the range could change, normally within the limits of around 10 to 30.
Many Thanks in advance for any help
Thanks Brian