Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

Syntax

SELECT(<any>;<any>;<any>)

Description

Create columns with selected values using a key constant from a specified 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. If the constant or original column is set as null, the cells all return empty. If the value column is set as null, the column doesn't calculate.

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

Example

Original data:

DepartmentYearDollar
Department 1201010
Department 1201020
Department 1201110

Department 2

201110
Department 2201210

Create a new worksheet:

  1. Copy the Department column.
  2. Use the SELECT function:
    1. For column to select, use the Year column.
    2. Write in the specific year as the constant. 
    3. Select the Dollar column as the value if equal.
  3. Use the SELECT function again, selecting a different constant.
COPY(#RawData!Department)
SELECT(#RawData!Year;2010;#RawData!Dollar)
SELECT(#RawData!Year;2011;#RawData!Dollar)
DepartmentDollar_in_2010Dollar_in_2011
Department 110<empty>
Department 120<empty>
Department 1<empty>10
Department 2<empty>10
Department 2<empty><empty>



  • No labels