Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Need dynamic table_array formula that looks in different sheets | Excel Worksheet Functions | |||
dynamic year to date formula | Excel Worksheet Functions | |||
Dynamic Year-To-Date Formula | Excel Worksheet Functions | |||
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) |