That Was Awesome Ron

Could you pls tell me can i use PIVOT TABEL Mention Below Data With this
Format

North South
1-4 5-7 8-10
Broker
Friends
Dealer
Overall
And Same As Remaining Zone i.e West and East
Zone Broker Friends Dealer Overall
East 1 1 1 4
East 2 2 2 8
East 1 1 1 6
East 2 1 1 10
East 1 3 3 5
East 2 4 10 9
East 3 3 3 3
East 3 2 2 9
North 1 2 1 1
North 1 1 3 5
North 1 2 1 9
North 1 1 2 7
North 3 2 1 2
North 3 1 2 6
North 2 3 1 10
North 1 3 2 5
North 5 2 3 10
South 1 2 3 2
South 6 9 9 6
South 1 2 1 10
South 1 1 1 8
South 3 2 1 3
South 1 3 2 7
South 3 3 1 1
South 7 1 2 4
West 8 10 5 3
West 1 1 2 7
West 9 10 3 5
West 1 3 3 9
West 10 3 1 4
West 1 2 1 8
West 1 1 3 2
West 3 2 3 8

Thanks In Advance



"Ron Rosenfeld" wrote:

On Wed, 18 Feb 2009 06:48:10 -0800, Hardeep_kanwar
wrote:

HI! Expert
I have data in Two Column Like This:
Zone No.
East 4
East 8
East 6
East 31
East 5
East 9
East 3
East 9
North 1
North 5
North 9
North 7
North 2
North 6
North 10
North 5
North 10
South 2
South 6
South 10
South 8
South 3
South 7
South 1
South 4
West 3
West 7
West 5
West 9
West 4
West 8
West 2
West 8
Now i Want the total number based on Zone But i different Way

Like This: 1to4,5to7,8to10

Zone East has Number from 1to 10 or Sometime 1to7or8

Now i want a count of number Between 1 to 4 like In my Example:

Zone 1-4 5-7 8-10
North 2 4 3
East 2 2 4
South 4 2 2
West 3 2 3

i.e. how many times numbers 1 to 4 have appear in East Zone or any other
Zone. And also 5to 7 and 8to 10.

I hope you guys will understand my Problem.

Thanks in Advance

Hardeep kanwar

You could also use a Pivot Table

Drag zones to Row
Drag No to columns
Drag No. to data area

Change Sum of No. to Count of No.

Select a column label, then
Group
starting at 5
ending at 10
By: 3

(By starting at 5, the values below 5 will be 1-4)

Then relabel the appropriate headers.

My result:

Count of No. Nos.
Zones 1-4 5-7 8-10 11 Grand Total
North 2 4 3 9
East 2 2 3 1 8
South 4 2 2 8
West 3 2 3 8
Grand Total 11 10 11 1 33

Note that there is an entry for 11 since one of your entries is 31.
--ron