Counting Multiple Data in a range.

F

Frank Kabel

Hi
I would use a pivot table for this. see:
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

-----Original Message-----
I have a sheet that contains all of our company vehicles
Click to expand...
listing them by location. Column A lists the vehicle #
B,C,D all list information about the vehicle. Column E
lists the location. The locations are in text format
examples -BT, HO, GR, GV...etc.... There are a total of 14
different locations. What I am looking for is an easy way
to count the number of vehicles I have at each location in
coulumn E. Any ideas ???
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count Multiple Data in a column 2
I need to know EVERYTHING about PIVOT tables Urgently for an Exam 1
Comparing & Counting Data 0
Count Column B if Column A is within a multiple specificed ranges 2
Gather multiple keyword and separate them to categories 2
Multiple Consolidation Range prob 0
Macros to Rearrange Data?? 2
Special Paste to Next empty row if new data and mark copied Macro 0

Top