11 Messages
Digest #4487
1d
Re: Bls: [belajar-excel] Menghitung rata-rata dimulai saat muncul an by "ghozi alkatiri" ghozialkatiri
2b
Re: Mohon Dibantu untuk script Expired Date Macro [1 Attachment] by "hendrik karnadi" hendrikkarnadi
Messages
Sun Apr 15, 2018 11:32 pm (PDT) . Posted by:
"akh_iyang" akh_iyang
Dear master excel,
Mohon bantuannya untuk menghitung rata-rata sesuai kondisi File terlampir.
Thanks
Mohon bantuannya untuk menghitung rata-rata sesuai kondisi File terlampir.
Thanks
Mon Apr 16, 2018 12:56 am (PDT) . Posted by:
"Toby kenzo" tobykenzo
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_iyang@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> 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:#0000ff;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 #666666;min-height:62px;overflow:hidden;width:62px;}#yiv4001524055 #yiv4001524055photos div label {color:#666666;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 #yiv4001524055ygrp-msg p#yiv4001524055attach-count span {color:#1E66AE;font-weight:700;}#yiv4001524055 #yiv4001524055ygrp-reco #yiv4001524055reco-head {color:#ff7900;font-weight:700;}#yiv4001524055 #yiv4001524055ygrp-reco {margin-bottom:20px;padding:0px;}#yiv4001524055 #yiv4001524055ygrp-sponsor #yiv4001524055ov li a {font-size:130%;text-decoration:none;}#yiv4001524055 #yiv4001524055ygrp-sponsor #yiv4001524055ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv4001524055 #yiv4001524055ygrp-sponsor #yiv4001524055ov ul {margin:0;padding:0 0 0 8px;}#yiv4001524055 #yiv4001524055ygrp-text {font-family:Georgia;}#yiv4001524055 #yiv4001524055ygrp-text p {margin:0 0 1em 0;}#yiv4001524055 #yiv4001524055ygrp-text tt {font-size:120%;}#yiv4001524055 #yiv4001524055ygrp-vital ul li:last-child {border-right:none !important;}#yiv4001524055
Karena Array formula jangan lupa ketik Ctrl + Alt + Enter
TerimaKasih
Pada Senin, 16 April 2018 13:32, "akh_iyang akh_iyang@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Dear master excel,
Mohon bantuannya untuk menghitung rata-rata sesuai kondisi File terlampir.
Thanks #yiv4001524055 #yiv4001524055 -- #yiv4001524055ygrp-
Mon Apr 16, 2018 1:09 am (PDT) . Posted by:
"Toby kenzo" tobykenzo
Sorry, bukan Ctrl + Alt + Enter tapi Ctrl + Shift + Enter.
Terimakasih.
Pada Senin, 16 April 2018 13:32, "akh_iyang akh_iyang@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> 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:#0000ff;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 #666666;min-height:62px;overflow:hidden;width:62px;}#yiv0452551377 #yiv0452551377photos div label {color:#666666;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 #yiv0452551377ygrp-reco #yiv0452551377reco-head {color:#ff7900;font-weight:700;}#yiv0452551377 #yiv0452551377ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0452551377 #yiv0452551377ygrp-sponsor #yiv0452551377ov li a {font-size:130%;text-decoration:none;}#yiv0452551377 #yiv0452551377ygrp-sponsor #yiv0452551377ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0452551377 #yiv0452551377ygrp-sponsor #yiv0452551377ov ul {margin:0;padding:0 0 0 8px;}#yiv0452551377 #yiv0452551377ygrp-text {font-family:Georgia;}#yiv0452551377 #yiv0452551377ygrp-text p {margin:0 0 1em 0;}#yiv0452551377 #yiv0452551377ygrp-text tt {font-size:120%;}#yiv0452551377 #yiv0452551377ygrp-vital ul li:last-child {border-right:none !important;}#yiv0452551377
Terimakasih.
Pada Senin, 16 April 2018 13:32, "akh_iyang akh_iyang@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Dear master excel,
Mohon bantuannya untuk menghitung rata-rata sesuai kondisi File terlampir.
Thanks #yiv0452551377 #yiv0452551377 -- #yiv0452551377ygrp-
Mon Apr 16, 2018 2:44 am (PDT) . Posted by:
"ghozi alkatiri" ghozialkatiri
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 Alkatiri Pada Senin, 16 April 2018 15.10.12 GMT+7, Toby kenzo tobykenzo@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com> menulis:
Sorry, bukan Ctrl + Alt + Enter tapi Ctrl + Shift + Enter.
Terimakasih.
Pada Senin, 16 April 2018 13:32, "akh_iyang akh_iyang@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> 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:#0000ff;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 #666666;min-height:62px;overflow:hidden;width:62px;}#yiv6921027248 #yiv6921027248photos div label {color:#666666;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;}#yiv6921027248 #yiv6921027248ygrp-mlmsg * {line-height:1.22em;}#yiv6921027248 #yiv6921027248ygrp-mlmsg #yiv6921027248logo {padding-bottom:10px;}#yiv6921027248 #yiv6921027248ygrp-msg p a {font-family:Verdana;}#yiv6921027248 #yiv6921027248ygrp-msg p#yiv6921027248attach-count span {color:#1E66AE;font-weight:700;}#yiv6921027248 #yiv6921027248ygrp-reco #yiv6921027248reco-head {color:#ff7900;font-weight:700;}#yiv6921027248 #yiv6921027248ygrp-reco {margin-bottom:20px;padding:0px;}#yiv6921027248 #yiv6921027248ygrp-sponsor #yiv6921027248ov li a {font-size:130%;text-decoration:none;}#yiv6921027248 #yiv6921027248ygrp-sponsor #yiv6921027248ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv6921027248 #yiv6921027248ygrp-sponsor #yiv6921027248ov ul {margin:0;padding:0 0 0 8px;}#yiv6921027248 #yiv6921027248ygrp-text {font-family:Georgia;}#yiv6921027248 #yiv6921027248ygrp-text p {margin:0 0 1em 0;}#yiv6921027248 #yiv6921027248ygrp-text tt {font-size:120%;}#yiv6921027248 #yiv6921027248ygrp-vital ul li:last-child {border-right:none !important;}#yiv6921027248
=AVERAGE(OFFSET($A5,0,MIN(IF($A5:$L5>0,COLUMN(A:L)))-1,,(MAX(IF($A5:$L5>0,13-COLUMN(A:L))))))
wassalam
Ghozi Alkatiri Pada Senin, 16 April 2018 15.10.12 GMT+7, Toby kenzo tobykenzo@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com> menulis:
Sorry, bukan Ctrl + Alt + Enter tapi Ctrl + Shift + Enter.
Terimakasih.
Pada Senin, 16 April 2018 13:32, "akh_iyang akh_iyang@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Dear master excel,
Mohon bantuannya untuk menghitung rata-rata sesuai kondisi File terlampir.
Thanks
#yiv6921027248 #yiv6921027248 -- #yiv6921027248ygrp-
Mon Apr 16, 2018 1:25 am (PDT) . Posted by:
y.roni35
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?
Mon Apr 16, 2018 2:38 am (PDT) . Posted by:
"hendrik karnadi" hendrikkarnadi
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.roni35@yahoo.com [belajar-excel]<belajar-excel@yahoogroups.com> 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:#0000ff;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 #666666;min-height:62px;overflow:hidden;width:62px;}#yiv2770713700 #yiv2770713700photos div label {color:#666666;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:115% monospace;}#yiv2770713700 #yiv2770713700ygrp-mlmsg * {line-height:1..22em;}#yiv2770713700 #yiv2770713700ygrp-mlmsg #yiv2770713700logo {padding-bottom:10px;}#yiv2770713700 #yiv2770713700ygrp-msg p a {font-family:Verdana;}#yiv2770713700 #yiv2770713700ygrp-msg p#yiv2770713700attach-count span {color:#1E66AE;font-weight:700;}#yiv2770713700 #yiv2770713700ygrp-reco #yiv2770713700reco-head {color:#ff7900;font-weight:700;}#yiv2770713700 #yiv2770713700ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2770713700 #yiv2770713700ygrp-sponsor #yiv2770713700ov li a {font-size:130%;text-decoration:none;}#yiv2770713700 #yiv2770713700ygrp-sponsor #yiv2770713700ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2770713700 #yiv2770713700ygrp-sponsor #yiv2770713700ov ul {margin:0;padding:0 0 0 8px;}#yiv2770713700 #yiv2770713700ygrp-text {font-family:Georgia;}#yiv2770713700 #yiv2770713700ygrp-text p {margin:0 0 1em 0;}#yiv2770713700 #yiv2770713700ygrp-text tt {font-size:120%;}#yiv2770713700 #yiv2770713700ygrp-vital ul li:last-child {border-right:none !important;}#yiv2770713700
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.roni35@yahoo.com [belajar-excel]<belajar-excel@yahoogroups.com> 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-
Mon Apr 16, 2018 4:54 am (PDT) . Posted by:
"odong nando"
hai rekan2 beExcel,
mohon solusi menambahkan row kosong di antara data yang ada.
utk lebih jelasnya mohon lihat di lampiran
br,
odong nando
mohon solusi menambahkan row kosong di antara data yang ada.
utk lebih jelasnya mohon lihat di lampiran
br,
odong nando
Mon Apr 16, 2018 5:33 am (PDT) . Posted by:
"Mr. Kid" nmkid.family@ymail.com
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 odongnando@yahoo.com [belajar-excel]
<belajar-excel@yahoogroups.com>:
>
>
> hai rekan2 beExcel,
>
> mohon solusi menambahkan row kosong di antara data yang ada.
>
> utk lebih jelasnya mohon lihat di lampiran
>
>
> br,
>
> odong nando
>
>
>
kenapa tidak di sheet output saja ?
2018-04-16 18:54 GMT+07:00 odong nando odongnando@yahoo.com [belajar-excel]
<belajar-excel@yahoogroups.com>:
>
>
> hai rekan2 beExcel,
>
> mohon solusi menambahkan row kosong di antara data yang ada.
>
> utk lebih jelasnya mohon lihat di lampiran
>
>
> br,
>
> odong nando
>
>
>
Mon Apr 16, 2018 5:48 am (PDT) . Posted by:
"odong nando"
boleh di output boz kid, jadi data yang ada cuma sebagai database yang tidak bisa berubah... br,
odong nando
Dari: "'Mr. Kid' mr.nmkid@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com>
Kepada: BeExcel <belajar-excel@yahoogroups.com>
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 odongnando@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com>:
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:#0000ff;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 #666666;min-height:62px;overflow:hidden;width:62px;}#yiv6580020930 #yiv6580020930photos div label {color:#666666;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 #yiv6580020930ygrp-mlmsg * {line-height:1.22em;}#yiv6580020930 #yiv6580020930ygrp-mlmsg #yiv6580020930logo {padding-bottom:10px;}#yiv6580020930 #yiv6580020930ygrp-msg p a {font-family:Verdana;}#yiv6580020930 #yiv6580020930ygrp-msg p#yiv6580020930attach-count span {color:#1E66AE;font-weight:700;}#yiv6580020930 #yiv6580020930ygrp-reco #yiv6580020930reco-head {color:#ff7900;font-weight:700;}#yiv6580020930 #yiv6580020930ygrp-reco {margin-bottom:20px;padding:0px;}#yiv6580020930 #yiv6580020930ygrp-sponsor #yiv6580020930ov li a {font-size:130%;text-decoration:none;}#yiv6580020930 #yiv6580020930ygrp-sponsor #yiv6580020930ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv6580020930 #yiv6580020930ygrp-sponsor #yiv6580020930ov ul {margin:0;padding:0 0 0 8px;}#yiv6580020930 #yiv6580020930ygrp-text {font-family:Georgia;}#yiv6580020930 #yiv6580020930ygrp-text p {margin:0 0 1em 0;}#yiv6580020930 #yiv6580020930ygrp-text tt {font-size:120%;}#yiv6580020930 #yiv6580020930ygrp-vital ul li:last-child {border-right:none !important;}#yiv6580020930
odong nando
Dari: "'Mr. Kid' mr.nmkid@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com>
Kepada: BeExcel <belajar-excel@yahoogroups.com>
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 odongnando@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com>:
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-
Mon Apr 16, 2018 7:14 am (PDT) . Posted by:
"ghozi alkatiri" ghozialkatiri
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 Alkatiri Pada Senin, 16 April 2018 20.04.53 GMT+7, odong nando odongnando@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:
boleh di output boz kid, jadi data yang ada cuma sebagai database yang tidak bisa berubah... br,
odong nando
Dari: "'Mr. Kid' mr.nmkid@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com>
Kepada: BeExcel <belajar-excel@yahoogroups.com>
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 odongnando@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com>:
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:#0000ff;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 #666666;min-height:62px;overflow:hidden;width:62px;}#yiv7405091748 #yiv7405091748photos div label {color:#666666;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;}#yiv7405091748 #yiv7405091748ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv7405091748 #yiv7405091748ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7405091748 #yiv7405091748ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7405091748 #yiv7405091748ygrp-mlmsg select, #yiv7405091748 input, #yiv7405091748 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv7405091748 #yiv7405091748ygrp-mlmsg pre, #yiv7405091748 code {font:115% monospace;}#yiv7405091748 #yiv7405091748ygrp-mlmsg * {line-height:1.22em;}#yiv7405091748 #yiv7405091748ygrp-mlmsg #yiv7405091748logo {padding-bottom:10px;}#yiv7405091748 #yiv7405091748ygrp-msg p a {font-family:Verdana;}#yiv7405091748 #yiv7405091748ygrp-msg p#yiv7405091748attach-count span {color:#1E66AE;font-weight:700;}#yiv7405091748 #yiv7405091748ygrp-reco #yiv7405091748reco-head {color:#ff7900;font-weight:700;}#yiv7405091748 #yiv7405091748ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7405091748 #yiv7405091748ygrp-sponsor #yiv7405091748ov li a {font-size:130%;text-decoration:none;}#yiv7405091748 #yiv7405091748ygrp-sponsor #yiv7405091748ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7405091748 #yiv7405091748ygrp-sponsor #yiv7405091748ov ul {margin:0;padding:0 0 0 8px;}#yiv7405091748 #yiv7405091748ygrp-text {font-family:Georgia;}#yiv7405091748 #yiv7405091748ygrp-text p {margin:0 0 1em 0;}#yiv7405091748 #yiv7405091748ygrp-text tt {font-size:120%;}#yiv7405091748 #yiv7405091748ygrp-vital ul li:last-child {border-right:none !important;}#yiv7405091748
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 Alkatiri Pada Senin, 16 April 2018 20.04.53 GMT+7, odong nando odongnando@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:
boleh di output boz kid, jadi data yang ada cuma sebagai database yang tidak bisa berubah... br,
odong nando
Dari: "'Mr. Kid' mr.nmkid@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com>
Kepada: BeExcel <belajar-excel@yahoogroups.com>
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 odongnando@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com>:
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-
Mon Apr 16, 2018 8:29 am (PDT) . Posted by:
"Mr. Kid" nmkid.family@ymail.com
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 odongnando@yahoo.com
[belajar-excel] <belajar-excel@yahoogroups.com> wrote:
>
>
> boleh di output boz kid, jadi data yang ada cuma sebagai database yang
> tidak bisa berubah...
>
> br,
>
> odong nando
>
>
> ------------------------------
> *Dari:* "'Mr. Kid' mr.nmkid@gmail.com [belajar-excel]" <
> belajar-excel@yahoogroups.com>
> *Kepada:* BeExcel <belajar-excel@yahoogroups.com>
> *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 odongnando@yahoo.com
> [belajar-excel] <belajar-excel@yahoogroups.com>:
>
>
> hai rekan2 beExcel,
>
> mohon solusi menambahkan row kosong di antara data yang ada.
>
> utk lebih jelasnya mohon lihat di lampiran
>
>
> br,
>
> odong nando
>
>
>
>
>
>
fitur pivot dalam field setting berupa opsi insert blank row blabla
On Mon, Apr 16, 2018 at 7:48 PM, odong nando odongnando@yahoo.com
[belajar-excel] <belajar-excel@yahoogroups.com> wrote:
>
>
> boleh di output boz kid, jadi data yang ada cuma sebagai database yang
> tidak bisa berubah...
>
> br,
>
> odong nando
>
>
> ------------------------------
> *Dari:* "'Mr. Kid' mr.nmkid@gmail.com [belajar-excel]" <
> belajar-excel@yahoogroups.com>
> *Kepada:* BeExcel <belajar-excel@yahoogroups.com>
> *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 odongnando@yahoo.com
> [belajar-excel] <belajar-excel@yahoogroups.com>:
>
>
> hai rekan2 beExcel,
>
> mohon solusi menambahkan row kosong di antara data yang ada.
>
> utk lebih jelasnya mohon lihat di lampiran
>
>
> br,
>
> odong nando
>
>
>
>
>
>
============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com
posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com
berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com
keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com
posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com
berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com
keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------
Tidak ada komentar:
Posting Komentar