Page 1 of 1

[Solved] How to MIN or MAX number of values backwards?

PostPosted: Thu Aug 15, 2019 7:46 am
by opog
One more question if I may, How would I find the Min and also the Max for 4 weeks back using a similar calculation (instead of averaging)? This would be in the M and N columns.

Re: How to MIN or MAX specific number of values backwards?

PostPosted: Thu Aug 15, 2019 10:16 pm
by MrProgrammer
opog wrote:How would I find the Min and also the Max for 4 weeks back using a similar calculation (instead of averaging)? This would be in the M and N columns.
Your previous topic (about AVERAGE) was solved. The SUMPRODUCT technique used for that topic does not apply to MIN or MAX, hence you need a new topic. Using a different approach with four columns to hold intermediate values makes finding all of MIN, MAX, and AVERAGE easy.
201908151422.ods
(22.69 KiB) Downloaded 14 times

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.

Re: [Solved] How to MIN or MAX number of values backwards?

PostPosted: Fri Aug 16, 2019 3:42 am
by opog
That's perfect, thanks!