Modify Which Statistic is Performed with Drop-down

[yunesm]

- In cell "C3" you can select either Average or Median

- I need to perform '=average(DATA_RANGE)' or '=median(DATA_RANGE)' based on what is selected in "C3"

- This equation: "="&INDIRECT("C3")&"("&"DATA_RANGE"&")" will return the text "=MEDIAN(DATA_RANGE)"

- So I need to remember how to get Excel to look at my returned text as an equation. Any ideas would be appreciated!

- I have this working fine now using a simple if statement "=IF(C3="MEDIAN",MEDIAN(DATA_RANGE),AVERAGE(DATA_RANGE))". But I'd really like to remember how I got something like this to work before so I can use it on more complicated situations

Any thoughts would be appreciated.
Thanks!

[darkyam]

With the morefunc.xll add-in, you can use =EVAL(A1&"("&C1:C7&")"), with A1 being the dropdown and C1:C7 being the range. Keep in mind that this won't work for formulas requiring different argument lists, of course. Also, the add-in can be imbedded in the file, so you can share it with other users without a loss of functionality.