[Solved] How to MIN or MAX number of values backwards?
[Solved] How to MIN or MAX number of values backwards?
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.
- Attachments
-
- work weeks 2.ods
- (15.97 KiB) Downloaded 69 times
Last edited by opog on Fri Aug 16, 2019 3:32 am, edited 2 times in total.
OpenOffice 4.1.1 Windows 7
- MrProgrammer
- Moderator
- Posts: 4908
- Joined: Fri Jun 04, 2010 7:57 pm
- Location: Wisconsin, USA
Re: How to MIN or MAX specific number of values backwards?
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. 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 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.
Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).
Re: [Solved] How to MIN or MAX number of values backwards?
That's perfect, thanks!
OpenOffice 4.1.1 Windows 7