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>
> .
>
  • [belajar-excel] Re: [milis-be... 'Mr. Kid' mr.nm...@gmail.com [belajar-excel]

Kirim email ke