If I did turn on iterations, would it affect all workbooks or just the one
that I turn it on for? And how would I turn it on?

I only need to create this one formula, so I'm not too worried about more
circular references in it, but if the change will affect other workbooks,
then, you're right; I had better not.

"Myrna Larson" wrote:

I can come up with a couple of formulas to get the name plus its count in
column A. Assuming D1 has the formula to get the count, and you put this
formula is in column A,

="Myrna Larson"&" "&TEXT(D1,"##0")

The formula for D1 is: =COUNTIF($A:$A,"Myrna Larson"&"*")

You can combine the two formulas to get, in column A,

="Myrna Larson"&" "&TEXT(COUNTIF($A:$A,"Myrna Larson"&"*"))

Problem is, both of those create a circular reference. I suppose you could
turn iterations on, but I sure wouldn't do that. Then you get no warning when
you create an unintentional circular reference.

Put the count in a separate column.


On Thu, 28 Oct 2004 17:55:03 -0700, LDanix
wrote:

Hi all!

Is it possible to place text and a formula in the same cell? I have a column
of people's names. But I would like to add a count of occurences of that name
in the column. I have successfully been able to do the count in another cell
but I want the name and the figure in the same cell.