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.