View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Andrew Andrew is offline
external usenet poster
 
Posts: 358
Default Calculating Information

I have created a workflow to determine work hours from when a request was
received until it is completed. The date / time is captured as yyyy/mm/dd
hh:mm

In the workflow the date / time is captured in column A while the type off
request (open account) is captured in column F.

I am now creating a summary in a new worksheet of how many requests of which
type were received on a spesific date (yyyy/mm/dd)

The date is shown in column A in the new worksheet while the request type
will be captured in row 1

Column A Column B
Row 1 Open Account
Row 2 2008/08/01 #??

Thank you!
--
Andrew