Count Occurances

[gjameson via OfficeKB.com]

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.

 

[Bernard Liengme]

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/2005/06/23/download-pivottable-parameters/
best wishes

 

[gjameson via OfficeKB.com]

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.

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/2005/06/23/download-pivottable-parameters/
best wishes

Using Excel 2003.

[quoted text clipped - 18 lines]

Using Excel 2003.

 

[Bernd P]

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