Min : =Index( merk , Match( Min(harga) , harga , 0 ) ) Max : =Index( merk , Match( Max(harga) , harga , 0 ) ) tengah : > jika harga berisi unique value =Index( merk , Match( Small( harga , Ceiling( Count( harga )/2 , 1 ) ) , harga , 0 ) ) > jika harga tidak unique, pakai array formula : (pastikan entry dengan CTRL SHIFT ENTER) =Index( merk , Match( Small( IF( Frequency( harga , harga ) , harga , "" ) , Ceiling( Sum( 1*( Frequency ( harga , harga ) >0 ) ) / 2 , 1 ) ) , harga , 0 ) ) > ditengah rentang min max yang ada (tepat ditengah rentang atau tepat sebelum tengah rentang) : =Index( merk , Match( LookUp( ( Min(harga)+Max(harga) ) / 2 , Small( harga , Row( harga ) - Row( cells_header_harga ) ) ) , harga , 0 ) )
On Wed, Feb 19, 2020 at 1:04 PM Jackie Yunianto <tanfidzula...@gmail.com> wrote: > Dear all, > > Mohon dibantu untuk case berikut, rumus if nya seperti apa yang simple & > gak bikin berat. > Nyari di google yg muncul cuma rumus cari nominal nya aja > > > > > -- > Regards, > > > Jackie Yunianto > > -- > You received this message because you are subscribed to the Google Groups > "milis Belajar-Excel" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to milis-belajar-excel+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/milis-belajar-excel/CAGRAZ7hwJAC6T6GeDRdjuECw7%2BQYzz9gPoqz6Z-PRDE8kg3HkA%40mail.gmail.com > <https://groups.google.com/d/msgid/milis-belajar-excel/CAGRAZ7hwJAC6T6GeDRdjuECw7%2BQYzz9gPoqz6Z-PRDE8kg3HkA%40mail.gmail.com?utm_medium=email&utm_source=footer> > . >