Coba yang warna merah {=SMALL($A$4:$G$15,1+SUM(COUNTIF($L$3:L3,$A$4:$G$15)))}
diganti spt warna bitu {=SMALL($A$4:$G$15,1+SUM(COUNTIF($K$3:K3,$A$4:$G$15)))}
Wassalam
~ Bagus ~
----- Original Message -----
From: [email protected] [belajar-excel]
To: [email protected]
Sent: Friday, June 20, 2014 2:43 PM
Subject: [belajar-excel] Re: Mengetahui nilai yang muncul di sebuah range..
Makasih buat pak bagus dan pak hendrik
kalau rumus pak bagus
{=SMALL($A$4:$G$15,1+SUM(COUNTIF($L$3:L3,$A$4:$G$15)))}
hasilnya angka 1 semua, angka yang lain ngga tampil.
kalau rumus pak hendrik
{=LOUV(A4:G15)} hasilnya #NAME?
