Re: [belajar-excel] Menghitung jumlah equipment tanpa duplikasi

[Toby kenzo tobyke...@yahoo.co.id [belajar-excel]]

Dear Salim,

Coba pake formula:
Sumproduct((B1:B100<>"")/Countif(B1:B100,B1:B100&""))
It's work in Office 2013 SP1.

TerimaKasih.
Sent from Yahoo Mail on Android