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