Formula - Count multi filter ???

[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

 

[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

(If it doesn't automatically change to Count of Request, dbl-click it
and change it)

Click the [OK] button

-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

 

[Guest]

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.

 

[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

 

[ecohen1]

Thank you so much Ron

 

[ecohen1]

Thanks guys , it's works perfectly