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

[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.

[MrProgrammer]

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 18 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.

[opog]

That's perfect, thanks!