thx Kid, sudah banyak bantu... ----- Original Message ----- From: nm kid To: [email protected] Sent: Thursday, July 02, 2009 11:30 AM Subject: Re: [belajar-excel] Kelipatan 5 tahun dan cari angka terbesar
Oh iya, Bagian menghitung yang terbesar : Jika 1 nilai yang terbesar (dimana saja pada suatu range -- misal C21:C32) =Max(C21:C32) atau Large(C21:C32,1) Pada formula Large(), angka 1 menunjukkan yang urutan ke-1. Jadi kalimatnya Cari nilai di range C21:C32 diurutkan dari yang terbesar (terbanyak) ke tersedikit, urutan ke 1. Kalau ingin urutan ke 3, ganti angka 1 dengan angka 3. Kid. PT. BANK ARTHA GRAHA INTERNASIONAL TBK. DISCLAIMER: This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. If you are not the intended recipient you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited.
