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 [email protected] [belajar-excel] To: [email protected] 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
