bisa juga pakai fungsi yg bernama *YaGituDeh* * * * Penggunaan di celsl /sheet: array formula multi hasil * *
* * =YaGituDeh(B7:B11,C7:C11) ** * Lihat alampiran ---- vba coding ---- Function YaGituDeh(Items As Range, Repeater As Range) ' ctv // 16 sept 2011 Dim Ygd(), i As Long, n As Long, p As Long For i = 1 To Items.Rows.Count For p = 1 To Repeater(i).Value n = n + 1: ReDim Preserve Ygd(1 To n) Ygd(n) = Items(i) Next p Next i YaGituDeh = WorksheetFunction.Transpose(Ygd) End Function 2011/9/16 STDEV(i) <setiyowati.d...@gmail.com> > iyya nih masih pakai formula / cells bantu > lihat lampiran > > 2011/9/16 Fano The Miner <fano.themi...@gmail.com> > >> ** >> >> Mohon Bantuannya yah.. :) >> Formula seperti apa untuk lanjut kode stock berdasarkan kolom jumlah, >> seperti pada kolom hasil? (contoh file terlampir) >> Terima Kasih.. >> Salam. >> Fano >> >>
c__mengulang rujukan sebanyak JUMLAH (plus UDF).xlsb
Description: Binary data