Dynamic (?) formula
Hello all,
I do not know if dynamic is the right word because I did not find anything
applicable when searching the newsgroup...
In column A I have some data in form of numbers.
In cell B1 I would like to have a formula. The formula should be dependent
on what is entered in B2. For example if I enter 'sum' in B2, the B1 formula
should look like '=sum(A:A)'
If I then change B2 to 'count' then the B1 formula should be '=count(A:A)'
The solution sould also work on something like worksheet names being part of
a formula...
Rgds,
Thore
|