Cell Value as Named Range Reference

  • Thread starter Thread starter stephen.h.dow
  • Start date Start date
S

stephen.h.dow

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.
 
Back
Top