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) <[email protected]>
> iyya nih masih pakai formula / cells bantu
> lihat lampiran
>
> 2011/9/16 Fano The Miner <[email protected]>
>
>> **
>>
>> 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
