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.