bisa... kenapa gak power query saja... On Thu, Feb 20, 2020 at 10:20 AM Jackie Yunianto <tanfidzula...@gmail.com> wrote:
> Thx u om kid, > > Rumus seperti ini, Apakah bisa dibuat macro juga om kid? > > > > > > Pada Kamis, 20 Februari 2020, Mr. Kid <mr.nm...@gmail.com> 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 <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> >>> . >>> >> > > -- > Regards, > > > Jackie Yunianto >