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
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,168,126
Messages
5,857,523
Members
431,883
Latest member
Hien

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top