Pak Fendi;
Coba begini (array formula ya):
=Index(b5:g5, mod(max(frequency(match(b5:g5,b5:g5,0),
row(1:1))*100+row(1:1)),100))
akhiri dengan CSE
Wassalam
~ Bagus ~
----- Original Message -----
From: Fendi S fen...@rocketmail.com [belajar-excel]
To: belajar-excel@yahoogroups.com
Sent: Wednesday, September 03, 2014 6:47 AM
Subject: [belajar-excel] data yang sering muncul [1 Attachment]
Kepada yth, para master,
Assalamualaikum wa. wb.
Mohon memberi penjelasan bagaimana menentukan rumus modus (data yang sering
muncul.
Terima kasih.
wassalam
