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