Bls: [belajar-excel] insert row kosong

[odong nando odongna...@yahoo.com [belajar-excel]]

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 

Bls: Bls: [belajar-excel] insert row kosong

[odong nando odongna...@yahoo.com [belajar-excel]]

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 

Re: [belajar-excel] Mohon Dibantu untuk script Expired Date Macro

[Yusuf Roni y.ron...@yahoo.com [belajar-excel]]

 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 

RE: RE: [belajar-excel] MEMBUAT LIST DARI RANGE

['M.Ade Alfarid' q...@kkmi.co.id [belajar-excel]]

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

['M.Ade Alfarid' q...@kkmi.co.id [belajar-excel]]

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]

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

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

Bls: [belajar-excel] insert row kosong

[odong nando odongna...@yahoo.com [belajar-excel]]

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, 

Re: [belajar-excel] insert row kosong

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

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

[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


insert row jika beda.xlsx
Description: MS-Excel 2007 spreadsheet

Re: Bls: [belajar-excel] Menghitung rata-rata dimulai saat muncul angka pertama

[ghozi alkatiri ghozialkat...@yahoo.co.id [belajar-excel]]

 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 

Re: [belajar-excel] Mohon Dibantu untuk script Expired Date Macro

[hendrik karnadi hendrikkarn...@yahoo.com [belajar-excel]]

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 

Re: [belajar-excel] Mohon Dibantu untuk script Expired Date Macro [1 Attachment]

[y.ron...@yahoo.com [belajar-excel]]

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

[Toby kenzo tobyke...@yahoo.co.id [belajar-excel]]

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 

Bls: [belajar-excel] Menghitung rata-rata dimulai saat muncul angka pertama

[Toby kenzo tobyke...@yahoo.co.id [belajar-excel]]

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 

[belajar-excel] Menghitung rata-rata dimulai saat muncul angka pertama

[akh_iyang akh_iy...@yahoo.co.id [belajar-excel]]

Dear master excel,
Mohon bantuannya untuk menghitung rata-rata sesuai kondisi File terlampir.
Thanks

RATA RATA.xls
Description: MS-Excel spreadsheet