Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count Occurances
Using Excel 2003.
I will try to explain this the best way I can. I have a spreadsheet that compiles trouble call data. Every call that is logged has a ID# for that location. There are about 900 locations. In the course of a year not all locations will have a trouble call. I want to see who had how many calls. I know I can write countif statements for each of the 900 locations, but I really do not want to do that. I want know exactly who had troubles. If I have the data as to who had multiple calls, I can plug each one into my pivot table to show the nature of the calls. I hope some one can understand what I am looking for, this my be beyond the scope of Excel. Using Excel 2003. -- Message posted via http://www.officekb.com |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count Occurances
This type of problem calls out for a pivot table solution
http://www.cpearson.com/excel/pivots.htm http://peltiertech.com/Excel/Pivots/pivotstart.htm http://www.contextures.com/xlPivot02.html http://www.ozgrid.com/Excel/excel-pivot-tables.htm http://www.techonthenet.com/excel/pivottbls/index.htm http://www.dicks-blog.com/archives/2...le-parameters/ best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "gjameson via OfficeKB.com" <u21717@uwe wrote in message news:a19d1d5eba3e1@uwe... Using Excel 2003. I will try to explain this the best way I can. I have a spreadsheet that compiles trouble call data. Every call that is logged has a ID# for that location. There are about 900 locations. In the course of a year not all locations will have a trouble call. I want to see who had how many calls. I know I can write countif statements for each of the 900 locations, but I really do not want to do that. I want know exactly who had troubles. If I have the data as to who had multiple calls, I can plug each one into my pivot table to show the nature of the calls. I hope some one can understand what I am looking for, this my be beyond the scope of Excel. Using Excel 2003. -- Message posted via http://www.officekb.com |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count Occurances
Thanks for the great links. I had a feeling that it could be done with pivot
tables. I know just enought to be dangerous with pivot tables. I will study this area a little more. Bernard Liengme wrote: This type of problem calls out for a pivot table solution http://www.cpearson.com/excel/pivots.htm http://peltiertech.com/Excel/Pivots/pivotstart.htm http://www.contextures.com/xlPivot02.html http://www.ozgrid.com/Excel/excel-pivot-tables.htm http://www.techonthenet.com/excel/pivottbls/index.htm http://www.dicks-blog.com/archives/2...le-parameters/ best wishes Using Excel 2003. [quoted text clipped - 18 lines] Using Excel 2003. -- Message posted via http://www.officekb.com |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count Occurances
Hello Uwe,
A pivot table might be exactly what you are looking for, Bernard already gave you some links. If you would like to solve this with a macro: http://sulprobil.com/html/listfreq.html Take Pfreq, I suggest. Regards, Bernd |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count occurances | Excel Worksheet Functions | |||
Count of different occurances | Excel Discussion (Misc queries) | |||
Count Occurances of a txt string | Excel Discussion (Misc queries) | |||
count occurances | Excel Discussion (Misc queries) | |||
count matching occurances | Excel Worksheet Functions |