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