dear all,

i have table with 100.000 rows...
column a (no) column b (customer) column c (cities name)
1 reza new york
2 bob Chicago
3. john California
4. billy New York
.....
100.000 Susi New York

now using pivot table or others i want to have output the names of that
cities and how much cities in that table. if new york have more that 1000 in
that table, still new york will count as one...
the result
new york
chicago
california
etc
hope you understand what i want to archive....
please help me to save my time

thanks