MINCOLUMN |
Description
Returns the minimum value from a
column.
Syntax
MINCOLUMN(value,
column1,
column2, ...)
Value is
the column from which you want to find the minimum value. Value
can
be a text, number, or date column.
Column1, column2,... are up to
30 optional columns that define the aggregation context. The
minimum value is returned for each unique combination
of the group_by columns.
When the result of MINCOLUMN
is
given as the final value for a new column in a transform worksheet, as
in the example below, each row will get the value of MINCOLUMN that
corresponds to its particular aggregate values.
When the value column is text, MINCOLUMN finds the text with the
highest lexical value. See CLEAN for
a listing of the lexical values of the character set.
If no group_by columns are
provided, the minimum value in the entire column is returned.
Example
In
the following we see
how MINCOLUMN works with a numeric column and a single aggregation
column. The calculated value is entered in each row.
Sample
Data
Unit
Sales
|
Store
|
=MINCOLUMN(Unit
Sales,Store) |
NUMBER
|
TEXT
|
NUMBER
|
157
|
West |
157
|
127
|
Central
|
102
|
102
|
Central
|
102
|
353
|
North
|
353
|
104
|
East
|
104
|
105
|
East
|
104 |
|
 User Comments |
 |
|
| Click Here to be the first to post a comment. |
Support Home
| 
Glossary | 
Contact Us 
