Text to columns

[Mohandas]

Please help me in this format attached .

 

[Somendra Misra]

Hi,

Is there any logic behind No. of eaches per case (column K)? or we can use the cell value directly.

Regards,

 

[Mohandas]

No logic it is predfined we can enter it

 

[Somendra Misra]

So you want an output sheet with column A,B,K,P & Q?

 

[Mohandas]

Final Output is P,Q

 

[Faseeh]

@Mohandas : Please try in M3

=LEFT(B3,FIND("/",B3)-1)+0+(MID(B3,FIND("/",B3)+1,4)+0)/K3

 

[Somendra Misra]

Try in U3 amd copy down,

=SUM(IF(P3=$A$3:$A$35,MID($B$3:$B$35,1,SEARCH("/",$B$3:$B$35)-1),0)+0,IFERROR(IF(P3=$A$3:$A$35,MID($B$3:$B$35,SEARCH("/",$B$3:$B$35)+1,256)+0,0)/IF(P3=$H$3:$H$35,$K$3:$K$35,1),0))

Regards,

 

[Mohandas]

THis is working out but some time. Some codes are appeaching double time is there any way to do it

 

[Somendra Misra]

Just check my code, it is dealing with duplicates. (for e.g. in you sample data
12199187
is twice.)

 

[Mohandas]

Thanks