using pivot table

R

reza

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
 
F

Faraz A. Qureshi

Hi there reza,

Simply create a pivot table by using the wizard and dragging the cities
column in the Values.
Then right click the pivot table
select Value Field Settings
select Count
 
R

reza

Faraz...

thanks for ur response...
but if i used that...new york cities will count as many as they appear.
if new york appear 1000 row, so new your will count 1000.
what i want to do... i want new york will count only 1 also others city.

thanks for ur help
 
S

shaz

If you put City as a row and also City as a value. The city name will
appear once as a row and the city value will count the number of times the
city appears in your table. U could also use the Subtotal command
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula Help -- SUMIF 4
Counting Problem 5
Find cities visited 4
Combining Records and Summing Data 3
Fill colum to the next non blank row 11
countif and vlookup 1
countif and vlookup 1
Count Filter 5

Top