Coba pakai sumproduct: =SUMPRODUCT(1/COUNTIF($B$2:$B$26,$B$2:$B$26)*(H3=$A$2:$A$26)) Copas kebawah
Wassalam ~ Bagus ~ ----- Original Message ----- From: aris sarman farici [email protected] [belajar-excel] To: [email protected] Sent: Wednesday, June 25, 2014 4:49 PM Subject: [belajar-excel] Mencari Rumus [1 Attachment] Dear Para Master Excel, mohon bantuannya untuk mencari rumus dalam kasus seperti file terlampir. terima kasih sebelumnya.
