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


--
ecohen1
------------------------------------------------------------------------
ecohen1's Profile: http://www.excelforum.com/member.php...o&userid=12988
View this thread: http://www.excelforum.com/showthread...hreadid=488778

You are definitely in Pivot Table country on this one:

DataPivot 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


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=488778

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.


"ecohen1" wrote:


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


--
ecohen1
------------------------------------------------------------------------
ecohen1's Profile: http://www.excelforum.com/member.php...o&userid=12988
View this thread: http://www.excelforum.com/showthread...hreadid=488778

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" wrote in message
...

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


--
ecohen1
------------------------------------------------------------------------
ecohen1's Profile: http://www.excelforum.com/member.php...o&userid=12988
View this thread: http://www.excelforum.com/showthread...hreadid=488778

Thank you so much Ron


--
ecohen1
------------------------------------------------------------------------
ecohen1's Profile: http://www.excelforum.com/member.php...o&userid=12988
View this thread: http://www.excelforum.com/showthread...hreadid=488778

Thanks guys , it's works perfectly


--
ecohen1
------------------------------------------------------------------------
ecohen1's Profile: http://www.excelforum.com/member.php...o&userid=12988
View this thread: http://www.excelforum.com/showthread...hreadid=488778