....
terima-kasih banyak
----- Original Message -----
From: siti Vi
To: [email protected]
Sent: Thursday, January 21, 2010 4:52 PM
Subject: Re: [belajar-excel] [Tanya] : menghitung angka yang paling sering
muncul
ada
fungsinya bernama MODE
=MODE(C4:H20)
di worksheet terlampir hasilnya 92
kalo ndak percaya, buka deh lampirannya
data yg "banyak sekali" itu tentunya ada di dalam suatu RANGE kan?
dlm contoh miniaturnya range tsb = C4:H20
mungkin worksheet anda range berisi bilangannya: A1:IV65536
------------------------------------------------------------------------------
----- Original Message -----
From: Tauffik Effendi
To: [email protected]
Sent: Thursday, January 21, 2010 4:37 PM
Subject: [belajar-excel] [Tanya] : menghitung angka yang paling sering
muncul
rekans,
Apabila saya punya data angka yang sangat banyak dalam worksheet excel
dan saya ingin mengetahui berapakah angka yang paling sering muncul dalam
data tersebut,
apakah ada function atau data analysis toolpak yang dapat saya gunakan ?
terima-kasih
*****
This message may contain confidential and/or privileged information. If you are
not the addressee or authorized to receive this for the addressee, you must not
use, copy, disclose or take any action based on this message or any information
herein. If you have received this communication in error, please notify us
immediately by responding to this email and then delete it from your system. PT
Pertamina (Persero) is neither liable for the proper and complete transmission
of the information contained in this communication nor for any delay in its
receipt.
*****
