|  | Cell Value as Named Range Reference | | |
| | | Guest |  |
|  Posted: Mon Jul 28, 2008 3:34 pm Post subject: Cell Value as Named Range Reference |  |
Little bit of a quirky question...
Trying to use a cell value as a reference in a formula, where that
cell value is the name of a named range.
So, assume A1:A3 is a named range: Rng1. And, B1:B3 is Rng2.
I want to get the correlation vale for A1:A3 and B1:B3
So, cell D1 contains "Rng1" and D2 has "Rng2"; and cell D3 has the
formula: =correl(D1,D2). But I get an error. Have also tried using
Indirect to no avail.
Any help would be hugely appreciated. Thank you. |
| |
| | | Guest | |
| | Posted: Mon Jul 28, 2008 3:37 pm Post subject: Re: Cell Value as Named Range Reference | |
nevermind...Indirect did work.
=correl(indirect(d1),indirect(d2))
On Jul 28, 11:34 am, stephen.h....@gmail.com wrote:
| Quote: | Little bit of a quirky question...
Trying to use a cell value as a reference in a formula, where that
cell value is the name of a named range.
So, assume A1:A3 is a named range: Rng1. And, B1:B3 is Rng2.
I want to get the correlation vale for A1:A3 and B1:B3
So, cell D1 contains "Rng1" and D2 has "Rng2"; and cell D3 has the
formula: =correl(D1,D2). But I get an error. Have also tried using
Indirect to no avail.
Any help would be hugely appreciated. Thank you. |
|
| |
| | | Wigi | |
| | Posted: Mon Jul 28, 2008 3:58 pm Post subject: RE: Cell Value as Named Range Reference | |
=CORREL(INDIRECT(D1),INDIRECT(D2))
--
Wigi
LINK = Excel/VBA, soccer and music
"stephen.h.dow@gmail.com" wrote:
| Quote: | Little bit of a quirky question...
Trying to use a cell value as a reference in a formula, where that
cell value is the name of a named range.
So, assume A1:A3 is a named range: Rng1. And, B1:B3 is Rng2.
I want to get the correlation vale for A1:A3 and B1:B3
So, cell D1 contains "Rng1" and D2 has "Rng2"; and cell D3 has the
formula: =correl(D1,D2). But I get an error. Have also tried using
Indirect to no avail.
Any help would be hugely appreciated. Thank you.
|
|
| |
|
|
