Urgent Solution Req

sushantrao

Board Regular
Joined
Jun 24, 2006
Messages
151
Hi All,

I Have Data in the below format
calllogreport 20 sept.xls
BCDE
2X-INQUIRY1
3AARTITotal1
4B-BLANK CALL15
5X-INQUIRY2
6DIPIKATotal17
7B-BLANK CALL2
8EKTATotal2
9X-INQUIRY6
10AARTITotal6
11X-INQUIRY1
12CALL CENTER TEST TICKETTotal1
13X-INQUIRY14
14DIPIKATotal14
15X-INQUIRY1
16EKTATotal1
Sheet4





which in want in the below format
calllogreport 20 sept.xls
FGHIJK
1
2X-INQUIRYB-BLANK CALLCOMPLAINT
3AARTI7
4DIPIKA1615
5EKTA32
6
7
Sheet4



I have data in 400 Rows where i cannot use the same formula
i tried lookup but not worked. i copy paste the name of the agent againts
his complaint, blank call & comalaint call & then use filter but I have 20 days data & each day has 400 rows with the data
can any one help gor any other formula or solution ?
Its urgent


thanks,
Sushant
 

Some videos you may like

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

Watch MrExcel Video

Forum statistics

Threads
1,114,655
Messages
5,549,243
Members
410,905
Latest member
Extjel
Top