Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
#value problem + text to formula
I keep getting a #value when I enter
=VALUE(CONCATENATE("=power(countif(c$3:c$",(VALUE( AL3)),",$af3),1)")) C$3 = 3 AL3 = 12 $af3 = 1 I'm using excel2007 beta2, and cannot get the Find & Select Replace the " with NOTHING when I use CONCATENATE("=countif(c$3:c$",(VALUE(AL3)),",$af3) ") I'm tring to have the text turn into this formula =countif(c$3:c$12,$af3) and then give a value. I don't know anything about micro and at best a novice at excel. Please HELP!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible? | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Text in formula bar is not displaying in cell | Excel Discussion (Misc queries) | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) |