LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 65
Default Urgent help...

Hi all,
I have a data as below, each gourp have time with
1st row is Calls Offered
2nd row is Calls Answered
3nd row is Calls Terminated
4rd row is calls Abandoned

i want my out put
A B C D E F G H I J
__________________________________________________ ___________________________________
Group Time Sun Mon Tue Wed Thu Fri Sat Total
__________________________________________________ ___________________________________
APP_OPR 01:00 0 0 0 0 0 0 1 1 1st Row
__________________________________________________ ___________________________________
0 1 1 1 1 0 1 5 2nd Row
__________________________________________________ ___________________________________
0 0 0 0 0 0 0 0 3rd Row
__________________________________________________ ___________________________________
0 0 0 0 0 0 0 0 4th Row
__________________________________________________ ___________________________________
01:15 0 0 0 0 0 0 1 1 1st Row
__________________________________________________ ___________________________________
0 2 0 3 0 0 0 5 2nd Row
__________________________________________________ ___________________________________
0 0 0 0 0 0 1 1 3rd Row
__________________________________________________ ___________________________________
0 0 4 0 0 0 0 4 4th Row
__________________________________________________ ___________________________________
ATHENA 01:00 1 0 1 0 0 0 0 2
__________________________________________________ ___________________________________
0 0 0 0 0 0 0 0
__________________________________________________ ___________________________________
0 0 0 0 0 0 0 0
__________________________________________________ ___________________________________
0 0 0 0 0 0 0 0
__________________________________________________ ___________________________________
02:10 0 3 1 0 1 0 0 5
__________________________________________________ ___________________________________
0 0 0 0 0 0 0 1
__________________________________________________ ___________________________________
1 0 1 0 0 0 0 2
__________________________________________________ ___________________________________
0 0 0 0 0 0 0 0
__________________________________________________ ___________________________________


I want to know how many call offered, call answered, calls terminated, call
abandoned group wise then by time & then week wise.

TIA

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
IME MODE FOR EXCEL 2007 (URGENT URGENT) Stella Wong Excel Discussion (Misc queries) 1 August 23rd 08 11:16 PM
Urgent please help!! HighlandRoss Excel Discussion (Misc queries) 3 November 22nd 07 11:44 AM
urgent help helphelp Excel Discussion (Misc queries) 1 May 15th 07 11:30 AM
urgent help! jaime smith Setting up and Configuration of Excel 1 April 30th 07 08:42 AM
Urgent-Urgent VBA LOOP Jeff Excel Discussion (Misc queries) 0 October 6th 05 05:46 PM


All times are GMT +1. The time now is 10:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"