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

