Re: using a set of values



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]