Re: [belajar-excel] Pindah Group Yuk...!!!!
siaap otw
On Wednesday, October 23, 2019, 07:48:06 AM GMT+10, iq_bal7...@yahoo.com
[belajar-excel] wrote:
Dear All,
Udah pada dengar kan klo yahoo group akan berhenti beroperasi?
Yuk kita pindahan ke sebelah,
Sudah di siapkan moderator untuk group pengganti di google groups.
Alamat nya ini
https://groups.google.com/forum/#!forum/milis-belajar-excel
#yiv0488251709 #yiv0488251709 -- #yiv0488251709ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0488251709
#yiv0488251709ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0488251709
#yiv0488251709ygrp-mkp #yiv0488251709hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv0488251709 #yiv0488251709ygrp-mkp #yiv0488251709ads
{margin-bottom:10px;}#yiv0488251709 #yiv0488251709ygrp-mkp .yiv0488251709ad
{padding:0 0;}#yiv0488251709 #yiv0488251709ygrp-mkp .yiv0488251709ad p
{margin:0;}#yiv0488251709 #yiv0488251709ygrp-mkp .yiv0488251709ad a
{color:#ff;text-decoration:none;}#yiv0488251709 #yiv0488251709ygrp-sponsor
#yiv0488251709ygrp-lc {font-family:Arial;}#yiv0488251709
#yiv0488251709ygrp-sponsor #yiv0488251709ygrp-lc #yiv0488251709hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0488251709
#yiv0488251709ygrp-sponsor #yiv0488251709ygrp-lc .yiv0488251709ad
{margin-bottom:10px;padding:0 0;}#yiv0488251709 #yiv0488251709actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0488251709
#yiv0488251709activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0488251709
#yiv0488251709activity span {font-weight:700;}#yiv0488251709
#yiv0488251709activity span:first-child
{text-transform:uppercase;}#yiv0488251709 #yiv0488251709activity span a
{color:#5085b6;text-decoration:none;}#yiv0488251709 #yiv0488251709activity span
span {color:#ff7900;}#yiv0488251709 #yiv0488251709activity span
.yiv0488251709underline {text-decoration:underline;}#yiv0488251709
.yiv0488251709attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv0488251709 .yiv0488251709attach div a
{text-decoration:none;}#yiv0488251709 .yiv0488251709attach img
{border:none;padding-right:5px;}#yiv0488251709 .yiv0488251709attach label
{display:block;margin-bottom:5px;}#yiv0488251709 .yiv0488251709attach label a
{text-decoration:none;}#yiv0488251709 blockquote {margin:0 0 0
4px;}#yiv0488251709 ...yiv0488251709bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv0488251709
.yiv0488251709bold a {text-decoration:none;}#yiv0488251709 dd.yiv0488251709last
p a {font-family:Verdana;font-weight:700;}#yiv0488251709 dd.yiv0488251709last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0488251709
dd.yiv0488251709last p span.yiv0488251709yshortcuts
{margin-right:0;}#yiv0488251709 div.yiv0488251709attach-table div div a
{text-decoration:none;}#yiv0488251709 div.yiv0488251709attach-table
{width:400px;}#yiv0488251709 div.yiv0488251709file-title a, #yiv0488251709
div.yiv0488251709file-title a:active, #yiv0488251709
div.yiv0488251709file-title a:hover, #yiv0488251709 div.yiv0488251709file-title
a:visited {text-decoration:none;}#yiv0488251709 div.yiv0488251709photo-title a,
#yiv0488251709 div.yiv0488251709photo-title a:active, #yiv0488251709
div.yiv0488251709photo-title a:hover, #yiv0488251709
div.yiv0488251709photo-title a:visited {text-decoration:none;}#yiv0488251709
div#yiv0488251709ygrp-mlmsg #yiv0488251709ygrp-msg p a
span.yiv0488251709yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0488251709
.yiv0488251709green {color:#628c2a;}#yiv0488251709 .yiv0488251709MsoNormal
{margin:0 0 0 0;}#yiv0488251709 o {font-size:0;}#yiv0488251709
#yiv0488251709photos div {float:left;width:72px;}#yiv0488251709
#yiv0488251709photos div div {border:1px solid
#66;min-height:62px;overflow:hidden;width:62px;}#yiv0488251709
#yiv0488251709photos div label
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0488251709
#yiv0488251709reco-category {font-size:77%;}#yiv0488251709
#yiv0488251709reco-desc {font-size:77%;}#yiv0488251709 .yiv0488251709replbq
{margin:4px;}#yiv0488251709 #yiv0488251709ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv0488251709 #yiv0488251709ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0488251709
#yiv0488251709ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0488251709
#yiv0488251709ygrp-mlmsg select, #yiv0488251709 input, #yiv0488251709 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv0488251709
#yiv0488251709ygrp-mlmsg pre, #yiv0488251709 code {font:115%
monospace;}#yiv0488251709 #yiv0488251709ygrp-mlmsg *
{line-height:1.22em;}#yiv0488251709 #yiv0488251709ygrp-mlmsg #yiv0488251709logo
{padding-bottom:10px;}#yiv0488251709 #yiv0488251709ygrp-msg p a
{font-family:Verdana;}#yiv0488251709 #yiv0488251709ygrp-m
RE: [belajar-excel] Transform Table dengan Power Query [1 Attachment]
Dear Mas Ulum Monggo di telisik cara versi ke dua Thanks Best Regards Muhammad Iqbal +62890909010/0811101854 From: belajar-excel@yahoogroups.com Sent: Wednesday, October 23, 2019 12:59 PM To: belajar-excel@yahoogroups.com Subject: [belajar-excel] Transform Table dengan Power Query [1 Attachment] Rekan Be-Excel, Saya ingin merubah table dengan bantuan Power Query. Table semula: - ID|X |Y |Z |DESC |STATUS - 1A|23|34|100|CP-01|NEW Tabel yang diinginkan : - ID|DESC |STATUS|Coord|XYZ - 1A|CP-01|NEW |X |23 1A|CP-01|NEW |Y |34 1A|CP-01|NEW |Z |100 Pada file terlampir adalah power query yang sudah saya buat dan menghasilkan table yang diinginkan tetapi menurut saya masih kurang ringkes dan praktis, Mohon bantuannya, apakah ada cara yang lebih praktis seperti menggunakan join table atau cara yang lainnya? Terimakasih, Wassalam, -zainul -- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus transpose data vertical to horizontal.xlsx Description: MS-Excel 2007 spreadsheet
Re: [belajar-excel] Transform Table dengan Power Query [1 Attachment]
pilih kolom X, Y, Z -> menu transform -> unpivot columns -> pilih unpivot columns -> edit formula, ubah Attribute jadi Coord dan Vaue jadi XYZ -> enter On Wed, Oct 23, 2019 at 7:42 PM Zainul Ulum zainul_u...@yahoo.com [belajar-excel] wrote: > > > Rekan Be-Excel, > > > > Saya ingin merubah table dengan bantuan Power Query. > > > > Table semula: > > - > > ID|X |Y |Z |DESC |STATUS > > - > > 1A|23|34|100|CP-01|NEW > > > > Tabel yang diinginkan : > > - > > ID|DESC |STATUS|Coord|XYZ > > - > > 1A|CP-01|NEW |X |23 > > 1A|CP-01|NEW |Y |34 > > 1A|CP-01|NEW |Z |100 > > > > Pada file terlampir adalah power query yang sudah saya buat dan > menghasilkan table yang diinginkan tetapi menurut saya masih kurang ringkes > dan praktis, > > > > Mohon bantuannya, apakah ada cara yang lebih praktis seperti menggunakan > join table atau cara yang lainnya? > > > > Terimakasih, > > Wassalam, > > -zainul > > > > > > > > > > > re-Tanya Power Query.xlsx Description: MS-Excel 2007 spreadsheet
Re: [belajar-excel] lookup data [1 Attachment]
Terimakasih mas ade, iya bisa ternyata dengan mengurutkan datanya
Pada Senin, 21 Oktober 2019 18.19.40 WIB, 'M.Ade Alfarid' q...@kkmi.co.id
[belajar-excel] menulis:
Mas hairul,
Coba urutkan/filter kolom date nya
ade
From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: Monday, October 21, 2019 5:24 PM
To: belajar-excel@yahoogroups.com
Subject: Re: [belajar-excel] lookup data
Salam Master
Saya belum mudeng
Maaf
Assalamualaikum
Pada Senin, 21 Oktober 2019 16..05.02 GMT+7, 'Mr. Kid' mr.nm...@gmail.com
[belajar-excel] menulis:
karena datanya tidak di-sort berdasar kolom kunci lookup nya
On Mon, Oct 21, 2019 at 3:38 PM HAIRUL ALAM ha_m...@yahoo.co.id [belajar-excel]
wrote:
Salam Para Master
Selamat Sore, semoga semua dalam keadaan sehat
Terlampir data lookup, Maaf dari data tersebut ada rumus yang tidak berfungsi
dan saya tidak paham dimana letak kesalahannya karena ada data yang tidak
bernilai, mohon solusinya
Terimakasih Banyak
Assalamalaikum
Hairul Alam
#yiv9275747797 #yiv9275747797 -- #yiv9275747797ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9275747797
#yiv9275747797ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9275747797
#yiv9275747797ygrp-mkp #yiv9275747797hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv9275747797 #yiv9275747797ygrp-mkp #yiv9275747797ads
{margin-bottom:10px;}#yiv9275747797 #yiv9275747797ygrp-mkp .yiv9275747797ad
{padding:0 0;}#yiv9275747797 #yiv9275747797ygrp-mkp .yiv9275747797ad p
{margin:0;}#yiv9275747797 #yiv9275747797ygrp-mkp .yiv9275747797ad a
{color:#ff;text-decoration:none;}#yiv9275747797 #yiv9275747797ygrp-sponsor
#yiv9275747797ygrp-lc {font-family:Arial;}#yiv9275747797
#yiv9275747797ygrp-sponsor #yiv9275747797ygrp-lc #yiv9275747797hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9275747797
#yiv9275747797ygrp-sponsor #yiv9275747797ygrp-lc .yiv9275747797ad
{margin-bottom:10px;padding:0 0;}#yiv9275747797 #yiv9275747797actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9275747797
#yiv9275747797activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9275747797
#yiv9275747797activity span {font-weight:700;}#yiv9275747797
#yiv9275747797activity span:first-child
{text-transform:uppercase;}#yiv9275747797 #yiv9275747797activity span a
{color:#5085b6;text-decoration:none;}#yiv9275747797 #yiv9275747797activity span
span {color:#ff7900;}#yiv9275747797 #yiv9275747797activity span
.yiv9275747797underline {text-decoration:underline;}#yiv9275747797
.yiv9275747797attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv9275747797 .yiv9275747797attach div a
{text-decoration:none;}#yiv9275747797 .yiv9275747797attach img
{border:none;padding-right:5px;}#yiv9275747797 .yiv9275747797attach label
{display:block;margin-bottom:5px;}#yiv9275747797 .yiv9275747797attach label a
{text-decoration:none;}#yiv9275747797 blockquote {margin:0 0 0
4px;}#yiv9275747797 .yiv9275747797bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv9275747797
.yiv9275747797bold a {text-decoration:none;}#yiv9275747797 dd.yiv9275747797last
p a {font-family:Verdana;font-weight:700;}#yiv9275747797 dd.yiv9275747797last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9275747797
dd.yiv9275747797last p span.yiv9275747797yshortcuts
{margin-right:0;}#yiv9275747797 div.yiv9275747797attach-table div div a
{text-decoration:none;}#yiv9275747797 div.yiv9275747797attach-table
{width:400px;}#yiv9275747797 div.yiv9275747797file-title a, #yiv9275747797
div.yiv9275747797file-title a:active, #yiv9275747797
div.yiv9275747797file-title a:hover, #yiv9275747797 div.yiv9275747797file-title
a:visited {text-decoration:none;}#yiv9275747797 div.yiv9275747797photo-title a,
#yiv9275747797 div.yiv9275747797photo-title a:active, #yiv9275747797
div.yiv9275747797photo-title a:hover, #yiv9275747797
div.yiv9275747797photo-title a:visited {text-decoration:none;}#yiv9275747797
div#yiv9275747797ygrp-mlmsg #yiv9275747797ygrp-msg p a
span.yiv9275747797yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9275747797
.yiv9275747797green {color:#628c2a;}#yiv9275747797 .yiv9275747797MsoNormal
{margin:0 0 0 0;}#yiv9275747797 o {font-size:0;}#yiv9275747797
#yiv9275747797photos div {float:left;width:72px;}#yiv9275747797
#yiv9275747797photos div div {border:1px solid
#66;min-height:62px;overflow:hidden;width:62px;}#yiv9275747797
#yiv9275747797photos div label
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9275747797
#yiv9275747797reco-category {font-size:77%;}#yiv9275747797
#yiv9275747797reco-desc {font-size:77%;}#yiv9275747797 .yiv9275747797replbq
{margin:4px;}#yiv9275747797 #yiv9275747797ygrp-actbar div a:first
[belajar-excel] Transform Table dengan Power Query [1 Attachment]
Rekan Be-Excel, Saya ingin merubah table dengan bantuan Power Query. Table semula: - ID|X |Y |Z |DESC |STATUS - 1A|23|34|100|CP-01|NEW Tabel yang diinginkan : - ID|DESC |STATUS|Coord|XYZ - 1A|CP-01|NEW |X|23 1A|CP-01|NEW |Y|34 1A|CP-01|NEW |Z|100 Pada file terlampir adalah power query yang sudah saya buat dan menghasilkan table yang diinginkan tetapi menurut saya masih kurang ringkes dan praktis, Mohon bantuannya, apakah ada cara yang lebih praktis seperti menggunakan join table atau cara yang lainnya? Terimakasih, Wassalam, -zainul Tanya Power Query.xlsx Description: MS-Excel 2007 spreadsheet
