Re: Formel that return a range is needed

[d98rolb <roland bengtsson gmail com>]

Thanks for your tip!


Oliver Burnett-Hall wrote:
> d98rolb wrote:
> >  need a function or formel in Gnumeric that return a range with cells
> > containing some data.
> >
> > For example
> > The range K3:K10 contains data or references to other cells. Other cells
> > in
> > column is blank.
> >
> > So
> >
> > DefinedRange(K3:K100) will return range K3:K10.
> >
> > where DefinedRange is the function I need. Is this possible?
>
> There are several ways to do this, depending on the data you have in the 
> range (text or numbers, and whether it includes blanks or not).  Google 
> for "excel dynamic ranges" and you'll get some pages that show you how 
> these formulas work.
>
> HTH,
>
> - olly
>
>
> _______________________________________________
> gnumeric-list mailing list
> gnumeric-list gnome org
> http://mail.gnome.org/mailman/listinfo/gnumeric-list

-- 
View this message in context: 
http://www.nabble.com/Formel-that-return-a-range-is-needed-tf3996490.html#a11358676
Sent from the GnuMeric mailing list archive at Nabble.com.