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