Page tree
Skip to end of metadata
Go to start of metadata

Syntax

GROUPSELECT(<any>;<any>;<any>)

Description

Create columns with selected values using a key constant from a specified grouped column in the workbook. 

Select a column from a worksheet and write in a constant from that column. Next, select the value column for which to compare the constant from the original column. The column being selected isn't allowed to contain different values for the key constant. If there are different values for a key constant, an error results. 

This is a excellent tool to create columns for use in a pivot table

This is an aggregate function.

Example

Original Data:

Department

Year

Dollar

Department 1201010
Department 1201020
Department 1201110

Department 2

201110
Department 2201210
Department 1201330
Department 1201330
Department 2201335

Create a new worksheet:

GROUPBY(#RawData!Department)
GROUPSELECT(#RawData!Year;2010;#RawData!Dollar)
GROUPSELECT(#RawData!Year;2011;#RawData!Dollar)
GROUPSELECT(#RawData!Year;2012;#RawData!Dollar)
GROUPSELECT(#RawData!Year;2013;#RawData!Dollar)
DepartmentDollar_in_2010Dollar_in_2011Dollar_in_2012Dollar_in_2013
Department 1<error>10<empty>30
Department 2
101035



  • No labels