Re: Formel that return a range is needed
- From: d98rolb <roland bengtsson gmail com>
- To: gnumeric-list gnome org
- Subject: Re: Formel that return a range is needed
- Date: Fri, 29 Jun 2007 04:22:05 -0700 (PDT)
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.
[
Date Prev][Date Next] [
Thread Prev][Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]