Show TOC

Function documentationMultiple Key Ranges Locate this document in the navigation structure

 

You can use the same EvDRE function call to support multiple key ranges on both the columns and rows simultaneously.

Note Note

If you want to include a blank line between retrieved values, you can leave a row or column blank without having to enter multiple ranges. See Including blank rows and columns.

End of the note.

Note Note

This feature can be activated assigning multiple ranges to the same EvRNG function.

End of the note.

The maximum number of parameters that can be assigned to any Excel functions (and EvRNG is no exception) is 30.

Activities

To define a multiple key range:

  1. From Interface for Excel, open the EvDRE report or input schedule you are building.

  2. In the ColKeyRange and/or RowKeyRange rows of the Key range parameter table, enter a range for the first heading set, a comma (,), then a range for the second heading set.

  3. Save the report or input schedule.