[belajar-excel] Re: [milis-belajar-excel] Excel if

['Mr. Kid' mr.nm...@gmail.com [belajar-excel]]

bisa...
kenapa gak power query saja...

On Thu, Feb 20, 2020 at 10:20 AM Jackie Yunianto 
wrote:

> Thx u om kid,
>
> Rumus seperti ini, Apakah bisa dibuat macro juga om kid?
>
>
>
>
>
> Pada Kamis, 20 Februari 2020, Mr. Kid  menulis:
>
>> 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 
>> 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
>>> 
>>> .
>>>
>>
>
> --
> Regards,
>
>
> Jackie Yunianto
>

[belajar-excel] Re: [milis-belajar-excel] Excel if

['Mr. Kid' mr.nm...@gmail.com [belajar-excel]]

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 
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
> 
> .
>