Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IME MODE FOR EXCEL 2007 (URGENT URGENT) | Excel Discussion (Misc queries) | |||
Urgent please help!! | Excel Discussion (Misc queries) | |||
urgent help | Excel Discussion (Misc queries) | |||
urgent help! | Setting up and Configuration of Excel | |||
Urgent-Urgent VBA LOOP | Excel Discussion (Misc queries) |