MINA function. Get the minimum value, including spaces and boolean values.(Microsoft Excel)
The MINA function is a companion to the MIN function.
The difference is that the MIN function only includes numeric values, while non-numeric values are included under certain rules.
How it works
=MINA(value1 to 255)
Name | Omission | Description |
---|---|---|
value1 to 255 | Required argument. | Specify the values of the target. |
Non-numeric treatment.
value | Result |
---|---|
String and whitespace string. | 0 |
Blank cell. | Ignore |
TRUE | 1 |
FALSE | 0 |
Demonstrate
This is an example where blank cells are included. Blank spaces are ignored by both the MIN and MINA functions.
However, the result of a formula or function, or a blank string, is treated as 0.
The MIN function ignores strings, and the MINA function treats strings as 0.
The MIN function ignores Boolean values, though, MINA function treats TRUE as 1 and FALSE as 0.
Using the MINA function on a Boolean-only column yields a result of 0 if FALSE is present in one of the columns.
If either the MIN or MINA function contains an error, the result will be an error.
Specify other than cell range.
It is also possible to return a range of cells as the result of a function argument. In this case, the minimum value is taken from the result of the function.
List of functions that result in a range of cells.
Function | Category | Description |
---|---|---|
TEXTSPLIT | Text | Divides text into cells based on a specified character. |
XLOOKUP | Lookup & Reference | Get data matching the search value. |
FILTER | Lookup & Reference | Get a list of data that matches the condition. |
UNIQUE | Lookup & Reference | Delete duplicate data in a specified cell range. |
SEQUENCE | Lookup & Reference | Create sequential numbers in multiple cells. |
SORT | Lookup & Reference | Sort a range of cells by a specified column. |
SORTBY | Lookup & Reference | Sort a cell range by specifying multiple reference columns. |
DROP | Lookup & Reference | elete a specified number of rows and columns from a specified cell range. |
TAKE | Lookup & Reference | Obtains a specified number of rows and columns from a specified cell range. |
TOCOL | Lookup & Reference | Arranges a specified range of cells in a single column. |
TOROW | Lookup & Reference | Sort a specified range of cells into a single column. |
EXPAND | Lookup & Reference | Extended specified cell range. |
CHOOSEROWS | Lookup & Reference | Get the row at the specified position from the specified cell range. |
CHOOSECOLS | Lookup & Reference | Get the column at the specified position from the specified cell range. |
WRAPROWS | Lookup & Reference | Sort a range of cells in a single column or row by a specified number of rows. |
WRAPCOLS | Lookup & Reference | Sort a range of cells in a column or row by a specified number of columns. |
VSTACK | Lookup & Reference | Merge multiple cell ranges in row direction. |
HSTACK | Lookup & Reference | Merge multiple cell ranges in column direction. |
TRANSPOSE | Lookup & Reference | Create a cell range with the rows and columns of the specified cell range swapped. |
It can also be specified as an array.
=MINA({10,1,2,-5})
Multiple values can also be specified simply by separating them with commas.
=MINA(10,1,2,-5)
Spill
Spill when using the BYROW or BYCOL function.
=BYROW(A1:C3,LAMBDA(r,MINA(r)))
=BYCOL(A1:C3,LAMBDA(c,MINA(c)))
---
Links
Maximum/minimum values for multiple values or cell ranges.
Function | Importance | Description |
---|---|---|
MIN | High | Get the smallest number. |
MAX | High | Get the largest number. |
MINA | Middle | Get the minimum value, including spaces and boolean values. |
MAXA | Middle | Get the maximum value, including spaces and boolean values. |
MINIFS | High | Get the minimum value in a cell that matches multiple criteria. |
MAXIFS | High | Get the maximum value in a cell that matches multiple criteria. |
Discussion
New Comments
No comments yet. Be the first one!