hahha...betul, tinggal tunggu waktu Mr. Kid. Salam,HK Sent from Yahoo Mail on Android On Fri, Aug 30, 2019 at 10:40, 'Mr. Kid' [email protected] [belajar-excel]<[email protected]> wrote:
perlu dicoba dulu belajar powerquery...kalo stress, berarti memang perlu kesana.. On Fri, Aug 30, 2019 at 10:36 AM hendrik karnadi [email protected] [belajar-excel] <[email protected]> wrote: HAHAHA, Apakah yang belum bisa Power Query perlu masuk SUMBER WARAS ??? Salam,HK Sent from Yahoo Mail on Android On Fri, Aug 30, 2019 at 10:28, 'Mr. Kid' [email protected] [belajar-excel]<[email protected]> wrote: wkwkwk...powerquery cuman minta syarat : waras logikanya On Fri, Aug 30, 2019 at 10:14 AM hendrik karnadi [email protected] [belajar-excel] <[email protected]> wrote: Dear Mr. Kid, Hahaha, luar biasa Power Query.Kayaknya perlu pencerahan dari Mr. Kid.Terima kasih. Salam, .HK ----- Pesan yang Diteruskan ----- Dari: 'Mr. Kid' [email protected] [belajar-excel] <[email protected]>Kepada: BeExcel <[email protected]>Terkirim: Jumat, 30 Agustus 2019 02..04.03 WIBJudul: Re: [belajar-excel] Merubah Array formula hmmm... 1. Pakai PowerQuery lebih simpel *** sayangnya, cara ini kalah seru karena menuntut lebih dalam belajar Excel2. Pakai array formula cukup simpel (setidaknya, tidak sepanjang yang didapat dari internet) *** Toh cuma membuat di sebuah cells hasil dengan CTRL SHIFT ENTER, lalu copy formula ke kanan dan ke bawah3. Pakai formula menjadi tidak simpel (walau masih lebih pendek beberapa karakter dibanding yang didapat dari internet) *** Pelacakan proses dalam formula cukup sulit dilakukan, sehingga lebih sulit dikembangkan File terlampir dibatasi untuk 20 bilangan per teks.Selain nomor 1, teks dibatasi maksimal 999 chars. Regards,Kid On Wed, Aug 28, 2019 at 11:31 AM jackie yunianto [email protected] [belajar-excel] <[email protected]> wrote: Dear all mohon dibantu, Berikut adalah sample file untuk extract number, yg saya temukan di internet. Formula nya merupakan array formula. Untuk case per case (hanya) 1 atau 2 row saja mungkin tidak membutuhkan banyak effort. Tetapi jika row nya ribuan effort nya sama saja dengan mensortir manual. Apakah dimungkinkan jika array formula berikut di rubah ke formula biasa sehingga tidak perlu pencet ctrl + shift + enter agar formulanya berjalan? Thx Best regards -Jacke- Sent from Yahoo Mail on Android #yiv1492542855 #yiv1492542855 -- #yiv1492542855ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1492542855 #yiv1492542855ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1492542855 #yiv1492542855ygrp-mkp #yiv1492542855hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv1492542855 #yiv1492542855ygrp-mkp #yiv1492542855ads {margin-bottom:10px;}#yiv1492542855 #yiv1492542855ygrp-mkp .yiv1492542855ad {padding:0 0;}#yiv1492542855 #yiv1492542855ygrp-mkp .yiv1492542855ad p {margin:0;}#yiv1492542855 #yiv1492542855ygrp-mkp .yiv1492542855ad a {color:#0000ff;text-decoration:none;}#yiv1492542855 #yiv1492542855ygrp-sponsor #yiv1492542855ygrp-lc {font-family:Arial;}#yiv1492542855 #yiv1492542855ygrp-sponsor #yiv1492542855ygrp-lc #yiv1492542855hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1492542855 #yiv1492542855ygrp-sponsor #yiv1492542855ygrp-lc .yiv1492542855ad {margin-bottom:10px;padding:0 0;}#yiv1492542855 #yiv1492542855actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1492542855 #yiv1492542855activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1492542855 #yiv1492542855activity span {font-weight:700;}#yiv1492542855 #yiv1492542855activity span:first-child {text-transform:uppercase;}#yiv1492542855 #yiv1492542855activity span a {color:#5085b6;text-decoration:none;}#yiv1492542855 #yiv1492542855activity span span {color:#ff7900;}#yiv1492542855 #yiv1492542855activity span .yiv1492542855underline {text-decoration:underline;}#yiv1492542855 .yiv1492542855attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv1492542855 .yiv1492542855attach div a {text-decoration:none;}#yiv1492542855 .yiv1492542855attach img {border:none;padding-right:5px;}#yiv1492542855 .yiv1492542855attach label {display:block;margin-bottom:5px;}#yiv1492542855 .yiv1492542855attach label a {text-decoration:none;}#yiv1492542855 blockquote {margin:0 0 0 4px;}#yiv1492542855 .yiv1492542855bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv1492542855 .yiv1492542855bold a {text-decoration:none;}#yiv1492542855 dd.yiv1492542855last p a {font-family:Verdana;font-weight:700;}#yiv1492542855 dd.yiv1492542855last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1492542855 dd.yiv1492542855last p span.yiv1492542855yshortcuts {margin-right:0;}#yiv1492542855 div.yiv1492542855attach-table div div a {text-decoration:none;}#yiv1492542855 div.yiv1492542855attach-table {width:400px;}#yiv1492542855 div.yiv1492542855file-title a, #yiv1492542855 div.yiv1492542855file-title a:active, #yiv1492542855 div.yiv1492542855file-title a:hover, #yiv1492542855 div.yiv1492542855file-title a:visited {text-decoration:none;}#yiv1492542855 div.yiv1492542855photo-title a, #yiv1492542855 div.yiv1492542855photo-title a:active, #yiv1492542855 div.yiv1492542855photo-title a:hover, #yiv1492542855 div.yiv1492542855photo-title a:visited {text-decoration:none;}#yiv1492542855 div#yiv1492542855ygrp-mlmsg #yiv1492542855ygrp-msg p a span.yiv1492542855yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1492542855 .yiv1492542855green {color:#628c2a;}#yiv1492542855 .yiv1492542855MsoNormal {margin:0 0 0 0;}#yiv1492542855 o {font-size:0;}#yiv1492542855 #yiv1492542855photos div {float:left;width:72px;}#yiv1492542855 #yiv1492542855photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv1492542855 #yiv1492542855photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1492542855 #yiv1492542855reco-category {font-size:77%;}#yiv1492542855 #yiv1492542855reco-desc {font-size:77%;}#yiv1492542855 .yiv1492542855replbq {margin:4px;}#yiv1492542855 #yiv1492542855ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv1492542855 #yiv1492542855ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1492542855 #yiv1492542855ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1492542855 #yiv1492542855ygrp-mlmsg select, #yiv1492542855 input, #yiv1492542855 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv1492542855 #yiv1492542855ygrp-mlmsg pre, #yiv1492542855 code {font:115% monospace;}#yiv1492542855 #yiv1492542855ygrp-mlmsg * {line-height:1.22em;}#yiv1492542855 #yiv1492542855ygrp-mlmsg #yiv1492542855logo {padding-bottom:10px;}#yiv1492542855 #yiv1492542855ygrp-msg p a {font-family:Verdana;}#yiv1492542855 #yiv1492542855ygrp-msg p#yiv1492542855attach-count span {color:#1E66AE;font-weight:700;}#yiv1492542855 #yiv1492542855ygrp-reco #yiv1492542855reco-head {color:#ff7900;font-weight:700;}#yiv1492542855 #yiv1492542855ygrp-reco {margin-bottom:20px;padding:0px;}#yiv1492542855 #yiv1492542855ygrp-sponsor #yiv1492542855ov li a {font-size:130%;text-decoration:none;}#yiv1492542855 #yiv1492542855ygrp-sponsor #yiv1492542855ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv1492542855 #yiv1492542855ygrp-sponsor #yiv1492542855ov ul {margin:0;padding:0 0 0 8px;}#yiv1492542855 #yiv1492542855ygrp-text {font-family:Georgia;}#yiv1492542855 #yiv1492542855ygrp-text p {margin:0 0 1em 0;}#yiv1492542855 #yiv1492542855ygrp-text tt {font-size:120%;}#yiv1492542855 #yiv1492542855ygrp-vital ul li:last-child {border-right:none !important;}#yiv1492542855
