Dear Pak Toby, Ikutan nimbrung, formula sumproduct digunakan untuk bentuk-bentuk seperti apa?
Hormat saya, Samsudin Mobile Phone; 0811 5427 227 / 0811 2810 068 From: [email protected] [mailto:[email protected]] Sent: Wednesday, May 13, 2015 9:54 AM To: [email protected] Subject: Bls: [belajar-excel] Menghitung jumlah equipment tanpa duplikasi Dear Salim, maksudnya coba pake formula : =SUMPRODUCT((B1:B100<>"")/COUNTIF(B1:B100,B1:B100&"")) TerimaKasih. Pada Rabu, 13 Mei 2015 0:18, Toby kenzo <[email protected]<mailto:[email protected]>> menulis: Dear Salim, Coba pake formula: Sumproduct((B1:B100 It's work in Office 2013 SP1. TerimaKasih. Sent from Yahoo Mail on Android<http://overview.mail.yahoo.com/mobile/?.src=Android> ________________________________ From: Salim Jenggot [email protected]<mailto:[email protected]> [belajar-excel] <[email protected]<mailto:[email protected]>>; To: <[email protected]<mailto:[email protected]>>; Subject: [belajar-excel] Menghitung jumlah equipment tanpa duplikasi [1 Attachment] Sent: Tue, May 12, 2015 11:19:41 AM Dear Master, mohon dibantu kembali, bagaimana cara menghitung equipment seperti file terlampir. dalam kolom tersebut terdapat banyak duplikasi equipment, tetapi duplikasi tersebut tidak dihilangkan/delete. data tetap seperti tersebut, hanya saja setiap duplikasi dihitung tetap 1 equipment. demikian, atas sharingnya diucapkan terima kasih. salim jenggot --------------------------------------------------------------------------------------------------- This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and hereby notified that any disclosure, copying, or distribution of this message (or any part thereof), or the taking of any action based on it, is strictly prohibited. No liability or responsibility is accepted if information or data is, for whatever reason corrupted or does not reach its intended recipient. No warranty is given that this email is free of viruses. The views expressed in this email are, unless otherwise stated, those of the author and not those of the Company or its management. The Company reserves the right to monitor, intercept and block emails addressed to its users or take any other action in accordance with its email use policy.
