| View previous topic :: View next topic |
| Author |
Message |
SharkD
General User
Joined: 17 Sep 2008
Posts: 19
|
 Posted: Wed Aug 05, 2009 8:05 am Post subject: Make ADDRESS function return ranges? |
 |
|
Is there a way to get the ADDRESS function to return a range instead of only a single cell? Thanks!
-Mike |
|
| Back to top |
|
 |
ken johnson
Super User
Joined: 23 Apr 2009
Posts: 1875
Location: Sydney, Australia
|
| Posted: Wed Aug 05, 2009 1:10 pm Post subject: |
|
|
Use ADDRESS twice with &":"& between them...
=ADDRESS(1;2)&":"&ADDRESS(3;4) returns $B$1:$D$3
Ken Johnson |
|
| Back to top |
|
|
SharkD
General User
Joined: 17 Sep 2008
Posts: 19
|
| Posted: Thu Aug 06, 2009 10:49 am Post subject: |
|
|
| Thanks! |
|
| Back to top |
|
|
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Thu Aug 06, 2009 12:28 pm Post subject: |
|
|
Address does not return a reference to a cell. It returns a string representing the address of a cell.
OFFSET(start_reference; row_off ; cols_off ; resize_rows ; resize_cols) returns any cell or range you can calculate from numbers.
INDEX(range; row ; col) does a similar trick for a single cell within the initial reference. From row=0 you get an entire column, from col=0 you get an entire row.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org |
|
| Back to top |
|
|
|
