Re: Formel that return a range is needed

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
column is blank.


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.


- olly

gnumeric-list mailing list
gnumeric-list gnome org

View this message in context:
Sent from the GnuMeric mailing list archive at

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