Ya, tekan Ctrl Shift Enter nya di formula bar. Salam, HK
Sent from Samsung Mobile"'[email protected]' [email protected] [belajar-excel]" <[email protected]> wrote:Muncul sendiri, tekan tombol ctrl shift enter kan? Dikirim dari Yahoo Mail pada Android From: hendrik karnadi [email protected] [belajar-excel] <[email protected]>; To: [email protected] <[email protected]>; Subject: Re: [belajar-excel] Re: Mengetahui nilai yang muncul di sebuah range.. Sent: Fri, Jun 20, 2014 9:03:18 AM Tanda {} diketik atau muncul sendiri pak ? Salam, HK On Friday, 20 June 2014, 14:43, "[email protected] [belajar-excel]" <[email protected]> wrote: 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?
