Re: using a set of values

From: anders alm <anders alm home se>
To: gnumeric-list gnome org
Subject: Re: using a set of values
Date: Sat, 27 Jan 2001 15:10:26 +0100

The simplest case would be
    =if(set='a',a1:a25,b1:b25)

a more complex solution would be (convert set to an integer)
    =offset(a1:a25,0,set,25,1)


thanks! the offset function did exactly what i wanted.

References:
- using a set of values
  - From: anders alm
- Re: using a set of values
  - From: Jody Goldberg

[Date Prev][Date Next] [Thread Prev][Thread Next] [Thread Index] [Date Index] [Author Index]