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

Discuss the spreadsheet application

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

Postby opog » Thu Aug 15, 2019 7:46 am

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 3 times
Last edited by opog on Fri Aug 16, 2019 3:32 am, edited 2 times in total.
OpenOffice 4.1.1 Windows 7
opog
 
Posts: 20
Joined: Sun Dec 29, 2013 11:26 am

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

Postby MrProgrammer » Thu Aug 15, 2019 10:16 pm

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 5 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.
Mr. Programmer
AOO 4.1.5 Build 9789 on MacOS 10.11.6.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
MrProgrammer
Moderator
 
Posts: 3785
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

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

Postby opog » Fri Aug 16, 2019 3:42 am

That's perfect, thanks!
OpenOffice 4.1.1 Windows 7
opog
 
Posts: 20
Joined: Sun Dec 29, 2013 11:26 am


Return to Calc

Who is online

Users browsing this forum: robleyd and 8 guests