Bls: [belajar-excel] insert row kosong
boz kid,hehe jadi malu... kenapa di 2 kolom kok jadi berhasiltp ya sudah lah ga pp, saya bisa narik 6 kolom berikutnya menggunakan id yang ada... trimakasih boz kid... br, odong nando Dari: "'Mr. Kid' mr.nm...@gmail.com [belajar-excel]" Kepada: BeExcel Dikirim: Senin, 16 April 2018 22:29 Judul: Re: [belajar-excel] insert row kosong [1 Attachment] Pakai pivot table ya... fitur pivot dalam field setting berupa opsi insert blank row blabla On Mon, Apr 16, 2018 at 7:48 PM, odong nando odongna...@yahoo.com [belajar-excel] wrote: boleh di output boz kid, jadi data yang ada cuma sebagai database yang tidak bisa berubah... br, odong nando Dari: "'Mr. Kid' mr.nm...@gmail.com [belajar-excel]" Kepada: BeExcel Dikirim: Senin, 16 April 2018 19:35 Judul: Re: [belajar-excel] insert row kosong boleh tahu untuk apa insert row kosong di sheet data ? kenapa tidak di sheet output saja ? 2018-04-16 18:54 GMT+07:00 odong nando odongna...@yahoo.com [belajar-excel] : hai rekan2 beExcel, mohon solusi menambahkan row kosong di antara data yang ada. utk lebih jelasnya mohon lihat di lampiran br, odong nando #yiv7460834960 #yiv7460834960 -- #yiv7460834960ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7460834960 #yiv7460834960ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7460834960 #yiv7460834960ygrp-mkp #yiv7460834960hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7460834960 #yiv7460834960ygrp-mkp #yiv7460834960ads {margin-bottom:10px;}#yiv7460834960 #yiv7460834960ygrp-mkp .yiv7460834960ad {padding:0 0;}#yiv7460834960 #yiv7460834960ygrp-mkp .yiv7460834960ad p {margin:0;}#yiv7460834960 #yiv7460834960ygrp-mkp .yiv7460834960ad a {color:#ff;text-decoration:none;}#yiv7460834960 #yiv7460834960ygrp-sponsor #yiv7460834960ygrp-lc {font-family:Arial;}#yiv7460834960 #yiv7460834960ygrp-sponsor #yiv7460834960ygrp-lc #yiv7460834960hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7460834960 #yiv7460834960ygrp-sponsor #yiv7460834960ygrp-lc .yiv7460834960ad {margin-bottom:10px;padding:0 0;}#yiv7460834960 #yiv7460834960actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7460834960 #yiv7460834960activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7460834960 #yiv7460834960activity span {font-weight:700;}#yiv7460834960 #yiv7460834960activity span:first-child {text-transform:uppercase;}#yiv7460834960 #yiv7460834960activity span a {color:#5085b6;text-decoration:none;}#yiv7460834960 #yiv7460834960activity span span {color:#ff7900;}#yiv7460834960 #yiv7460834960activity span .yiv7460834960underline {text-decoration:underline;}#yiv7460834960 .yiv7460834960attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7460834960 .yiv7460834960attach div a {text-decoration:none;}#yiv7460834960 .yiv7460834960attach img {border:none;padding-right:5px;}#yiv7460834960 .yiv7460834960attach label {display:block;margin-bottom:5px;}#yiv7460834960 .yiv7460834960attach label a {text-decoration:none;}#yiv7460834960 blockquote {margin:0 0 0 4px;}#yiv7460834960 .yiv7460834960bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7460834960 .yiv7460834960bold a {text-decoration:none;}#yiv7460834960 dd.yiv7460834960last p a {font-family:Verdana;font-weight:700;}#yiv7460834960 dd.yiv7460834960last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7460834960 dd.yiv7460834960last p span.yiv7460834960yshortcuts {margin-right:0;}#yiv7460834960 div.yiv7460834960attach-table div div a {text-decoration:none;}#yiv7460834960 div.yiv7460834960attach-table {width:400px;}#yiv7460834960 div.yiv7460834960file-title a, #yiv7460834960 div.yiv7460834960file-title a:active, #yiv7460834960 div.yiv7460834960file-title a:hover, #yiv7460834960 div.yiv7460834960file-title a:visited {text-decoration:none;}#yiv7460834960 div.yiv7460834960photo-title a, #yiv7460834960 div.yiv7460834960photo-title a:active, #yiv7460834960 div.yiv7460834960photo-title a:hover, #yiv7460834960 div.yiv7460834960photo-title a:visited {text-decoration:none;}#yiv7460834960 div#yiv7460834960ygrp-mlmsg #yiv7460834960ygrp-msg p a span.yiv7460834960yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7460834960 .yiv7460834960green {color:#628c2a;}#yiv7460834960 .yiv7460834960MsoNormal {margin:0 0 0 0;}#yiv7460834960 o {font-size:0;}#yiv7460834960 #yiv7460834960photos div {float:left;width:72px;}#yiv7460834960 #yiv7460834960photos div div {border:1px solid #66;min-height:62px;overflow:hidden;width:62px;}#yiv7460834960 #yiv7460834960photos div label {color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7460834960 #yiv7460834960reco-category {font-size:77%;}#yiv7460834960 #yiv7460834960reco-desc {font-size:77%
Bls: Bls: [belajar-excel] insert row kosong
trimz p gozi atas solusinya br, odong nando Dari: "ghozi alkatiri ghozialkat...@yahoo.co.id [belajar-excel]" Kepada: "odong nando odongna...@yahoo.com [belajar-excel]" Dikirim: Senin, 16 April 2018 21:16 Judul: Re: Bls: [belajar-excel] insert row kosong formula dimulai dari E3 dan F3 sedangkan untuk E2 dan F2 cukup mengcopy nilai dari A2 dan B2 formula untuk E3:=IF(E2="",INDEX($A$2:$A$40,MATCH(E1,$A$2:$A$40,0)+COUNTIF($A$2:$A$40,E1)),IF(COUNTIF(E$2:E2,E2)=COUNTIF($A$2:$A$40,E2),"",E2)) formula untuk F3:=IF(E3="","",INDEX($B$2:$B$40,SUMPRODUCT((LEN(E$2:E2)>0)*1)+1)) copy ke bawah. lihat lampiran di sheet solusi wassalam Ghozi AlkatiriPada Senin, 16 April 2018 20.04.53 GMT+7, odong nando odongna...@yahoo.com [belajar-excel] menulis: boleh di output boz kid, jadi data yang ada cuma sebagai database yang tidak bisa berubah... br, odong nando Dari: "'Mr. Kid' mr.nm...@gmail.com [belajar-excel]" Kepada: BeExcel Dikirim: Senin, 16 April 2018 19:35 Judul: Re: [belajar-excel] insert row kosong boleh tahu untuk apa insert row kosong di sheet data ? kenapa tidak di sheet output saja ? 2018-04-16 18:54 GMT+07:00 odong nando odongna...@yahoo.com [belajar-excel] : hai rekan2 beExcel, mohon solusi menambahkan row kosong di antara data yang ada. utk lebih jelasnya mohon lihat di lampiran br, odong nando #yiv6902945449 #yiv6902945449 -- #yiv6902945449ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6902945449 #yiv6902945449ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6902945449 #yiv6902945449ygrp-mkp #yiv6902945449hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv6902945449 #yiv6902945449ygrp-mkp #yiv6902945449ads {margin-bottom:10px;}#yiv6902945449 #yiv6902945449ygrp-mkp .yiv6902945449ad {padding:0 0;}#yiv6902945449 #yiv6902945449ygrp-mkp .yiv6902945449ad p {margin:0;}#yiv6902945449 #yiv6902945449ygrp-mkp .yiv6902945449ad a {color:#ff;text-decoration:none;}#yiv6902945449 #yiv6902945449ygrp-sponsor #yiv6902945449ygrp-lc {font-family:Arial;}#yiv6902945449 #yiv6902945449ygrp-sponsor #yiv6902945449ygrp-lc #yiv6902945449hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6902945449 #yiv6902945449ygrp-sponsor #yiv6902945449ygrp-lc .yiv6902945449ad {margin-bottom:10px;padding:0 0;}#yiv6902945449 #yiv6902945449actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6902945449 #yiv6902945449activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6902945449 #yiv6902945449activity span {font-weight:700;}#yiv6902945449 #yiv6902945449activity span:first-child {text-transform:uppercase;}#yiv6902945449 #yiv6902945449activity span a {color:#5085b6;text-decoration:none;}#yiv6902945449 #yiv6902945449activity span span {color:#ff7900;}#yiv6902945449 #yiv6902945449activity span .yiv6902945449underline {text-decoration:underline;}#yiv6902945449 .yiv6902945449attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv6902945449 .yiv6902945449attach div a {text-decoration:none;}#yiv6902945449 .yiv6902945449attach img {border:none;padding-right:5px;}#yiv6902945449 .yiv6902945449attach label {display:block;margin-bottom:5px;}#yiv6902945449 .yiv6902945449attach label a {text-decoration:none;}#yiv6902945449 blockquote {margin:0 0 0 4px;}#yiv6902945449 .yiv6902945449bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv6902945449 .yiv6902945449bold a {text-decoration:none;}#yiv6902945449 dd.yiv6902945449last p a {font-family:Verdana;font-weight:700;}#yiv6902945449 dd.yiv6902945449last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6902945449 dd.yiv6902945449last p span.yiv6902945449yshortcuts {margin-right:0;}#yiv6902945449 div.yiv6902945449attach-table div div a {text-decoration:none;}#yiv6902945449 div.yiv6902945449attach-table {width:400px;}#yiv6902945449 div.yiv6902945449file-title a, #yiv6902945449 div.yiv6902945449file-title a:active, #yiv6902945449 div.yiv6902945449file-title a:hover, #yiv6902945449 div.yiv6902945449file-title a:visited {text-decoration:none;}#yiv6902945449 div.yiv6902945449photo-title a, #yiv6902945449 div.yiv6902945449photo-title a:active, #yiv6902945449 div.yiv6902945449photo-title a:hover, #yiv6902945449 div.yiv6902945449photo-title a:visited {text-decoration:none;}#yiv6902945449 div#yiv6902945449ygrp-mlmsg #yiv6902945449ygrp-msg p a span.yiv6902945449yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6902945449 .yiv6902945449green {color:#628c2a;}#yiv6902945449 .yiv6902945449MsoNormal {margin:0 0 0 0;}#yiv6902945449 o {font-size:0;}#yiv6902945449 #yiv6902945449photos div {float:left;width:72px;}#yiv6902945449 #yiv6902945449photos div div {border:1px solid #66;min-height:62px;overflow:hidden;width:62px;}#yiv6902945449 #yiv6902945449photos div
Re: [belajar-excel] Mohon Dibantu untuk script Expired Date Macro
ditempat saya tidak muncul debug. bgmn dong mau masuk ke scriptnya??? Pada Senin, 16 April 2018 17.38.32 WITA, hendrik karnadi hendrikkarn...@yahoo.com [belajar-excel] menulis: Saya sdh coba buka... Waktu keluar pesan "This Wokrksheet was valid until 31/08/2009 and will be closed" klik Ok.Ketika keluar "Run-time error '91':"...klik Debug.Ganti tahun dari 2009 ke 2018, kmd klik Reset (icon kotak di bagian atas) untuk membatalkan Debug. Setelah itu tombol "Input Data" siap digunakan. Selamat mencoba Salam,HK Sent from Yahoo Mail on Android On Mon, Apr 16, 2018 at 15:25, y.ron...@yahoo.com [belajar-excel] wrote: untuk scriptnya sudah saya buat hanya saya tidak bisa buka lagi. adakah scrip ketika sudah expired maka ketika di aktifkan harus memasukkan serial sehingga bisa diaktifkan kembali? #yiv4521808571 #yiv4521808571 -- #yiv4521808571ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4521808571 #yiv4521808571ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4521808571 #yiv4521808571ygrp-mkp #yiv4521808571hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv4521808571 #yiv4521808571ygrp-mkp #yiv4521808571ads {margin-bottom:10px;}#yiv4521808571 #yiv4521808571ygrp-mkp .yiv4521808571ad {padding:0 0;}#yiv4521808571 #yiv4521808571ygrp-mkp .yiv4521808571ad p {margin:0;}#yiv4521808571 #yiv4521808571ygrp-mkp .yiv4521808571ad a {color:#ff;text-decoration:none;}#yiv4521808571 #yiv4521808571ygrp-sponsor #yiv4521808571ygrp-lc {font-family:Arial;}#yiv4521808571 #yiv4521808571ygrp-sponsor #yiv4521808571ygrp-lc #yiv4521808571hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4521808571 #yiv4521808571ygrp-sponsor #yiv4521808571ygrp-lc .yiv4521808571ad {margin-bottom:10px;padding:0 0;}#yiv4521808571 #yiv4521808571actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4521808571 #yiv4521808571activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4521808571 #yiv4521808571activity span {font-weight:700;}#yiv4521808571 #yiv4521808571activity span:first-child {text-transform:uppercase;}#yiv4521808571 #yiv4521808571activity span a {color:#5085b6;text-decoration:none;}#yiv4521808571 #yiv4521808571activity span span {color:#ff7900;}#yiv4521808571 #yiv4521808571activity span .yiv4521808571underline {text-decoration:underline;}#yiv4521808571 .yiv4521808571attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv4521808571 .yiv4521808571attach div a {text-decoration:none;}#yiv4521808571 .yiv4521808571attach img {border:none;padding-right:5px;}#yiv4521808571 .yiv4521808571attach label {display:block;margin-bottom:5px;}#yiv4521808571 .yiv4521808571attach label a {text-decoration:none;}#yiv4521808571 blockquote {margin:0 0 0 4px;}#yiv4521808571 .yiv4521808571bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv4521808571 .yiv4521808571bold a {text-decoration:none;}#yiv4521808571 dd.yiv4521808571last p a {font-family:Verdana;font-weight:700;}#yiv4521808571 dd.yiv4521808571last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4521808571 dd.yiv4521808571last p span.yiv4521808571yshortcuts {margin-right:0;}#yiv4521808571 div.yiv4521808571attach-table div div a {text-decoration:none;}#yiv4521808571 div.yiv4521808571attach-table {width:400px;}#yiv4521808571 div.yiv4521808571file-title a, #yiv4521808571 div.yiv4521808571file-title a:active, #yiv4521808571 div.yiv4521808571file-title a:hover, #yiv4521808571 div.yiv4521808571file-title a:visited {text-decoration:none;}#yiv4521808571 div.yiv4521808571photo-title a, #yiv4521808571 div.yiv4521808571photo-title a:active, #yiv4521808571 div.yiv4521808571photo-title a:hover, #yiv4521808571 div.yiv4521808571photo-title a:visited {text-decoration:none;}#yiv4521808571 div#yiv4521808571ygrp-mlmsg #yiv4521808571ygrp-msg p a span.yiv4521808571yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4521808571 .yiv4521808571green {color:#628c2a;}#yiv4521808571 .yiv4521808571MsoNormal {margin:0 0 0 0;}#yiv4521808571 o {font-size:0;}#yiv4521808571 #yiv4521808571photos div {float:left;width:72px;}#yiv4521808571 #yiv4521808571photos div div {border:1px solid #66;min-height:62px;overflow:hidden;width:62px;}#yiv4521808571 #yiv4521808571photos div label {color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4521808571 #yiv4521808571reco-category {font-size:77%;}#yiv4521808571 #yiv4521808571reco-desc {font-size:77%;}#yiv4521808571 .yiv4521808571replbq {margin:4px;}#yiv4521808571 #yiv4521808571ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv4521808571 #yiv4521808571ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4521808571 #yiv4521808571ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4521808571 #yiv4521808571y
RE: RE: [belajar-excel] MEMBUAT LIST DARI RANGE
Makasih pak HK. Ade *From:* belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com] *Sent:* Saturday, April 14, 2018 4:14 PM *To:* 'M.Ade Alfarid' q...@kkmi.co.id [belajar-excel] *Subject:* Re: RE: [belajar-excel] MEMBUAT LIST DARI RANGE Sebagai alternatif...*Listnya* *bisa* *pakai UDF (User Defined Function) mbak Siti* *yang bernama LOUV (**List of Unique Values*). UDF nya spt ini: Function LOUV(D As Range) '- ' membuat daftar unique value (sorted) berdasarkan range data ' coded by siti Vi / feb2006, di bluewater /recoded: 1jul2007, di jkt '- Dim A(), x(), v, n As Integer, p As Integer, q As Integer, r As Integer ReDim A(1 To D.Cells.Count) For n = 1 To UBound(A): A(n) = D.Cells(n): Next n For n = 1 To UBound(A) - 1 For q = UBound(A) To n + 1 Step -1 p = q - 1 If A(p) > A(q) Then v = A(p): A(p) = A(q): A(q) = v Else If A(p) = A(q) Then A(q) = "" End If Next q Next n For n = 1 To UBound(A) If Not A(n) = "" Then r = r + 1: ReDim Preserve x(1 To r): x(r) = A(n) End If Next n LOUV = WorksheetFunction.Transpose(x) End Function UDF nya bisa dibuat di module dan filenya disimpan sebagai file berMacro (.xlsm) atau Binary file (.xlsb) atau UDFnya disimpan tersendiri sebagai file Add-Ins (.xla), kemudian Fungsi LOUV diaktifkan melalui Add-Ins (Buka Add-Ins, Browse dan cari file (.xla) nya). Jumlahnya bilangan cacahnya tetap pakai Fungsi CountIf. Salam, HK On Friday, 13 April 2018, 4:20:25 PM GMT+7, 'M.Ade Alfarid' q...@kkmi.co.id [belajar-excel] wrote: Kalo formula jadinya panjang buanget atau ribet Mr Kid? *From:* belajar-ex...@yahoogroups..com [mailto:belajar-excel@yahoogroups.com] *Sent:* Friday, April 13, 2018 2:41 PM *To:* BeExcel *Subject:* Re: [belajar-excel] MEMBUAT LIST DARI RANGE Hai Ade, Tambahkan 1 kolom dikiri data, isi dengan nilai yang sama di seluruh barisnya, seperti 'Kid' Setelah itu manfaatkan pivot consolidation seperti yang ada diposting beberapa waktu lalu yang ada disini : https://groups.yahoo.com/neo/groups/belajar-excel/conversations/messages/44099 Regards, Kid 2018-04-13 8:49 GMT+07:00 'M.Ade Alfarid' q...@kkmi.co.id [belajar-excel] < belajar-excel@yahoogroups.com>: Dear, Jika ada record data dari A3:T20 dan hendak dibuat list nya, dengan menggunakan formula seperti apa? Sudah coba index tapi gak bisa, kriteria multi kolom begini, mohon solusi. Terlampir file excelnya. Contoh: [image: cid:image001.png@01D3D263.A57219F0] Terimakasih, Ade
RE: [belajar-excel] MEMBUAT LIST DARI RANGE
Makasih Mr Kid, Saya masih g mudeng dengan array dan logika membentuknya hehehehe.. Makanya saya tanya formulanya biar bisa belajar. Ade *From:* belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com] *Sent:* Saturday, April 14, 2018 6:03 AM *To:* BeExcel *Subject:* Re: [belajar-excel] MEMBUAT LIST DARI RANGE Tidak terlalu panjang dan tidak juga ribet. Hanya saja berpotensi memperlambat kerja karena luasan array yang diproses 2018-04-13 16:15 GMT+07:00 'M.Ade Alfarid' q...@kkmi.co.id [belajar-excel] < belajar-excel@yahoogroups.com>: Kalo formula jadinya panjang buanget atau ribet Mr Kid? *From:* belajar-ex...@yahoogroups..com [mailto:belajar-excel@yahoogroups.com] *Sent:* Friday, April 13, 2018 2:41 PM *To:* BeExcel *Subject:* Re: [belajar-excel] MEMBUAT LIST DARI RANGE Hai Ade, Tambahkan 1 kolom dikiri data, isi dengan nilai yang sama di seluruh barisnya, seperti 'Kid' Setelah itu manfaatkan pivot consolidation seperti yang ada diposting beberapa waktu lalu yang ada disini : https://groups.yahoo.com/neo/groups/belajar-excel/conversations/messages/44099 Regards, Kid 2018-04-13 8:49 GMT+07:00 'M.Ade Alfarid' q...@kkmi.co.id [belajar-excel] < belajar-excel@yahoogroups.com>: Dear, Jika ada record data dari A3:T20 dan hendak dibuat list nya, dengan menggunakan formula seperti apa? Sudah coba index tapi gak bisa, kriteria multi kolom begini, mohon solusi. Terlampir file excelnya. Contoh: [image: cid:image001.png@01D3D263.A57219F0] Terimakasih, Ade
Re: [belajar-excel] insert row kosong [1 Attachment]
Pakai pivot table ya... fitur pivot dalam field setting berupa opsi insert blank row blabla On Mon, Apr 16, 2018 at 7:48 PM, odong nando odongna...@yahoo.com [belajar-excel] wrote: > > > boleh di output boz kid, jadi data yang ada cuma sebagai database yang > tidak bisa berubah... > > br, > > odong nando > > > -- > *Dari:* "'Mr. Kid' mr.nm...@gmail.com [belajar-excel]" < > belajar-excel@yahoogroups.com> > *Kepada:* BeExcel > *Dikirim:* Senin, 16 April 2018 19:35 > *Judul:* Re: [belajar-excel] insert row kosong > > > boleh tahu untuk apa insert row kosong di sheet data ? > kenapa tidak di sheet output saja ? > > > 2018-04-16 18:54 GMT+07:00 odong nando odongna...@yahoo.com > [belajar-excel] : > > > hai rekan2 beExcel, > > mohon solusi menambahkan row kosong di antara data yang ada. > > utk lebih jelasnya mohon lihat di lampiran > > > br, > > odong nando > > > > > > re-insert row jika beda.xlsx Description: MS-Excel 2007 spreadsheet
Re: Bls: [belajar-excel] insert row kosong
formula dimulai dari E3 dan F3 sedangkan untuk E2 dan F2 cukup mengcopy nilai dari A2 dan B2 formula untuk E3:=IF(E2="",INDEX($A$2:$A$40,MATCH(E1,$A$2:$A$40,0)+COUNTIF($A$2:$A$40,E1)),IF(COUNTIF(E$2:E2,E2)=COUNTIF($A$2:$A$40,E2),"",E2)) formula untuk F3:=IF(E3="","",INDEX($B$2:$B$40,SUMPRODUCT((LEN(E$2:E2)>0)*1)+1)) copy ke bawah. lihat lampiran di sheet solusi wassalam Ghozi AlkatiriPada Senin, 16 April 2018 20.04.53 GMT+7, odong nando odongna...@yahoo.com [belajar-excel] menulis: boleh di output boz kid, jadi data yang ada cuma sebagai database yang tidak bisa berubah... br, odong nando Dari: "'Mr. Kid' mr.nm...@gmail.com [belajar-excel]" Kepada: BeExcel Dikirim: Senin, 16 April 2018 19:35 Judul: Re: [belajar-excel] insert row kosong boleh tahu untuk apa insert row kosong di sheet data ? kenapa tidak di sheet output saja ? 2018-04-16 18:54 GMT+07:00 odong nando odongna...@yahoo.com [belajar-excel] : hai rekan2 beExcel, mohon solusi menambahkan row kosong di antara data yang ada. utk lebih jelasnya mohon lihat di lampiran br, odong nando #yiv7405091748 #yiv7405091748 -- #yiv7405091748ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7405091748 #yiv7405091748ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7405091748 #yiv7405091748ygrp-mkp #yiv7405091748hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7405091748 #yiv7405091748ygrp-mkp #yiv7405091748ads {margin-bottom:10px;}#yiv7405091748 #yiv7405091748ygrp-mkp ..yiv7405091748ad {padding:0 0;}#yiv7405091748 #yiv7405091748ygrp-mkp .yiv7405091748ad p {margin:0;}#yiv7405091748 #yiv7405091748ygrp-mkp .yiv7405091748ad a {color:#ff;text-decoration:none;}#yiv7405091748 #yiv7405091748ygrp-sponsor #yiv7405091748ygrp-lc {font-family:Arial;}#yiv7405091748 #yiv7405091748ygrp-sponsor #yiv7405091748ygrp-lc #yiv7405091748hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7405091748 #yiv7405091748ygrp-sponsor #yiv7405091748ygrp-lc .yiv7405091748ad {margin-bottom:10px;padding:0 0;}#yiv7405091748 #yiv7405091748actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7405091748 #yiv7405091748activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7405091748 #yiv7405091748activity span {font-weight:700;}#yiv7405091748 #yiv7405091748activity span:first-child {text-transform:uppercase;}#yiv7405091748 #yiv7405091748activity span a {color:#5085b6;text-decoration:none;}#yiv7405091748 #yiv7405091748activity span span {color:#ff7900;}#yiv7405091748 #yiv7405091748activity span .yiv7405091748underline {text-decoration:underline;}#yiv7405091748 .yiv7405091748attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7405091748 .yiv7405091748attach div a {text-decoration:none;}#yiv7405091748 .yiv7405091748attach img {border:none;padding-right:5px;}#yiv7405091748 .yiv7405091748attach label {display:block;margin-bottom:5px;}#yiv7405091748 .yiv7405091748attach label a {text-decoration:none;}#yiv7405091748 blockquote {margin:0 0 0 4px;}#yiv7405091748 .yiv7405091748bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7405091748 .yiv7405091748bold a {text-decoration:none;}#yiv7405091748 dd.yiv7405091748last p a {font-family:Verdana;font-weight:700;}#yiv7405091748 dd.yiv7405091748last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7405091748 dd.yiv7405091748last p span.yiv7405091748yshortcuts {margin-right:0;}#yiv7405091748 div.yiv7405091748attach-table div div a {text-decoration:none;}#yiv7405091748 div.yiv7405091748attach-table {width:400px;}#yiv7405091748 div.yiv7405091748file-title a, #yiv7405091748 div.yiv7405091748file-title a:active, #yiv7405091748 div.yiv7405091748file-title a:hover, #yiv7405091748 div.yiv7405091748file-title a:visited {text-decoration:none;}#yiv7405091748 div.yiv7405091748photo-title a, #yiv7405091748 div.yiv7405091748photo-title a:active, #yiv7405091748 div.yiv7405091748photo-title a:hover, #yiv7405091748 div.yiv7405091748photo-title a:visited {text-decoration:none;}#yiv7405091748 div#yiv7405091748ygrp-mlmsg #yiv7405091748ygrp-msg p a span.yiv7405091748yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7405091748 .yiv7405091748green {color:#628c2a;}#yiv7405091748 .yiv7405091748MsoNormal {margin:0 0 0 0;}#yiv7405091748 o {font-size:0;}#yiv7405091748 #yiv7405091748photos div {float:left;width:72px;}#yiv7405091748 #yiv7405091748photos div div {border:1px solid #66;min-height:62px;overflow:hidden;width:62px;}#yiv7405091748 #yiv7405091748photos div label {color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7405091748 #yiv7405091748reco-category {font-size:77%;}#yiv7405091748 #yiv7405091748reco-desc {font-size:77%;}#yiv7405091748 .yiv7405091748replbq {margin:4px;}#yiv7405091
Bls: [belajar-excel] insert row kosong
boleh di output boz kid, jadi data yang ada cuma sebagai database yang tidak bisa berubah... br, odong nando Dari: "'Mr. Kid' mr.nm...@gmail.com [belajar-excel]" Kepada: BeExcel Dikirim: Senin, 16 April 2018 19:35 Judul: Re: [belajar-excel] insert row kosong boleh tahu untuk apa insert row kosong di sheet data ? kenapa tidak di sheet output saja ? 2018-04-16 18:54 GMT+07:00 odong nando odongna...@yahoo.com [belajar-excel] : hai rekan2 beExcel, mohon solusi menambahkan row kosong di antara data yang ada. utk lebih jelasnya mohon lihat di lampiran br, odong nando #yiv6580020930 #yiv6580020930 -- #yiv6580020930ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6580020930 #yiv6580020930ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6580020930 #yiv6580020930ygrp-mkp #yiv6580020930hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv6580020930 #yiv6580020930ygrp-mkp #yiv6580020930ads {margin-bottom:10px;}#yiv6580020930 #yiv6580020930ygrp-mkp .yiv6580020930ad {padding:0 0;}#yiv6580020930 #yiv6580020930ygrp-mkp .yiv6580020930ad p {margin:0;}#yiv6580020930 #yiv6580020930ygrp-mkp .yiv6580020930ad a {color:#ff;text-decoration:none;}#yiv6580020930 #yiv6580020930ygrp-sponsor #yiv6580020930ygrp-lc {font-family:Arial;}#yiv6580020930 #yiv6580020930ygrp-sponsor #yiv6580020930ygrp-lc #yiv6580020930hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6580020930 #yiv6580020930ygrp-sponsor #yiv6580020930ygrp-lc .yiv6580020930ad {margin-bottom:10px;padding:0 0;}#yiv6580020930 #yiv6580020930actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6580020930 #yiv6580020930activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6580020930 #yiv6580020930activity span {font-weight:700;}#yiv6580020930 #yiv6580020930activity span:first-child {text-transform:uppercase;}#yiv6580020930 #yiv6580020930activity span a {color:#5085b6;text-decoration:none;}#yiv6580020930 #yiv6580020930activity span span {color:#ff7900;}#yiv6580020930 #yiv6580020930activity span .yiv6580020930underline {text-decoration:underline;}#yiv6580020930 .yiv6580020930attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv6580020930 .yiv6580020930attach div a {text-decoration:none;}#yiv6580020930 .yiv6580020930attach img {border:none;padding-right:5px;}#yiv6580020930 .yiv6580020930attach label {display:block;margin-bottom:5px;}#yiv6580020930 .yiv6580020930attach label a {text-decoration:none;}#yiv6580020930 blockquote {margin:0 0 0 4px;}#yiv6580020930 .yiv6580020930bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv6580020930 .yiv6580020930bold a {text-decoration:none;}#yiv6580020930 dd.yiv6580020930last p a {font-family:Verdana;font-weight:700;}#yiv6580020930 dd.yiv6580020930last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6580020930 dd.yiv6580020930last p span.yiv6580020930yshortcuts {margin-right:0;}#yiv6580020930 div.yiv6580020930attach-table div div a {text-decoration:none;}#yiv6580020930 div.yiv6580020930attach-table {width:400px;}#yiv6580020930 div.yiv6580020930file-title a, #yiv6580020930 div.yiv6580020930file-title a:active, #yiv6580020930 div.yiv6580020930file-title a:hover, #yiv6580020930 div.yiv6580020930file-title a:visited {text-decoration:none;}#yiv6580020930 div.yiv6580020930photo-title a, #yiv6580020930 div.yiv6580020930photo-title a:active, #yiv6580020930 div.yiv6580020930photo-title a:hover, #yiv6580020930 div.yiv6580020930photo-title a:visited {text-decoration:none;}#yiv6580020930 div#yiv6580020930ygrp-mlmsg #yiv6580020930ygrp-msg p a span.yiv6580020930yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6580020930 .yiv6580020930green {color:#628c2a;}#yiv6580020930 .yiv6580020930MsoNormal {margin:0 0 0 0;}#yiv6580020930 o {font-size:0;}#yiv6580020930 #yiv6580020930photos div {float:left;width:72px;}#yiv6580020930 #yiv6580020930photos div div {border:1px solid #66;min-height:62px;overflow:hidden;width:62px;}#yiv6580020930 #yiv6580020930photos div label {color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6580020930 #yiv6580020930reco-category {font-size:77%;}#yiv6580020930 #yiv6580020930reco-desc {font-size:77%;}#yiv6580020930 .yiv6580020930replbq {margin:4px;}#yiv6580020930 #yiv6580020930ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv6580020930 #yiv6580020930ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6580020930 #yiv6580020930ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6580020930 #yiv6580020930ygrp-mlmsg select, #yiv6580020930 input, #yiv6580020930 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv6580020930 #yiv6580020930ygrp-mlmsg pre, #yiv6580020930 code {font:115% monospace;}#yiv6580020930 #
Re: [belajar-excel] insert row kosong
boleh tahu untuk apa insert row kosong di sheet data ? kenapa tidak di sheet output saja ? 2018-04-16 18:54 GMT+07:00 odong nando odongna...@yahoo.com [belajar-excel] : > > > hai rekan2 beExcel, > > mohon solusi menambahkan row kosong di antara data yang ada. > > utk lebih jelasnya mohon lihat di lampiran > > > br, > > odong nando > > >
[belajar-excel] insert row kosong
hai rekan2 beExcel, mohon solusi menambahkan row kosong di antara data yang ada. utk lebih jelasnya mohon lihat di lampiran br, odong nando insert row jika beda.xlsx Description: MS-Excel 2007 spreadsheet
Re: Bls: [belajar-excel] Menghitung rata-rata dimulai saat muncul angka pertama
kalau menurut aku mungkin formula ini yang lebih tepat silahkan dicoba (formula array) =AVERAGE(OFFSET($A5,0,MIN(IF($A5:$L5>0,COLUMN(A:L)))-1,,(MAX(IF($A5:$L5>0,13-COLUMN(A:L)) wassalam Ghozi AlkatiriPada Senin, 16 April 2018 15.10.12 GMT+7, Toby kenzo tobyke...@yahoo.co.id [belajar-excel] menulis: Sorry, bukan Ctrl + Alt + Enter tapi Ctrl + Shift + Enter. Terimakasih. Pada Senin, 16 April 2018 13:32, "akh_iyang akh_iy...@yahoo.co.id [belajar-excel]" menulis: Dear master excel, Mohon bantuannya untuk menghitung rata-rata sesuai kondisi File terlampir. Thanks #yiv6921027248 #yiv6921027248 -- #yiv6921027248ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6921027248 #yiv6921027248ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6921027248 #yiv6921027248ygrp-mkp #yiv6921027248hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv6921027248 #yiv6921027248ygrp-mkp #yiv6921027248ads {margin-bottom:10px;}#yiv6921027248 #yiv6921027248ygrp-mkp ..yiv6921027248ad {padding:0 0;}#yiv6921027248 #yiv6921027248ygrp-mkp .yiv6921027248ad p {margin:0;}#yiv6921027248 #yiv6921027248ygrp-mkp .yiv6921027248ad a {color:#ff;text-decoration:none;}#yiv6921027248 #yiv6921027248ygrp-sponsor #yiv6921027248ygrp-lc {font-family:Arial;}#yiv6921027248 #yiv6921027248ygrp-sponsor #yiv6921027248ygrp-lc #yiv6921027248hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6921027248 #yiv6921027248ygrp-sponsor #yiv6921027248ygrp-lc .yiv6921027248ad {margin-bottom:10px;padding:0 0;}#yiv6921027248 #yiv6921027248actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6921027248 #yiv6921027248activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6921027248 #yiv6921027248activity span {font-weight:700;}#yiv6921027248 #yiv6921027248activity span:first-child {text-transform:uppercase;}#yiv6921027248 #yiv6921027248activity span a {color:#5085b6;text-decoration:none;}#yiv6921027248 #yiv6921027248activity span span {color:#ff7900;}#yiv6921027248 #yiv6921027248activity span .yiv6921027248underline {text-decoration:underline;}#yiv6921027248 .yiv6921027248attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv6921027248 .yiv6921027248attach div a {text-decoration:none;}#yiv6921027248 .yiv6921027248attach img {border:none;padding-right:5px;}#yiv6921027248 .yiv6921027248attach label {display:block;margin-bottom:5px;}#yiv6921027248 .yiv6921027248attach label a {text-decoration:none;}#yiv6921027248 blockquote {margin:0 0 0 4px;}#yiv6921027248 .yiv6921027248bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv6921027248 .yiv6921027248bold a {text-decoration:none;}#yiv6921027248 dd.yiv6921027248last p a {font-family:Verdana;font-weight:700;}#yiv6921027248 dd.yiv6921027248last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6921027248 dd.yiv6921027248last p span.yiv6921027248yshortcuts {margin-right:0;}#yiv6921027248 div.yiv6921027248attach-table div div a {text-decoration:none;}#yiv6921027248 div.yiv6921027248attach-table {width:400px;}#yiv6921027248 div.yiv6921027248file-title a, #yiv6921027248 div.yiv6921027248file-title a:active, #yiv6921027248 div.yiv6921027248file-title a:hover, #yiv6921027248 div.yiv6921027248file-title a:visited {text-decoration:none;}#yiv6921027248 div.yiv6921027248photo-title a, #yiv6921027248 div.yiv6921027248photo-title a:active, #yiv6921027248 div.yiv6921027248photo-title a:hover, #yiv6921027248 div.yiv6921027248photo-title a:visited {text-decoration:none;}#yiv6921027248 div#yiv6921027248ygrp-mlmsg #yiv6921027248ygrp-msg p a span.yiv6921027248yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6921027248 .yiv6921027248green {color:#628c2a;}#yiv6921027248 .yiv6921027248MsoNormal {margin:0 0 0 0;}#yiv6921027248 o {font-size:0;}#yiv6921027248 #yiv6921027248photos div {float:left;width:72px;}#yiv6921027248 #yiv6921027248photos div div {border:1px solid #66;min-height:62px;overflow:hidden;width:62px;}#yiv6921027248 #yiv6921027248photos div label {color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6921027248 #yiv6921027248reco-category {font-size:77%;}#yiv6921027248 #yiv6921027248reco-desc {font-size:77%;}#yiv6921027248 .yiv6921027248replbq {margin:4px;}#yiv6921027248 #yiv6921027248ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv6921027248 #yiv6921027248ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6921027248 #yiv6921027248ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6921027248 #yiv6921027248ygrp-mlmsg select, #yiv6921027248 input, #yiv6921027248 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv6921027248 #yiv6921027248ygrp-mlmsg pre, #yiv6921027248 code {font:115% monospace;}#yiv69210272
Re: [belajar-excel] Mohon Dibantu untuk script Expired Date Macro
Saya sdh coba buka...Waktu keluar pesan "This Wokrksheet was valid until 31/08/2009 and will be closed" klik Ok.Ketika keluar "Run-time error '91':"klik Debug.Ganti tahun dari 2009 ke 2018, kmd klik Reset (icon kotak di bagian atas) untuk membatalkan Debug. Setelah itu tombol "Input Data" siap digunakan. Selamat mencoba Salam,HK Sent from Yahoo Mail on Android On Mon, Apr 16, 2018 at 15:25, y.ron...@yahoo.com [belajar-excel] wrote: untuk scriptnya sudah saya buat hanya saya tidak bisa buka lagi. adakah scrip ketika sudah expired maka ketika di aktifkan harus memasukkan serial sehingga bisa diaktifkan kembali? #yiv2770713700 #yiv2770713700 -- #yiv2770713700ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2770713700 #yiv2770713700ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2770713700 #yiv2770713700ygrp-mkp #yiv2770713700hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2770713700 #yiv2770713700ygrp-mkp #yiv2770713700ads {margin-bottom:10px;}#yiv2770713700 #yiv2770713700ygrp-mkp .yiv2770713700ad {padding:0 0;}#yiv2770713700 #yiv2770713700ygrp-mkp .yiv2770713700ad p {margin:0;}#yiv2770713700 #yiv2770713700ygrp-mkp .yiv2770713700ad a {color:#ff;text-decoration:none;}#yiv2770713700 #yiv2770713700ygrp-sponsor #yiv2770713700ygrp-lc {font-family:Arial;}#yiv2770713700 #yiv2770713700ygrp-sponsor #yiv2770713700ygrp-lc #yiv2770713700hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2770713700 #yiv2770713700ygrp-sponsor #yiv2770713700ygrp-lc .yiv2770713700ad {margin-bottom:10px;padding:0 0;}#yiv2770713700 #yiv2770713700actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2770713700 #yiv2770713700activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2770713700 #yiv2770713700activity span {font-weight:700;}#yiv2770713700 #yiv2770713700activity span:first-child {text-transform:uppercase;}#yiv2770713700 #yiv2770713700activity span a {color:#5085b6;text-decoration:none;}#yiv2770713700 #yiv2770713700activity span span {color:#ff7900;}#yiv2770713700 #yiv2770713700activity span .yiv2770713700underline {text-decoration:underline;}#yiv2770713700 .yiv2770713700attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2770713700 .yiv2770713700attach div a {text-decoration:none;}#yiv2770713700 .yiv2770713700attach img {border:none;padding-right:5px;}#yiv2770713700 .yiv2770713700attach label {display:block;margin-bottom:5px;}#yiv2770713700 .yiv2770713700attach label a {text-decoration:none;}#yiv2770713700 blockquote {margin:0 0 0 4px;}#yiv2770713700 .yiv2770713700bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2770713700 .yiv2770713700bold a {text-decoration:none;}#yiv2770713700 dd.yiv2770713700last p a {font-family:Verdana;font-weight:700;}#yiv2770713700 dd.yiv2770713700last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2770713700 dd.yiv2770713700last p span.yiv2770713700yshortcuts {margin-right:0;}#yiv2770713700 div.yiv2770713700attach-table div div a {text-decoration:none;}#yiv2770713700 div.yiv2770713700attach-table {width:400px;}#yiv2770713700 div.yiv2770713700file-title a, #yiv2770713700 div.yiv2770713700file-title a:active, #yiv2770713700 div.yiv2770713700file-title a:hover, #yiv2770713700 div.yiv2770713700file-title a:visited {text-decoration:none;}#yiv2770713700 div.yiv2770713700photo-title a, #yiv2770713700 div.yiv2770713700photo-title a:active, #yiv2770713700 div.yiv2770713700photo-title a:hover, #yiv2770713700 div.yiv2770713700photo-title a:visited {text-decoration:none;}#yiv2770713700 div#yiv2770713700ygrp-mlmsg #yiv2770713700ygrp-msg p a span.yiv2770713700yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2770713700 .yiv2770713700green {color:#628c2a;}#yiv2770713700 .yiv2770713700MsoNormal {margin:0 0 0 0;}#yiv2770713700 o {font-size:0;}#yiv2770713700 #yiv2770713700photos div {float:left;width:72px;}#yiv2770713700 #yiv2770713700photos div div {border:1px solid #66;min-height:62px;overflow:hidden;width:62px;}#yiv2770713700 #yiv2770713700photos div label {color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2770713700 #yiv2770713700reco-category {font-size:77%;}#yiv2770713700 #yiv2770713700reco-desc {font-size:77%;}#yiv2770713700 .yiv2770713700replbq {margin:4px;}#yiv2770713700 #yiv2770713700ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2770713700 #yiv2770713700ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2770713700 #yiv2770713700ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2770713700 #yiv2770713700ygrp-mlmsg select, #yiv2770713700 input, #yiv2770713700 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2770713700 #yiv2770713700ygrp-mlmsg pre, #yiv2770713700 code {font:11
Re: [belajar-excel] Mohon Dibantu untuk script Expired Date Macro [1 Attachment]
untuk scriptnya sudah saya buat hanya saya tidak bisa buka lagi. adakah scrip ketika sudah expired maka ketika di aktifkan harus memasukkan serial sehingga bisa diaktifkan kembali? Test.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Bls: [belajar-excel] Menghitung rata-rata dimulai saat muncul angka pertama
Sorry, bukan Ctrl + Alt + Enter tapi Ctrl + Shift + Enter. Terimakasih. Pada Senin, 16 April 2018 13:32, "akh_iyang akh_iy...@yahoo.co.id [belajar-excel]" menulis: Dear master excel, Mohon bantuannya untuk menghitung rata-rata sesuai kondisi File terlampir. Thanks #yiv0452551377 #yiv0452551377 -- #yiv0452551377ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0452551377 #yiv0452551377ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0452551377 #yiv0452551377ygrp-mkp #yiv0452551377hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0452551377 #yiv0452551377ygrp-mkp #yiv0452551377ads {margin-bottom:10px;}#yiv0452551377 #yiv0452551377ygrp-mkp .yiv0452551377ad {padding:0 0;}#yiv0452551377 #yiv0452551377ygrp-mkp .yiv0452551377ad p {margin:0;}#yiv0452551377 #yiv0452551377ygrp-mkp .yiv0452551377ad a {color:#ff;text-decoration:none;}#yiv0452551377 #yiv0452551377ygrp-sponsor #yiv0452551377ygrp-lc {font-family:Arial;}#yiv0452551377 #yiv0452551377ygrp-sponsor #yiv0452551377ygrp-lc #yiv0452551377hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0452551377 #yiv0452551377ygrp-sponsor #yiv0452551377ygrp-lc .yiv0452551377ad {margin-bottom:10px;padding:0 0;}#yiv0452551377 #yiv0452551377actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0452551377 #yiv0452551377activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0452551377 #yiv0452551377activity span {font-weight:700;}#yiv0452551377 #yiv0452551377activity span:first-child {text-transform:uppercase;}#yiv0452551377 #yiv0452551377activity span a {color:#5085b6;text-decoration:none;}#yiv0452551377 #yiv0452551377activity span span {color:#ff7900;}#yiv0452551377 #yiv0452551377activity span .yiv0452551377underline {text-decoration:underline;}#yiv0452551377 .yiv0452551377attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0452551377 ..yiv0452551377attach div a {text-decoration:none;}#yiv0452551377 .yiv0452551377attach img {border:none;padding-right:5px;}#yiv0452551377 .yiv0452551377attach label {display:block;margin-bottom:5px;}#yiv0452551377 .yiv0452551377attach label a {text-decoration:none;}#yiv0452551377 blockquote {margin:0 0 0 4px;}#yiv0452551377 .yiv0452551377bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0452551377 .yiv0452551377bold a {text-decoration:none;}#yiv0452551377 dd.yiv0452551377last p a {font-family:Verdana;font-weight:700;}#yiv0452551377 dd.yiv0452551377last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0452551377 dd.yiv0452551377last p span.yiv0452551377yshortcuts {margin-right:0;}#yiv0452551377 div.yiv0452551377attach-table div div a {text-decoration:none;}#yiv0452551377 div.yiv0452551377attach-table {width:400px;}#yiv0452551377 div.yiv0452551377file-title a, #yiv0452551377 div.yiv0452551377file-title a:active, #yiv0452551377 div.yiv0452551377file-title a:hover, #yiv0452551377 div.yiv0452551377file-title a:visited {text-decoration:none;}#yiv0452551377 div.yiv0452551377photo-title a, #yiv0452551377 div.yiv0452551377photo-title a:active, #yiv0452551377 div.yiv0452551377photo-title a:hover, #yiv0452551377 div.yiv0452551377photo-title a:visited {text-decoration:none;}#yiv0452551377 div#yiv0452551377ygrp-mlmsg #yiv0452551377ygrp-msg p a span.yiv0452551377yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0452551377 .yiv0452551377green {color:#628c2a;}#yiv0452551377 .yiv0452551377MsoNormal {margin:0 0 0 0;}#yiv0452551377 o {font-size:0;}#yiv0452551377 #yiv0452551377photos div {float:left;width:72px;}#yiv0452551377 #yiv0452551377photos div div {border:1px solid #66;min-height:62px;overflow:hidden;width:62px;}#yiv0452551377 #yiv0452551377photos div label {color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0452551377 #yiv0452551377reco-category {font-size:77%;}#yiv0452551377 #yiv0452551377reco-desc {font-size:77%;}#yiv0452551377 .yiv0452551377replbq {margin:4px;}#yiv0452551377 #yiv0452551377ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0452551377 #yiv0452551377ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0452551377 #yiv0452551377ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0452551377 #yiv0452551377ygrp-mlmsg select, #yiv0452551377 input, #yiv0452551377 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0452551377 #yiv0452551377ygrp-mlmsg pre, #yiv0452551377 code {font:115% monospace;}#yiv0452551377 #yiv0452551377ygrp-mlmsg * {line-height:1.22em;}#yiv0452551377 #yiv0452551377ygrp-mlmsg #yiv0452551377logo {padding-bottom:10px;}#yiv0452551377 #yiv0452551377ygrp-msg p a {font-family:Verdana;}#yiv0452551377 #yiv0452551377ygrp-msg p#yiv0452551377attach-count span {color:#1E66AE;font-weight:700;}#yiv0452551377 #yiv04525513
Bls: [belajar-excel] Menghitung rata-rata dimulai saat muncul angka pertama
Masukan formula berikut di N5 =(SUM(A5:L5) / INDEX(A5:L5,MATCH(INDEX(A$4:L$4,MATCH(TRUE,INDEX(A5:L5<>0,),0)),A4:L4,0))) Karena Array formula jangan lupa ketik Ctrl + Alt + Enter TerimaKasih Pada Senin, 16 April 2018 13:32, "akh_iyang akh_iy...@yahoo.co.id [belajar-excel]" menulis: Dear master excel, Mohon bantuannya untuk menghitung rata-rata sesuai kondisi File terlampir. Thanks #yiv4001524055 #yiv4001524055 -- #yiv4001524055ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4001524055 #yiv4001524055ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4001524055 #yiv4001524055ygrp-mkp #yiv4001524055hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv4001524055 #yiv4001524055ygrp-mkp #yiv4001524055ads {margin-bottom:10px;}#yiv4001524055 #yiv4001524055ygrp-mkp .yiv4001524055ad {padding:0 0;}#yiv4001524055 #yiv4001524055ygrp-mkp .yiv4001524055ad p {margin:0;}#yiv4001524055 #yiv4001524055ygrp-mkp .yiv4001524055ad a {color:#ff;text-decoration:none;}#yiv4001524055 #yiv4001524055ygrp-sponsor #yiv4001524055ygrp-lc {font-family:Arial;}#yiv4001524055 #yiv4001524055ygrp-sponsor #yiv4001524055ygrp-lc #yiv4001524055hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4001524055 #yiv4001524055ygrp-sponsor #yiv4001524055ygrp-lc .yiv4001524055ad {margin-bottom:10px;padding:0 0;}#yiv4001524055 #yiv4001524055actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4001524055 #yiv4001524055activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4001524055 #yiv4001524055activity span {font-weight:700;}#yiv4001524055 #yiv4001524055activity span:first-child {text-transform:uppercase;}#yiv4001524055 #yiv4001524055activity span a {color:#5085b6;text-decoration:none;}#yiv4001524055 #yiv4001524055activity span span {color:#ff7900;}#yiv4001524055 #yiv4001524055activity span .yiv4001524055underline {text-decoration:underline;}#yiv4001524055 .yiv4001524055attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv4001524055 ..yiv4001524055attach div a {text-decoration:none;}#yiv4001524055 .yiv4001524055attach img {border:none;padding-right:5px;}#yiv4001524055 .yiv4001524055attach label {display:block;margin-bottom:5px;}#yiv4001524055 .yiv4001524055attach label a {text-decoration:none;}#yiv4001524055 blockquote {margin:0 0 0 4px;}#yiv4001524055 .yiv4001524055bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv4001524055 .yiv4001524055bold a {text-decoration:none;}#yiv4001524055 dd.yiv4001524055last p a {font-family:Verdana;font-weight:700;}#yiv4001524055 dd.yiv4001524055last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4001524055 dd.yiv4001524055last p span.yiv4001524055yshortcuts {margin-right:0;}#yiv4001524055 div.yiv4001524055attach-table div div a {text-decoration:none;}#yiv4001524055 div.yiv4001524055attach-table {width:400px;}#yiv4001524055 div.yiv4001524055file-title a, #yiv4001524055 div.yiv4001524055file-title a:active, #yiv4001524055 div.yiv4001524055file-title a:hover, #yiv4001524055 div.yiv4001524055file-title a:visited {text-decoration:none;}#yiv4001524055 div.yiv4001524055photo-title a, #yiv4001524055 div.yiv4001524055photo-title a:active, #yiv4001524055 div.yiv4001524055photo-title a:hover, #yiv4001524055 div.yiv4001524055photo-title a:visited {text-decoration:none;}#yiv4001524055 div#yiv4001524055ygrp-mlmsg #yiv4001524055ygrp-msg p a span.yiv4001524055yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4001524055 .yiv4001524055green {color:#628c2a;}#yiv4001524055 .yiv4001524055MsoNormal {margin:0 0 0 0;}#yiv4001524055 o {font-size:0;}#yiv4001524055 #yiv4001524055photos div {float:left;width:72px;}#yiv4001524055 #yiv4001524055photos div div {border:1px solid #66;min-height:62px;overflow:hidden;width:62px;}#yiv4001524055 #yiv4001524055photos div label {color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4001524055 #yiv4001524055reco-category {font-size:77%;}#yiv4001524055 #yiv4001524055reco-desc {font-size:77%;}#yiv4001524055 .yiv4001524055replbq {margin:4px;}#yiv4001524055 #yiv4001524055ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv4001524055 #yiv4001524055ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4001524055 #yiv4001524055ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4001524055 #yiv4001524055ygrp-mlmsg select, #yiv4001524055 input, #yiv4001524055 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv4001524055 #yiv4001524055ygrp-mlmsg pre, #yiv4001524055 code {font:115% monospace;}#yiv4001524055 #yiv4001524055ygrp-mlmsg * {line-height:1.22em;}#yiv4001524055 #yiv4001524055ygrp-mlmsg #yiv4001524055logo {padding-bottom:10px;}#yiv4001524055 #yiv4001524055ygrp-msg p a {font-family:Verdana;}#yiv4001524055