Celin.DATA

Display named data on a sheet using the Spill functionality (see below).

Example

Display full results of ab data.

=Celin.DATA("ab",-1,-1)

FULL DATA

Format first 10 rows of ab results (display rows from 0 - 9).

(see format syntax below)

=Celin.DATA("ab",0,10,"{1} ({0})")

FORMAT DATA

Reference

Dynamic array formulas and spilled array behaviour

Format Syntax


Copyright © 2020 Finnur Bragason.