using pivot table
 

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

using pivot table
 

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
--
Faraz!


"reza" wrote:

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

using pivot table
 

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


"Faraz A. Qureshi" wrote:

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
--
Faraz!


"reza" wrote:

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

using pivot table
 

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

"reza" wrote:

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