saya membuat dengan CONCATENATE :=IF(LEFT( 
CONCATENATE(IF(D4>0,$D$2,""),IF(E4>0,"," & $E$2,""),IF(F4>0,"," & 
$F$2,""),IF(G4>0,"," & $G$2,""),IF(H4>0,"," & $H$2,""),IF(I4>0,"," & $I$2,"")) 
,1)=",",MID(CONCATENATE(IF(D4>0,$D$2,""),IF(E4>0,"," & $E$2,""),IF(F4>0,"," & 
$F$2,""),IF(G4>0,"," & $G$2,""),IF(H4>0,"," & $H$2,""),IF(I4>0,"," & 
$I$2,"")),2,LEN( CONCATENATE(IF(D4>0,$D$2,""),IF(E4>0,"," & 
$E$2,""),IF(F4>0,"," & $F$2,""),IF(G4>0,"," & $G$2,""),IF(H4>0,"," & 
$H$2,""),IF(I4>0,"," & $I$2,"")) )),CONCATENATE(IF(D4>0,$D$2,""),IF(E4>0,"," & 
$E$2,""),IF(F4>0,"," & $F$2,""),IF(G4>0,"," & $G$2,""),IF(H4>0,"," & 
$H$2,""),IF(I4>0,"," & $I$2,"")) ) =copy ke baris L4:L15 
 To: [email protected]
From: [email protected]
Date: Wed, 22 Jun 2011 08:12:26 +0000
Subject: [belajar-excel] Re: Summary berdasarkan dari Header


















 



  


    
      
      
      
coba 
juga,=MID(REPT(","&D$2,D15<>0)&REPT(","&E$2,E15<>0)&REPT(","&F$2,F15<>0)&REPT(","&G$2,G15<>0)&REPT(","&H$2,H15<>0)&REPT(","&I$2,I15<>0),2,99)

>semoga bermanfaat

--- In [email protected], "Mr. Kid" <mr.nmkid@...> wrote:
>
> Coba pada record pertama :
> =MID(REPT(","&D$2,-INT(-D4))&REPT(","&E$2,-INT(-E4))&REPT(","&F$2,-INT(-F4))&REPT(","&G$2,-INT(-G4))&REPT(","&H$2,-INT(-H4))&REPT(","&I$2,-INT(-I4)),2,99)
> 
> copy ke bawah
> 
> Kid.
> 
> 2011/6/22 Tony Bexcel tonybexcel@...
> 
> > **
> >
> >
> > Dear Pakar yang Budiman,
> >
> > Mohon maaf bila tulisan Judul atau pun maksud tulisan tidak dimengerti,
> > karena saya kesulitan menyampaikan maksud nya.
> > Inti tujuan nya terlampir pada File terlampir..
> > Atas segala bantuan ilmu dan waktunya saya ucapkan banyak terimakasih ya
> > Temanz..
> >
> > Salam,
> > TonyBexcel
> >
> >  
> >
>




    
     

    
    






                                          

Kirim email ke