Dynamic Function Reference Question

[Guest]

Does anyone know of a way to do this:

Cell 1: STDEV
Cell 2: =SUM(SomeRange)

where instead of retyping "STDEV" in Cell2 to change the function name, u
reference to Cell1 as the function name? so basically a dynamic way of
changing function name as a form of reference from another cell...

seems simple.. but never heard its been done.. hope for solution without vba
help.

 

[Arvi Laanemets]

Hi

It simply doesn't work this way.
The nearest to what you want, and functional, is something like this
=CHOOSE(MATCH(Cell1;{"Count";"CountA";"Sum";"Average"};0);COUNT(YourRange);C
OUNTA(YourRange);SUM(YourRange);AVERAGE(YourRange))

When combining the formula above with dynamic range(s) as YourRange (and
maybe determining the range YourRange through INDIRECT), you can make this
flexible enough for some easier tasks.



Arvi Laanemets