counting frequency of text string

[ralf_the_cat]

I want to count the frequency of text strings in a column like the
example below:

from this:
eggs
milk
eggs
bread
eggs
milk
sugar

to this:
3 l eggs
2 l milk
3 l eggs
1 l bread
3 l eggs
2 l milk
1 l sugar

I found the frequency function but it only counts numbers.

How do I do that?
thanks
rAlf

 

[Trevor Shuttleworth]

Ralf

I think you need CountIf. Check out the Excel Help or use the Function
Wizard.

Regards

Trevor

 

[ralf_the_cat]

That's it - thank

 

[A.W.J. Ales]

Ralf,

I'm not sure, but if your list of items in column A is fixed in length, say
: A1:A7, you could use the formula :
=COUNTIF($A$1:$A$7,A1) in lets say cell B1 and copy it down to B7.
Eventually you can take up in cell C1 the "formula" =A1 and copy it down
too.


--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *