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
> >
> >
> >
>