| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text and Formula in the Same Cell
If you want it to count itself, then you would need to click on iteration in
calculate tab of Tools=options to allow circular references. The formula would then be ="ABCD " & countif(A1:A10,"ABCD*") in that case. Iteration is an application level setting. If it is on, it is on for all workbooks. -- Regards, Tom Ogilvy "Myrna Larson" wrote in message ... But that formula can't go in A1:A10, right? I thought that's what he meant by "in the column", but maybe I'm over-interpreting.... On Thu, 28 Oct 2004 21:29:25 -0400, "Tom Ogilvy" wrote: ="ABCD " & countif(A1:A10,"ABCD") |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| bold text of referenced cell show in formula cell | Excel Worksheet Functions | |||
| The result of a formula referring to a cell with formula as text? | Excel Worksheet Functions | |||
| Concatenate text cell and formula cell result | Excel Worksheet Functions | |||
| Excel Formula if cell is empty then no if text in cell then yes | Excel Worksheet Functions | |||
| match cell text with text in formula | Excel Worksheet Functions | |||
Threaded Mode
