Il 08/02/2011 22:54, Johnny Rosenberg ha scritto:
Den 2011-02-08 20:58:16 skrev yahoo-pier_andreit pier_andr...@yahoo.it:
Il 08/02/2011 18:02, Johnny Rosenberg ha scritto:
What I want is a cell function like ADDRESS(), but instead of a
reference to a single cell, I want a reference to a cell
My cursor keeps jumping from location to location while typing without any
prompting from me. Might you direct me to where I might get some help for a
correction!
-Original Message-
From: yahoo-pier_andreit
Sent: Wednesday, February 09, 2011 4:32 AM
To: users@openoffice.org
Subject:
Den 2011-02-09 10:32:02 skrev yahoo-pier_andreit pier_andr...@yahoo.it:
Il 08/02/2011 22:54, Johnny Rosenberg ha scritto:
Den 2011-02-08 20:58:16 skrev yahoo-pier_andreit
pier_andr...@yahoo.it:
Il 08/02/2011 18:02, Johnny Rosenberg ha scritto:
What I want is a cell function like
What I want is a cell function like ADDRESS(), but instead of a reference
to a single cell, I want a reference to a cell range.
ADDRESS(1;1;1) ⇨ $A$1
ADDRESS(2;2;4) ⇨ B2
I would like something like this:
RANGEADDRESS(1;1;1;2;2;4) ⇨ $A$1:B2
Can't find such a function, though. What do I miss?
Il 08/02/2011 18:02, Johnny Rosenberg ha scritto:
What I want is a cell function like ADDRESS(), but instead of a
reference to a single cell, I want a reference to a cell range.
ADDRESS(1;1;1) ⇨ $A$1
ADDRESS(2;2;4) ⇨ B2
I would like something like this:
RANGEADDRESS(1;1;1;2;2;4) ⇨
Den 2011-02-08 20:58:16 skrev yahoo-pier_andreit pier_andr...@yahoo.it:
Il 08/02/2011 18:02, Johnny Rosenberg ha scritto:
What I want is a cell function like ADDRESS(), but instead of a
reference to a single cell, I want a reference to a cell range.
ADDRESS(1;1;1) ⇨ $A$1
ADDRESS(2;2;4) ⇨ B2