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