MEDIAN function. Get median.(Microsoft Excel)
The median is the value of the middle rank when the data are arranged.
If the number of subjects is even, for example, the median of 10 subjects is the average of the 5th and 6th place values.
If the number of subjects is odd, for example, the median value for 9 subjects is the median value for the 5th place.
Contents
How it works
=MEDIAN(number1 to 255)
| Name | Omission | Specify |
|---|---|---|
| number1 to 255 | Required | Specify a list of values or a range of cells from which to obtain the median. |
Example Results
In most cases, a cell range is specified as an argument.
Numerical values can also be specified as comma-separated values.
It can also be specified as an array.
It is also possible to return a range of cells as the result of a function argument. In this case, the median 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. |
Spill
Spill when using the BYROW or BYCOL function.
=BYROW(A1:C3,LAMBDA(r,MEDIAN(r)))
=BYCOL(A1:C3,LAMBDA(c,MEDIAN(c)))
---