Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counts Numbers
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel counts 2 digit numbers as 1... | Excel Worksheet Functions | |||
average daily counts to weekly counts | Excel Discussion (Misc queries) | |||
counts | Excel Discussion (Misc queries) | |||
Counts | Excel Discussion (Misc queries) | |||
Record Counts | Excel Worksheet Functions |