Have very basic understanding of constructing OpenCalc formulas and would very much appreciate some help. Have successfully used Formulas for AVERAGEIF, COUNTIF, etc, but need two examples to work from to gain MINIF and MAXIF. Any help you provide will potentially assist in seeing more of my State's newspapers digitised online.
I'm trying to find the Minimum and Maximum values in a column on a separate worksheet where a text value is present in another column's corresponding cell (on that same worksheet) and is greater than 0. For instance I have one column with the electoral regions of Victoria (Australia) (i.e. "Eastern Metropolitan", "Eastern Victoria", "Southern Metropolitan" etc.). The data I'm trying to extract from is in individual columns depending on what Newspaper Directory it appeared in.
Looking at Help there appears to only be a MIN function not a MINIF or MINIFS function, as is possible with AVERAGEIFS, COUNTIFS, etc or is available in Excel. This means I will presumably have to construct an IF statement that incorporates MIN to achieve my desired outcome. From memory I read somewhere I have to hold CTRL, SHIFT and another key before activating the formula to convert to a special kind of formula. I've succesfully constructed a formula that returns the MIN or MAX in the entire cell, but not specifically the MIN or MAX for that electoral region (as defined by entry in column D).
The cell range with the electoral regions specified is "Sheet.1.D2:Sheet1.D1401". An electoral region listed in the D range is "Eastern Victoria". One of the columns to extract the MIN or MAX value from is "Sheet1.AC2:Sheet1.AC1401". I want the Minimum value greater than 0, this will then return me the result of the MINIMUM "entered" pagination for that corresponding directory.
Any help you can provide in solving this will be appreciated by myself and users of digitised newspapers. Thanks for any help you provide.
[Solved] MINIF and MAXIF Formulas
-
- Posts: 1
- Joined: Fri May 07, 2021 3:39 pm
[Solved] MINIF and MAXIF Formulas
Last edited by MrProgrammer on Fri May 14, 2021 5:51 pm, edited 1 time in total.
Reason: Tagged ✓ [Solved]
Reason: Tagged ✓ [Solved]
OpenOffice 4.1 on Windows 10
Re: MIN and MAX IF Formulas for Newspaper Pagination
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
- MrProgrammer
- Moderator
- Posts: 4903
- Joined: Fri Jun 04, 2010 7:57 pm
- Location: Wisconsin, USA
Re: MIN and MAX IF Formulas for Newspaper Pagination
Hi, and welcome to the forum.
[Tutorial] Ten concepts that every Calc user should know
For assistance with solutions for OpenOffice attach a document demonstrating the situation (remove confidential information then use Post Reply, not Quick Reply, and don't attach a picture instead of the document itself). Specify the cell which contains the value to match in column D and specify the cell which is to display this minimum value.~~puzzled~~ wrote:I'm trying to find the Minimum and Maximum values in a column on a separate worksheet where a text value is present in another column's corresponding cell (on that same worksheet) and is greater than 0.
[Tutorial] Ten concepts that every Calc user should know
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).