|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
Number of vehicles
"Max" wrote:
Try a pivot table, takes only seconds to set-up
Select a cell inside your data table,
click Data Pivot Table
Click Next Next
In step 3 of the wizard, click Layout
drag n drop Department into ROW area
drag n drop Make into DATA area
(it'll appear as Count of Make)
Click OK Finish. That's it!
Hop over to the pivot sheet (just to the left) for the summary
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Kula" wrote:
This is a sample worksheet named Vehicle Data to work from.
ID YEAR MAKE TYPE ODOMETER DEPARTMENT
EB122 2003 Nissan Van 24575 Academic
EM911 2004 Toyota Truck 98702 Academic
CW001 1995 Ford SUV 32765 Administration
CY723 1995 Ford Pickup 73419 Administration
CD234 1997 Mistubish Hilux 32564 Medical
FD321 1993 Hino Sedan 94321 Planning
CN210 1991 Toyota Van 138456 IT
DT592 2002 Ford Sedan 37780 Maintenance
I want to make another worksheet to be called Summary to determine the
number of vehicles used by each department. What function am I to use?
it doesnt halp........isnt there any other way to solve such problem of inserting appropriate formulas rather than using pivot tables coz it doesnt help
|