[belajar-excel] Re: belajar tentang combine / consolitadion tabel antar file [2 Attachments]
halo pak HK, untuk file aslinya, dalam satu file banyak tabel dan banyak sheet, tapi hanya 1 tabel saja yang mau sya combinkan, dan ini sya lapirkan 2 contoh filenya, tapi dalam file contoh ini hanya terdapat 1 sheet dan 1 tabel saja Book2.xlsx Description: MS-Excel 2007 spreadsheet Book1.xlsx Description: MS-Excel 2007 spreadsheet
Re: [belajar-excel] belajar tentang combine / consolitadion tabel antar file
Apakah setiap file yang ingin dicombine masing2 hanya terdiri dari 1 Tabel (Sheet) ?Bisa dibuatkan contoh 2 Dummy file yang ingin dicombine ? Salam,HK Sent from Yahoo Mail on Android On Tue, Jul 31, 2018 at 20:06, rafael_...@yahoo.com [belajar-excel] wrote: Assalamualaikum Wr.Wb salam untuk semua member di group ini, terutama untuk para kuncen2 atau suhu2 disni hehe, perkenalkan saya ari member baru di group ini :) , saya mau bertanya mengenai penggabungan atau relasi antara beberapa tabel dari file yang berbeda menjadi 1 tabel, apakah pada program excel sudah tersedia fiture seperti itu? jika ada, dibagian mana dan seperti apa cara penggunaannya? apakah ada batasan file yg bisa digabungkan? dan kalo tidk ada, apakah ada alternatif lain , misal menggunakan aplikasi ke dua ? #yiv7956195528 #yiv7956195528 -- #yiv7956195528ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7956195528 #yiv7956195528ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7956195528 #yiv7956195528ygrp-mkp #yiv7956195528hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7956195528 #yiv7956195528ygrp-mkp #yiv7956195528ads {margin-bottom:10px;}#yiv7956195528 #yiv7956195528ygrp-mkp .yiv7956195528ad {padding:0 0;}#yiv7956195528 #yiv7956195528ygrp-mkp .yiv7956195528ad p {margin:0;}#yiv7956195528 #yiv7956195528ygrp-mkp .yiv7956195528ad a {color:#ff;text-decoration:none;}#yiv7956195528 #yiv7956195528ygrp-sponsor #yiv7956195528ygrp-lc {font-family:Arial;}#yiv7956195528 #yiv7956195528ygrp-sponsor #yiv7956195528ygrp-lc #yiv7956195528hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7956195528 #yiv7956195528ygrp-sponsor #yiv7956195528ygrp-lc .yiv7956195528ad {margin-bottom:10px;padding:0 0;}#yiv7956195528 #yiv7956195528actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7956195528 #yiv7956195528activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7956195528 #yiv7956195528activity span {font-weight:700;}#yiv7956195528 #yiv7956195528activity span:first-child {text-transform:uppercase;}#yiv7956195528 #yiv7956195528activity span a {color:#5085b6;text-decoration:none;}#yiv7956195528 #yiv7956195528activity span span {color:#ff7900;}#yiv7956195528 #yiv7956195528activity span .yiv7956195528underline {text-decoration:underline;}#yiv7956195528 .yiv7956195528attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7956195528 .yiv7956195528attach div a {text-decoration:none;}#yiv7956195528 .yiv7956195528attach img {border:none;padding-right:5px;}#yiv7956195528 .yiv7956195528attach label {display:block;margin-bottom:5px;}#yiv7956195528 .yiv7956195528attach label a {text-decoration:none;}#yiv7956195528 blockquote {margin:0 0 0 4px;}#yiv7956195528 .yiv7956195528bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7956195528 .yiv7956195528bold a {text-decoration:none;}#yiv7956195528 dd.yiv7956195528last p a {font-family:Verdana;font-weight:700;}#yiv7956195528 dd.yiv7956195528last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7956195528 dd.yiv7956195528last p span.yiv7956195528yshortcuts {margin-right:0;}#yiv7956195528 div.yiv7956195528attach-table div div a {text-decoration:none;}#yiv7956195528 div.yiv7956195528attach-table {width:400px;}#yiv7956195528 div.yiv7956195528file-title a, #yiv7956195528 div.yiv7956195528file-title a:active, #yiv7956195528 div.yiv7956195528file-title a:hover, #yiv7956195528 div.yiv7956195528file-title a:visited {text-decoration:none;}#yiv7956195528 div.yiv7956195528photo-title a, #yiv7956195528 div.yiv7956195528photo-title a:active, #yiv7956195528 div.yiv7956195528photo-title a:hover, #yiv7956195528 div.yiv7956195528photo-title a:visited {text-decoration:none;}#yiv7956195528 div#yiv7956195528ygrp-mlmsg #yiv7956195528ygrp-msg p a span.yiv7956195528yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7956195528 .yiv7956195528green {color:#628c2a;}#yiv7956195528 .yiv7956195528MsoNormal {margin:0 0 0 0;}#yiv7956195528 o {font-size:0;}#yiv7956195528 #yiv7956195528photos div {float:left;width:72px;}#yiv7956195528 #yiv7956195528photos div div {border:1px solid #66;min-height:62px;overflow:hidden;width:62px;}#yiv7956195528 #yiv7956195528photos div label {color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7956195528 #yiv7956195528reco-category {font-size:77%;}#yiv7956195528 #yiv7956195528reco-desc {font-size:77%;}#yiv7956195528 .yiv7956195528replbq {margin:4px;}#yiv7956195528 #yiv7956195528ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv7956195528 #yiv7956195528ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7956195528 #yiv7956195528ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7956195528 #yiv7956195528ygrp-mlmsg
Re: [belajar-excel]
Dari kiri kan ya... LookUp bisa membantu : =LookUp(9^9,1*Left(teksnya,Row($1:$9))) ganti $9 dengan $digit_angka_hasil_paling_banyak karakter koma diganti titik koma jika regional setting komuter setempat adalah ID kalau diakhir teks, ganti Left dengan Right kalau ditengah teks dan tahu posisi awal angka, ganti Left dengan Mid dan sesuaikan inputan untuk Mid. Posisi awal sebuah angka bisa dengan fungsi Find, Search, array Min(IF) dan sebagainya. Sila dikembangkan sesuai kebutuhan.. Regards, Kid 2018-07-31 15:26 GMT+07:00 Syakhri Yanto yantosyak...@gmail.com [belajar-excel] : > > > Master excel > Mohon dibantu,rumus apa yg sy pakai untuk mengambil suatu angka baik angka > itu dalam bentuk satuan, puluhan maupun ratusan... > Contoh kasus = > 1 Jjg > 10 Jjg > 100 Jjg > 1000 jjg > > Terima kasih > > >
[belajar-excel] belajar tentang combine / consolitadion tabel antar file
Assalamualaikum Wr.Wb salam untuk semua member di group ini, terutama untuk para kuncen2 atau suhu2 disni hehe, perkenalkan saya ari member baru di group ini :) , saya mau bertanya mengenai penggabungan atau relasi antara beberapa tabel dari file yang berbeda menjadi 1 tabel, apakah pada program excel sudah tersedia fiture seperti itu? jika ada, dibagian mana dan seperti apa cara penggunaannya? apakah ada batasan file yg bisa digabungkan? dan kalo tidk ada, apakah ada alternatif lain , misal menggunakan aplikasi ke dua ?
Re: [belajar-excel]
Mau pakai UDF ? Salam,HK Sent from Yahoo Mail on Android On Tue, Jul 31, 2018 at 18:42, Syakhri Yanto yantosyak...@gmail.com [belajar-excel] wrote: Master excelMohon dibantu,rumus apa yg sy pakai untuk mengambil suatu angka baik angka itu dalam bentuk satuan, puluhan maupun ratusan...Contoh kasus =1 Jjg10 Jjg100 Jjg 1000 jjg Terima kasih #yiv8831509625 #yiv8831509625 -- #yiv8831509625ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8831509625 #yiv8831509625ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8831509625 #yiv8831509625ygrp-mkp #yiv8831509625hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8831509625 #yiv8831509625ygrp-mkp #yiv8831509625ads {margin-bottom:10px;}#yiv8831509625 #yiv8831509625ygrp-mkp .yiv8831509625ad {padding:0 0;}#yiv8831509625 #yiv8831509625ygrp-mkp .yiv8831509625ad p {margin:0;}#yiv8831509625 #yiv8831509625ygrp-mkp .yiv8831509625ad a {color:#ff;text-decoration:none;}#yiv8831509625 #yiv8831509625ygrp-sponsor #yiv8831509625ygrp-lc {font-family:Arial;}#yiv8831509625 #yiv8831509625ygrp-sponsor #yiv8831509625ygrp-lc #yiv8831509625hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8831509625 #yiv8831509625ygrp-sponsor #yiv8831509625ygrp-lc .yiv8831509625ad {margin-bottom:10px;padding:0 0;}#yiv8831509625 #yiv8831509625actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8831509625 #yiv8831509625activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8831509625 #yiv8831509625activity span {font-weight:700;}#yiv8831509625 #yiv8831509625activity span:first-child {text-transform:uppercase;}#yiv8831509625 #yiv8831509625activity span a {color:#5085b6;text-decoration:none;}#yiv8831509625 #yiv8831509625activity span span {color:#ff7900;}#yiv8831509625 #yiv8831509625activity span .yiv8831509625underline {text-decoration:underline;}#yiv8831509625 .yiv8831509625attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8831509625 .yiv8831509625attach div a {text-decoration:none;}#yiv8831509625 .yiv8831509625attach img {border:none;padding-right:5px;}#yiv8831509625 .yiv8831509625attach label {display:block;margin-bottom:5px;}#yiv8831509625 .yiv8831509625attach label a {text-decoration:none;}#yiv8831509625 blockquote {margin:0 0 0 4px;}#yiv8831509625 .yiv8831509625bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8831509625 .yiv8831509625bold a {text-decoration:none;}#yiv8831509625 dd.yiv8831509625last p a {font-family:Verdana;font-weight:700;}#yiv8831509625 dd.yiv8831509625last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8831509625 dd.yiv8831509625last p span.yiv8831509625yshortcuts {margin-right:0;}#yiv8831509625 div.yiv8831509625attach-table div div a {text-decoration:none;}#yiv8831509625 div.yiv8831509625attach-table {width:400px;}#yiv8831509625 div.yiv8831509625file-title a, #yiv8831509625 div.yiv8831509625file-title a:active, #yiv8831509625 div..yiv8831509625file-title a:hover, #yiv8831509625 div.yiv8831509625file-title a:visited {text-decoration:none;}#yiv8831509625 div.yiv8831509625photo-title a, #yiv8831509625 div.yiv8831509625photo-title a:active, #yiv8831509625 div.yiv8831509625photo-title a:hover, #yiv8831509625 div.yiv8831509625photo-title a:visited {text-decoration:none;}#yiv8831509625 div#yiv8831509625ygrp-mlmsg #yiv8831509625ygrp-msg p a span.yiv8831509625yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8831509625 .yiv8831509625green {color:#628c2a;}#yiv8831509625 .yiv8831509625MsoNormal {margin:0 0 0 0;}#yiv8831509625 o {font-size:0;}#yiv8831509625 #yiv8831509625photos div {float:left;width:72px;}#yiv8831509625 #yiv8831509625photos div div {border:1px solid #66;min-height:62px;overflow:hidden;width:62px;}#yiv8831509625 #yiv8831509625photos div label {color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8831509625 #yiv8831509625reco-category {font-size:77%;}#yiv8831509625 #yiv8831509625reco-desc {font-size:77%;}#yiv8831509625 .yiv8831509625replbq {margin:4px;}#yiv8831509625 #yiv8831509625ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8831509625 #yiv8831509625ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8831509625 #yiv8831509625ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8831509625 #yiv8831509625ygrp-mlmsg select, #yiv8831509625 input, #yiv8831509625 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8831509625 #yiv8831509625ygrp-mlmsg pre, #yiv8831509625 code {font:115% monospace;}#yiv8831509625 #yiv8831509625ygrp-mlmsg * {line-height:1.22em;}#yiv8831509625 #yiv8831509625ygrp-mlmsg #yiv8831509625logo {padding-bottom:10px;}#yiv8831509625 #yiv8831509625ygrp-msg p a {font-family:Verdana;}#yiv8831509625 #yiv8831509625ygrp-msg
Re: [belajar-excel] Pada kolom Excel tiba2 muncul Tulisan Microsoft Excel?
Terimkasih infonya mr kids. Sukse Slalu Regards, Yusuf
[belajar-excel]
Master excel Mohon dibantu,rumus apa yg sy pakai untuk mengambil suatu angka baik angka itu dalam bentuk satuan, puluhan maupun ratusan... Contoh kasus = 1 Jjg 10 Jjg 100 Jjg 1000 jjg Terima kasih
Re: [belajar-excel] rumus usia pensiun
misalkan datanya di A1 coba =EDATE(A1,55*12) Pada Selasa, 31 Juli 2018 14.05.12 WIB, roy sumarna rohendi_2...@yahoo.co.id [belajar-excel] menulis: yth.. master excel>>> gimana rumus untuk menghitung usia pensiun seseorang misal : tanggal lahir 03/05/1967 pensiun 58 adalah 03/05/2025... cara mencari nilai 03/5/2025 gimana ya makasih.. sebelumnya #yiv9076229371 #yiv9076229371 -- #yiv9076229371ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9076229371 #yiv9076229371ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9076229371 #yiv9076229371ygrp-mkp #yiv9076229371hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv9076229371 #yiv9076229371ygrp-mkp #yiv9076229371ads {margin-bottom:10px;}#yiv9076229371 #yiv9076229371ygrp-mkp .yiv9076229371ad {padding:0 0;}#yiv9076229371 #yiv9076229371ygrp-mkp .yiv9076229371ad p {margin:0;}#yiv9076229371 #yiv9076229371ygrp-mkp .yiv9076229371ad a {color:#ff;text-decoration:none;}#yiv9076229371 #yiv9076229371ygrp-sponsor #yiv9076229371ygrp-lc {font-family:Arial;}#yiv9076229371 #yiv9076229371ygrp-sponsor #yiv9076229371ygrp-lc #yiv9076229371hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9076229371 #yiv9076229371ygrp-sponsor #yiv9076229371ygrp-lc .yiv9076229371ad {margin-bottom:10px;padding:0 0;}#yiv9076229371 #yiv9076229371actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9076229371 #yiv9076229371activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9076229371 #yiv9076229371activity span {font-weight:700;}#yiv9076229371 #yiv9076229371activity span:first-child {text-transform:uppercase;}#yiv9076229371 #yiv9076229371activity span a {color:#5085b6;text-decoration:none;}#yiv9076229371 #yiv9076229371activity span span {color:#ff7900;}#yiv9076229371 #yiv9076229371activity span .yiv9076229371underline {text-decoration:underline;}#yiv9076229371 .yiv9076229371attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv9076229371 .yiv9076229371attach div a {text-decoration:none;}#yiv9076229371 .yiv9076229371attach img {border:none;padding-right:5px;}#yiv9076229371 .yiv9076229371attach label {display:block;margin-bottom:5px;}#yiv9076229371 .yiv9076229371attach label a {text-decoration:none;}#yiv9076229371 blockquote {margin:0 0 0 4px;}#yiv9076229371 .yiv9076229371bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv9076229371 .yiv9076229371bold a {text-decoration:none;}#yiv9076229371 dd.yiv9076229371last p a {font-family:Verdana;font-weight:700;}#yiv9076229371 dd.yiv9076229371last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9076229371 dd.yiv9076229371last p span.yiv9076229371yshortcuts {margin-right:0;}#yiv9076229371 div.yiv9076229371attach-table div div a {text-decoration:none;}#yiv9076229371 div.yiv9076229371attach-table {width:400px;}#yiv9076229371 div.yiv9076229371file-title a, #yiv9076229371 div.yiv9076229371file-title a:active, #yiv9076229371 div.yiv9076229371file-title a:hover, #yiv9076229371 div.yiv9076229371file-title a:visited {text-decoration:none;}#yiv9076229371 div.yiv9076229371photo-title a, #yiv9076229371 div.yiv9076229371photo-title a:active, #yiv9076229371 div.yiv9076229371photo-title a:hover, #yiv9076229371 div.yiv9076229371photo-title a:visited {text-decoration:none;}#yiv9076229371 div#yiv9076229371ygrp-mlmsg #yiv9076229371ygrp-msg p a span.yiv9076229371yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9076229371 .yiv9076229371green {color:#628c2a;}#yiv9076229371 .yiv9076229371MsoNormal {margin:0 0 0 0;}#yiv9076229371 o {font-size:0;}#yiv9076229371 #yiv9076229371photos div {float:left;width:72px;}#yiv9076229371 #yiv9076229371photos div div {border:1px solid #66;min-height:62px;overflow:hidden;width:62px;}#yiv9076229371 #yiv9076229371photos div label {color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9076229371 #yiv9076229371reco-category {font-size:77%;}#yiv9076229371 #yiv9076229371reco-desc {font-size:77%;}#yiv9076229371 .yiv9076229371replbq {margin:4px;}#yiv9076229371 #yiv9076229371ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv9076229371 #yiv9076229371ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9076229371 #yiv9076229371ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9076229371 #yiv9076229371ygrp-mlmsg select, #yiv9076229371 input, #yiv9076229371 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv9076229371 #yiv9076229371ygrp-mlmsg pre, #yiv9076229371 code {font:115% monospace;}#yiv9076229371 #yiv9076229371ygrp-mlmsg * {line-height:1.22em;}#yiv9076229371 #yiv9076229371ygrp-mlmsg #yiv9076229371logo {padding-bottom:10px;}#yiv9076229371 #yiv9076229371ygrp-msg p a {font-family:Verdana;}#yiv9076229371 #yiv9076229371ygrp-msg
[belajar-excel] rumus usia pensiun
yth.. master excel>>> gimana rumus untuk menghitung usia pensiun seseorang misal : tanggal lahir 03/05/1967 pensiun 58 adalah 03/05/2025... cara mencari nilai 03/5/2025 gimana ya makasih.. sebelumnya