Hi,
For the senario I posted, your suggestion will be suffice.
In reality the data set will be much larger, in the thousands.
The value for city is entered in a data entry form and there no easy way to
validate the spelling. There is a good chance user input will have
mispellings for city names thus using Find/Replace will not work since it
isn't known which character to find and replace.
Meanwhile, I have been playing with pivot tables but again I keep coming up
to same result that I described in my original question.
Might have to start reading on how to write a script or VB program - I
hestitate as I have no previous experience of writing scripts or programs for
Excel.
Regards.

"Roger Govier" wrote:

Hi
Excel will treat those as 2 separate occurrences of the city name, hence
that is the result you will get.
You could use Control +H to bring up Find and Replace.
Replace ,
With leave blank
Replace All.
Then carry out your Subtotal

--
Regards
Roger Govier


"Tosh" wrote in message
...
Hi Roger, thanks for replying to my post.
When I select City instead of Zip then I get:
Zip City
55901 Mytown
Mytown Count 1
55901 Mytown,
Mytown, Count 1
55906 Yourtown
Yourtown Count 1
55906 Yourtown,

"Mytown" and "Mytown," is counted as different cities.
My intent is to list 2 cities for zip code 55901 - even though the
spelling
of city
might be incorrect. i.e "Mytown" or "Mytown," - notice the comma.

"Roger Govier" wrote:

Hi

Use the first dropdown in the Subtotal dialogue to select City instead of
ZIp.

--
Regards
Roger Govier


"Tosh" wrote in message
...
Zip City
55901 Mytown
55901 Mytown,
55906 Yourtown
55906 Yourtown,
55906 Yourtown,
I subtotal on Zip code and use Count function
This gives a new column with subtotal in this format:
55901 Count 2
55906 Count 3
My objective is to subtotal on zip code but wish to see the label be
the
'City'
i.e
Mytown Count 2,
Yourtown, Count 3
Any suggestions would be much appreciated.
I am using MS Excel 2000.
Tosh.