Formula - Count multi filter ???

E

ecohen1

Hi ,
I have 4 columns: Date - Shift - Request - Location
How do I get this: How many Request by Date by Shift b Location

For example:

Date Ex. Shift Request
Location
Saturday, September 24, 2005 E 2005080740 A
Saturday, September 24, 2005 N 2005081491 A
Sunday, September 25, 2005 N 2005081635 E

Results:

Saturday, September 24, 2005 ---> 2 REQUESTS (1 SHIFT E - 1 SHIFT N)
FOR LOCATION A
 
R

Ron Coderre

You are definitely in Pivot Table country on this one:

Data>Pivot Table
-Excel List
-Select your data
-Click the [Layout] button
ROW: Drag the Location, Shift, and Date fields here
DATA: Drag the Request field here
Click to expand...
(If it doesn't automatically change to Count of Request, dbl-click it
and change it)
Click the [OK] button
Click to expand...
-Select a location for the pivot table

In the Pivot Table, Click the Shift field and uncheck any Shift you
don't want to see.

Does that help?
Ron
 
P

pdberger

ecohen1 --

Are you looking for a generic approach to extracting data, or a specific
request? If it's a generic approach, then a PivotTable would work very
nicely, where it will organize ALL the data according to parameters you set
-- all the requests sorted by day and summarized by shift and location, or
other parameters.
 
B

Bernie Deitrick

ecohen1,

Use a pivot table, with Date, Request, and Shift as row fields, and count of any of those as the
data field.

HTH,
Bernie
MS Excel MVP
 
Top