MAXCOLUMN |
Description
Returns the maximum value from a
column.
Syntax
MAXCOLUMN(value,
column1,
column2, ...)
Value is
the column from which you want to find the maximum value. Value
can
be a text, number, or date column.
Column1, column2,... are up to
30 optional columns that define the aggregation context. The
maximum value is returned for each unique combination
of the group_by columns.
When the result of MAXCOLUMN
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 MAXCOLUMN that
corresponds to its particular aggregate values.
When the value column is text, MAXCOLUMN 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 maximum value in the entire column is returned.
Example
In
the following we see
how MAXCOLUMN works with a numeric column and a single aggregation
column. The calculated value is entered in each row.
Sample
Data
Unit
Sales
|
Store
|
=MAXCOLUMN(Unit
Sales,Store) |
NUMBER
|
TEXT
|
NUMBER
|
157
|
West |
157
|
127
|
Central
|
127
|
102
|
Central
|
127
|
353
|
North
|
353
|
104
|
East
|
105
|
105
|
East
|
105 |
|
 User Comments |
 |
|
| Click Here to be the first to post a comment. |
Support Home
| 
Glossary | 
Contact Us 
