Kalau dilihat subject topik ini = "Menghitung pemakaian user" sebaiknya (jika tak bermaksud membicarakan kasus pak Tony Bexcel lagi), fungsi Frequency ditanyakan & dibicarakan dlm conversation / thread baru.
(yg membuka topik baru seharusnya ya pak angga itu, bukan malah menyarankan Pak Kid untuk menjawb dengan buka topik baru, (yok opo rek ?) 2011/6/4 Angga Gurmilang Sedar <[email protected]> > > > Hehehe, masih lum ditutup mas Kid, si penanyak belum nutup tritnya… > > > > Saya juga tengok2 sedikit nih formula dari Mas Kid, > > Ada satu fungsi yang saya ga pernah liat sebelumnya, yaitu fungsi * > FREQUENCY* > > *=**FREQUENCY**(I4:I91,ROW($B$4:$B$91)-ROW($B$3))* > > Kalau mas Kid berkenan, bisa dikasik contoh lainnya ga? Penggunaan dari > Fungsi FREQUENCY ini? > > > > **mungkin buka trit baru lagi** > > > > -Gilang Sedar- > > > > *From:* [email protected] *On Behalf Of *Mr. Kid > *Sent:* Saturday, June 04, 2011 2:43 PM > *To:* [email protected] > *Subject:* Re: [belajar-excel] Menghitung pemakaian user > > Boleh ikutan ? Moga2 belum ditutup thread-nya. > > Silakan coba array formula tanpa kolom bantu seperti file terlampir. > >
FREQUENCY Calculates how often values occur within a range of values, and then returns a vertical array of numbers. For example, use FREQUENCY to count the number of test scores that fall within ranges of scores. Because FREQUENCY returns an array, it must be entered as an array formula. Syntax FREQUENCY(data_array,bins_array) Data_array is an array of or reference to a set of values for which you want to count frequencies. If data_array contains no values, FREQUENCY returns an array of zeros. Bins_array is an array of or reference to intervals into which you want to group the values in data_array. If bins_array contains no values, FREQUENCY returns the number of elements in data_array. Remarks FREQUENCY is entered as an array formula after you select a range of adjacent cells into which you want the returned distribution to appear. The number of elements in the returned array is one more than the number of elements in bins_array. The extra element in the returned array returns the count of any values above the highest interval. For example, when counting three ranges of values (intervals) that are entered into three cells, be sure to enter FREQUENCY into four cells for the results. The extra cell returns the number of values in data_array that are greater than the third interval value. FREQUENCY ignores blank cells and text. Formulas that return arrays must be entered as array formulas.
