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.
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]