Conditional formatting for text to number

[Guest]

I am needing some help with the best way to quatify text.
Here is what I have. I am wanting to be able to a chart that will count how
many of each town. Rather than manually counting how many of each, I would
like to have it programed to do that for me

Name Town
Bill Breese
John Chicago
Tony Breese


I would like to have it count each different town and place that number in a
different cell to total.

Thanks in advanced

Jason

 

[Guest]

Set the following formula in cells, using each different Town in each one.
This will give numbers for each town. You can then build your chart from
those cell values.

I am assuming the Name is one column and the Town is another.

=COUNTIF(B2:B100,"Breese")

 

[Andrew Taylor]

A pivot table is probably the easiest way to do this
(select the Town column, then Data/Pivot Table..)

 

[Guest]

See below for what you need to use:

From the help file:

COUNTA

Counts the number of cells that are not empty and the values within the list
of arguments. Use COUNTA to count the number of cells that contain data in a
range or array.

Syntax

COUNTA(value1,value2,...)

Value1, value2, ... are 1 to 30 arguments representing the values you want
to count.

 

[Guest]

Thanks for the input. I will try it over the weekend.

Jason

 

[Peter Huang [MSFT]]

Hi Jason,

How is the things going?
Did you have any finding after you perform the testing?

If you have any questions or concerns, please don't hesitate to let me
know. I look forward to hearing from you, and I am happy to be of
assistance.


Best regards,

Peter Huang

Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.