Re: [belajar-excel] Rumus Angsuran Pokok + Bunga dan Pemba
Mas,
Sepertinya datanya cukup confidential??
Sandy
On Friday, July 24, 2020, 10:50:08 AM GMT+8, Abid Kausar muha...@gmail.com
[belajar-excel] wrote:
Dear Suhu Excel,
Mohon pencerahaanya, saya mempunyai rumus Excel dimana rumus excel ini yang
buat orang sebelum saya :):):) , Saya kurang begitu paham bahasa manualnya :) ,
rumus - rumus itu terdapat di kolom :
"Angsuran Pokok", "Angsuran Bunga", "Pembayaran Ke"...
yang saya mau tanyakan :
Apa itu "PPMT", "IPMT", dan "Ceiling", kalo diterapkan ke manual bahasanya
seperti apa?
terima kasih atas perhatian dan penjelasannya
regardsMuhabka #yiv0170956361 #yiv0170956361 -- #yiv0170956361ygrp-mkp
{border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0
10px;}#yiv0170956361 #yiv0170956361ygrp-mkp hr {border:1px solid
#d8d8d8;}#yiv0170956361 #yiv0170956361ygrp-mkp #yiv0170956361hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv0170956361 #yiv0170956361ygrp-mkp #yiv0170956361ads
{margin-bottom:10px;}#yiv0170956361 #yiv0170956361ygrp-mkp .yiv0170956361ad
{padding:0 0;}#yiv0170956361 #yiv0170956361ygrp-mkp .yiv0170956361ad p
{margin:0;}#yiv0170956361 #yiv0170956361ygrp-mkp .yiv0170956361ad a
{color:#ff;text-decoration:none;}#yiv0170956361 #yiv0170956361ygrp-sponsor
#yiv0170956361ygrp-lc {font-family:Arial;}#yiv0170956361
#yiv0170956361ygrp-sponsor #yiv0170956361ygrp-lc #yiv0170956361hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0170956361
#yiv0170956361ygrp-sponsor #yiv0170956361ygrp-lc .yiv0170956361ad
{margin-bottom:10px;padding:0 0;}#yiv0170956361 #yiv0170956361actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0170956361
#yiv0170956361activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0170956361
#yiv0170956361activity span {font-weight:700;}#yiv0170956361
#yiv0170956361activity span:first-child
{text-transform:uppercase;}#yiv0170956361 #yiv0170956361activity span a
{color:#5085b6;text-decoration:none;}#yiv0170956361 #yiv0170956361activity span
span {color:#ff7900;}#yiv0170956361 #yiv0170956361activity span
.yiv0170956361underline {text-decoration:underline;}#yiv0170956361
.yiv0170956361attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv0170956361 .yiv0170956361attach div a
{text-decoration:none;}#yiv0170956361 .yiv0170956361attach img
{border:none;padding-right:5px;}#yiv0170956361 .yiv0170956361attach label
{display:block;margin-bottom:5px;}#yiv0170956361 .yiv0170956361attach label a
{text-decoration:none;}#yiv0170956361 blockquote {margin:0 0 0
4px;}#yiv0170956361 .yiv0170956361bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv0170956361
.yiv0170956361bold a {text-decoration:none;}#yiv0170956361 dd.yiv0170956361last
p a {font-family:Verdana;font-weight:700;}#yiv0170956361 dd.yiv0170956361last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0170956361
dd.yiv0170956361last p span.yiv0170956361yshortcuts
{margin-right:0;}#yiv0170956361 div.yiv0170956361attach-table div div a
{text-decoration:none;}#yiv0170956361 div.yiv0170956361attach-table
{width:400px;}#yiv0170956361 div.yiv0170956361file-title a, #yiv0170956361
div.yiv0170956361file-title a:active, #yiv0170956361
div.yiv0170956361file-title a:hover, #yiv0170956361 div.yiv0170956361file-title
a:visited {text-decoration:none;}#yiv0170956361 div.yiv0170956361photo-title a,
#yiv0170956361 div.yiv0170956361photo-title a:active, #yiv0170956361
div.yiv0170956361photo-title a:hover, #yiv0170956361
div.yiv0170956361photo-title a:visited {text-decoration:none;}#yiv0170956361
div#yiv0170956361ygrp-mlmsg #yiv0170956361ygrp-msg p a
span.yiv0170956361yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0170956361
.yiv0170956361green {color:#628c2a;}#yiv0170956361 .yiv0170956361MsoNormal
{margin:0 0 0 0;}#yiv0170956361 o {font-size:0;}#yiv0170956361
#yiv0170956361photos div {float:left;width:72px;}#yiv0170956361
#yiv0170956361photos div div {border:1px solid
#66;min-height:62px;overflow:hidden;width:62px;}#yiv0170956361
#yiv0170956361photos div label
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0170956361
#yiv0170956361reco-category {font-size:77%;}#yiv0170956361
#yiv0170956361reco-desc {font-size:77%;}#yiv0170956361 .yiv0170956361replbq
{margin:4px;}#yiv0170956361 #yiv0170956361ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv0170956361 #yiv0170956361ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0170956361
#yiv0170956361ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0170956361
#yiv0170956361ygrp-mlmsg select, #yiv0170956361 input, #yiv0170956361 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv0170956361
#yiv0170956361ygrp-mlmsg pre, #yiv0170956361 code {font:115%
Re: [belajar-excel] Isi nomor serial berulang penanda minggu ke- [1 Attachment]
Silahkan dicek apakah sudah sesuai. Sepertinya minggu ke-8 di sheet yang
dicontohkan hanya muncul 5 kali (dari yang seharusnya 6 kali sesuai yang
diinginkan)
Sandy
On Monday, July 20, 2020, 3:54:25 PM GMT+8, Cari Kebenaran
cahayailm...@gmail.com [belajar-excel] wrote:
Sebagai tambahan, Kolom D adalah hasil yang saya inginkan. Jadi kolom D jangan
dilibatkan dalam formula.
Terima kasih
On Mon, Jul 20, 2020 at 2:37 PM Cari Kebenaran cahayailm...@gmail.com
[belajar-excel] wrote:
Terima kasih atas tanggapan Pak Bagus. Menjawab pertanyaan bapak: Kenapa minggu
kedua dst. koq dimulai dari hari rabu..
Jawabnya: Kebetulan saja dimulai dari rabu. Karena hari liburnya dinamis, tidak
tetap. Yang saya butuhkan adalah menandai hari-hari selain hari minggu, hari
libur dan hari yang ada kegiatan-kegiatan tertentu. Hari-hari dimaksud mau
dikasih nomor mulai dari nomor 1 sampai sekian-masing-masing nomor (1 sampai
sekian) sebanyak 6 kali, kecuali nomor terakhir (gak sampai 6 kali gak apa-apa
karena itu dianggap sebagai sisa.
Demikian terima kasih
On Mon, Jul 20, 2020 at 8:39 AM Bagus bagus4...@gmail.com [belajar-excel]
wrote:
Wa'alaykum salam warohmatullohi wabarokatuhu
Kenapa minggu kedua dst. koq dimulai dari hari rabu..silah lihat file terlampir.
Wassalam
Bagus
Pada tanggal Min, 19 Jul 2020 pukul 10.25 Cari Kebenaran
cahayailm...@gmail..com [belajar-excel] menulis:
Assalamu'alaikum.
Kepada para Master dan anggota milis, tolong dibantu. Saya ingin memasukkan
nomor urut yang berulang sebanyak 6 kali (sebagai penanda minggu ke berapa
dalam 1 satu tahun setelah dikurangi libur dan kegiatan lainnya pada cell
kosong di kolom D di sheet "Tanya").
Sheet "Diinginkan" adalah adalah hasil yang diinginkan, yang saya kerjakan
secara manual.
Selama ini saya kerjakan secara manual yang cukup menyita waktu dan rawan
kesalahan. Selengkapnya, silakan lihat lampiran.
Tolong dibuatkan rumus atau VBA Code-nya
Atas bantuannya diucapkan terima kasih.
Wassalamu'alaikum
#yiv1029092679 #yiv1029092679 -- #yiv1029092679ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1029092679
#yiv1029092679ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1029092679
#yiv1029092679ygrp-mkp #yiv1029092679hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv1029092679 #yiv1029092679ygrp-mkp #yiv1029092679ads
{margin-bottom:10px;}#yiv1029092679 #yiv1029092679ygrp-mkp .yiv1029092679ad
{padding:0 0;}#yiv1029092679 #yiv1029092679ygrp-mkp .yiv1029092679ad p
{margin:0;}#yiv1029092679 #yiv1029092679ygrp-mkp .yiv1029092679ad a
{color:#ff;text-decoration:none;}#yiv1029092679 #yiv1029092679ygrp-sponsor
#yiv1029092679ygrp-lc {font-family:Arial;}#yiv1029092679
#yiv1029092679ygrp-sponsor #yiv1029092679ygrp-lc #yiv1029092679hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1029092679
#yiv1029092679ygrp-sponsor #yiv1029092679ygrp-lc .yiv1029092679ad
{margin-bottom:10px;padding:0 0;}#yiv1029092679 #yiv1029092679actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1029092679
#yiv1029092679activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1029092679
#yiv1029092679activity span {font-weight:700;}#yiv1029092679
#yiv1029092679activity span:first-child
{text-transform:uppercase;}#yiv1029092679 #yiv1029092679activity span a
{color:#5085b6;text-decoration:none;}#yiv1029092679 #yiv1029092679activity span
span {color:#ff7900;}#yiv1029092679 #yiv1029092679activity span
.yiv1029092679underline {text-decoration:underline;}#yiv1029092679
.yiv1029092679attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv1029092679 .yiv1029092679attach div a
{text-decoration:none;}#yiv1029092679 .yiv1029092679attach img
{border:none;padding-right:5px;}#yiv1029092679 .yiv1029092679attach label
{display:block;margin-bottom:5px;}#yiv1029092679 .yiv1029092679attach label a
{text-decoration:none;}#yiv1029092679 blockquote {margin:0 0 0
4px;}#yiv1029092679 .yiv1029092679bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv1029092679
.yiv1029092679bold a {text-decoration:none;}#yiv1029092679 dd.yiv1029092679last
p a {font-family:Verdana;font-weight:700;}#yiv1029092679 dd.yiv1029092679last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1029092679
dd.yiv1029092679last p span.yiv1029092679yshortcuts
{margin-right:0;}#yiv1029092679 div.yiv1029092679attach-table div div a
{text-decoration:none;}#yiv1029092679 div.yiv1029092679attach-table
{width:400px;}#yiv1029092679 div.yiv1029092679file-title a, #yiv1029092679
div.yiv1029092679file-title a:active, #yiv1029092679
div.yiv1029092679file-title a:hover, #yiv1029092679 div.yiv1029092679file-title
a:visited {text-decoration:none;}#yiv1029092679 div.yiv1029092679photo-title a,
#yiv1029092679 div.yiv1029092679photo-title
Re: [belajar-excel] Mohon bantuan jumlah data
Penyebabnya:- Formula untuk menghitung usia dalam jumlah tahun harusnya
dibulatkan (hasil aslinya masih berupa desimal; jadi bukan 36, tapi 35.8)-
Formuls untuk menghitung jumlah data per-usia dibuat variabel usianya
berdasarkan kolom H
Sandy
On Sunday, April 19, 2020, 6:27:13 PM GMT+8, 'P. Fajar Pratidina'
fajar22@gmail.com [belajar-excel] wrote:
Dear para suhu, teman n brother,
Saya lagi belajar neh,
Mohon bantuan hitung jumlah data per umur, saya coba rumus tidak bisa muncul
(data saya ambil di cell yang juga pake rumus, apakah penyebanya itu ya?)
Note : Cell yang diblok warna kuning
Regards,
Fajar #yiv6231215098 #yiv6231215098 -- #yiv6231215098ygrp-mkp {border:1px
solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6231215098
#yiv6231215098ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6231215098
#yiv6231215098ygrp-mkp #yiv6231215098hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv6231215098 #yiv6231215098ygrp-mkp #yiv6231215098ads
{margin-bottom:10px;}#yiv6231215098 #yiv6231215098ygrp-mkp .yiv6231215098ad
{padding:0 0;}#yiv6231215098 #yiv6231215098ygrp-mkp .yiv6231215098ad p
{margin:0;}#yiv6231215098 #yiv6231215098ygrp-mkp .yiv6231215098ad a
{color:#ff;text-decoration:none;}#yiv6231215098 #yiv6231215098ygrp-sponsor
#yiv6231215098ygrp-lc {font-family:Arial;}#yiv6231215098
#yiv6231215098ygrp-sponsor #yiv6231215098ygrp-lc #yiv6231215098hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6231215098
#yiv6231215098ygrp-sponsor #yiv6231215098ygrp-lc .yiv6231215098ad
{margin-bottom:10px;padding:0 0;}#yiv6231215098 #yiv6231215098actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6231215098
#yiv6231215098activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6231215098
#yiv6231215098activity span {font-weight:700;}#yiv6231215098
#yiv6231215098activity span:first-child
{text-transform:uppercase;}#yiv6231215098 #yiv6231215098activity span a
{color:#5085b6;text-decoration:none;}#yiv6231215098 #yiv6231215098activity span
span {color:#ff7900;}#yiv6231215098 #yiv6231215098activity span
.yiv6231215098underline {text-decoration:underline;}#yiv6231215098
.yiv6231215098attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv6231215098 .yiv6231215098attach div a
{text-decoration:none;}#yiv6231215098 .yiv6231215098attach img
{border:none;padding-right:5px;}#yiv6231215098 .yiv6231215098attach label
{display:block;margin-bottom:5px;}#yiv6231215098 .yiv6231215098attach label a
{text-decoration:none;}#yiv6231215098 blockquote {margin:0 0 0
4px;}#yiv6231215098 .yiv6231215098bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv6231215098
.yiv6231215098bold a {text-decoration:none;}#yiv6231215098 dd.yiv6231215098last
p a {font-family:Verdana;font-weight:700;}#yiv6231215098 dd.yiv6231215098last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6231215098
dd.yiv6231215098last p span.yiv6231215098yshortcuts
{margin-right:0;}#yiv6231215098 div.yiv6231215098attach-table div div a
{text-decoration:none;}#yiv6231215098 div.yiv6231215098attach-table
{width:400px;}#yiv6231215098 div.yiv6231215098file-title a, #yiv6231215098
div.yiv6231215098file-title a:active, #yiv6231215098
div.yiv6231215098file-title a:hover, #yiv6231215098 div.yiv6231215098file-title
a:visited {text-decoration:none;}#yiv6231215098 div.yiv6231215098photo-title a,
#yiv6231215098 div.yiv6231215098photo-title a:active, #yiv6231215098
div.yiv6231215098photo-title a:hover, #yiv6231215098
div.yiv6231215098photo-title a:visited {text-decoration:none;}#yiv6231215098
div#yiv6231215098ygrp-mlmsg #yiv6231215098ygrp-msg p a
span.yiv6231215098yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6231215098
.yiv6231215098green {color:#628c2a;}#yiv6231215098 .yiv6231215098MsoNormal
{margin:0 0 0 0;}#yiv6231215098 o {font-size:0;}#yiv6231215098
#yiv6231215098photos div {float:left;width:72px;}#yiv6231215098
#yiv6231215098photos div div {border:1px solid
#66;min-height:62px;overflow:hidden;width:62px;}#yiv6231215098
#yiv6231215098photos div label
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6231215098
#yiv6231215098reco-category {font-size:77%;}#yiv6231215098
#yiv6231215098reco-desc {font-size:77%;}#yiv6231215098 .yiv6231215098replbq
{margin:4px;}#yiv6231215098 #yiv6231215098ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv6231215098 #yiv6231215098ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6231215098
#yiv6231215098ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6231215098
#yiv6231215098ygrp-mlmsg select, #yiv6231215098 input, #yiv6231215098 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv6231215098
#yiv6231215098ygrp-mlmsg pre, #yiv6231215098 code
Re: [belajar-excel] BANTUAN CARI RUMUS
Barangkali bisa membantu
Sandy
On Tuesday, February 18, 2020, 6:09:56 PM GMT+8, aris sarman farici
rasio_ce...@yahoo.com [belajar-excel] wrote:
Dear Para Master Excel,
semoga dalam keadaan sehat selalu,
mohon bantuannya untuk mencari rumus yang tepat untuk masalah pada file
terlampir.
Demikian,
Salam,-aris-
#yiv0560123519 #yiv0560123519 -- #yiv0560123519ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0560123519
#yiv0560123519ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0560123519
#yiv0560123519ygrp-mkp #yiv0560123519hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv0560123519 #yiv0560123519ygrp-mkp #yiv0560123519ads
{margin-bottom:10px;}#yiv0560123519 #yiv0560123519ygrp-mkp .yiv0560123519ad
{padding:0 0;}#yiv0560123519 #yiv0560123519ygrp-mkp .yiv0560123519ad p
{margin:0;}#yiv0560123519 #yiv0560123519ygrp-mkp .yiv0560123519ad a
{color:#ff;text-decoration:none;}#yiv0560123519 #yiv0560123519ygrp-sponsor
#yiv0560123519ygrp-lc {font-family:Arial;}#yiv0560123519
#yiv0560123519ygrp-sponsor #yiv0560123519ygrp-lc #yiv0560123519hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0560123519
#yiv0560123519ygrp-sponsor #yiv0560123519ygrp-lc .yiv0560123519ad
{margin-bottom:10px;padding:0 0;}#yiv0560123519 #yiv0560123519actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0560123519
#yiv0560123519activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0560123519
#yiv0560123519activity span {font-weight:700;}#yiv0560123519
#yiv0560123519activity span:first-child
{text-transform:uppercase;}#yiv0560123519 #yiv0560123519activity span a
{color:#5085b6;text-decoration:none;}#yiv0560123519 #yiv0560123519activity span
span {color:#ff7900;}#yiv0560123519 #yiv0560123519activity span
.yiv0560123519underline {text-decoration:underline;}#yiv0560123519
.yiv0560123519attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv0560123519 .yiv0560123519attach div a
{text-decoration:none;}#yiv0560123519 .yiv0560123519attach img
{border:none;padding-right:5px;}#yiv0560123519 .yiv0560123519attach label
{display:block;margin-bottom:5px;}#yiv0560123519 .yiv0560123519attach label a
{text-decoration:none;}#yiv0560123519 blockquote {margin:0 0 0
4px;}#yiv0560123519 .yiv0560123519bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv0560123519
.yiv0560123519bold a {text-decoration:none;}#yiv0560123519 dd.yiv0560123519last
p a {font-family:Verdana;font-weight:700;}#yiv0560123519 dd.yiv0560123519last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0560123519
dd.yiv0560123519last p span.yiv0560123519yshortcuts
{margin-right:0;}#yiv0560123519 div.yiv0560123519attach-table div div a
{text-decoration:none;}#yiv0560123519 div.yiv0560123519attach-table
{width:400px;}#yiv0560123519 div.yiv0560123519file-title a, #yiv0560123519
div.yiv0560123519file-title a:active, #yiv0560123519
div.yiv0560123519file-title a:hover, #yiv0560123519 div.yiv0560123519file-title
a:visited {text-decoration:none;}#yiv0560123519 div.yiv0560123519photo-title a,
#yiv0560123519 div.yiv0560123519photo-title a:active, #yiv0560123519
div.yiv0560123519photo-title a:hover, #yiv0560123519
div.yiv0560123519photo-title a:visited {text-decoration:none;}#yiv0560123519
div#yiv0560123519ygrp-mlmsg #yiv0560123519ygrp-msg p a
span.yiv0560123519yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0560123519
.yiv0560123519green {color:#628c2a;}#yiv0560123519 .yiv0560123519MsoNormal
{margin:0 0 0 0;}#yiv0560123519 o {font-size:0;}#yiv0560123519
#yiv0560123519photos div {float:left;width:72px;}#yiv0560123519
#yiv0560123519photos div div {border:1px solid
#66;min-height:62px;overflow:hidden;width:62px;}#yiv0560123519
#yiv0560123519photos div label
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0560123519
#yiv0560123519reco-category {font-size:77%;}#yiv0560123519
#yiv0560123519reco-desc {font-size:77%;}#yiv0560123519 .yiv0560123519replbq
{margin:4px;}#yiv0560123519 #yiv0560123519ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv0560123519 #yiv0560123519ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0560123519
#yiv0560123519ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0560123519
#yiv0560123519ygrp-mlmsg select, #yiv0560123519 input, #yiv0560123519 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv0560123519
#yiv0560123519ygrp-mlmsg pre, #yiv0560123519 code {font:115%
monospace;}#yiv0560123519 #yiv0560123519ygrp-mlmsg *
{line-height:1.22em;}#yiv0560123519 #yiv0560123519ygrp-mlmsg #yiv0560123519logo
{padding-bottom:10px;}#yiv0560123519 #yiv0560123519ygrp-msg p a
{font-family:Verdana;}#yiv0560123519 #yiv0560123519ygrp-msg
p#yiv0560123519attach-count span
Re: [belajar-excel] Seleksi Range dari sheet berbeda [1 Attachment]
Seperti ini ya
Sandy
On Friday, October 4, 2019, 04:10:14 PM GMT+8, Abid Kausar
muha...@gmail.com [belajar-excel] wrote:
Dear Para Suhu,
mohon bantuannya Suhu.., saya punya data yang harus dijalankan dengan makro.
Data terdiri dari 2 Sheet, Sheet pertama master data, sheet kedua data
olahanyang ingin saya tanyakan ke para suhu, bagiamana caranya data di sheet
pertama pindah ke sheet dua dengan menggunakan makro. dengan catatan makro yang
digunakan bukan record makro...
berikut saya lampirkan di attachment contoh datanya
mohon maaf jika ada kata2 yang salah dan tidak berkenan...
Salam,Muhabka #yiv2583187408 #yiv2583187408 -- #yiv2583187408ygrp-mkp
{border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0
10px;}#yiv2583187408 #yiv2583187408ygrp-mkp hr {border:1px solid
#d8d8d8;}#yiv2583187408 #yiv2583187408ygrp-mkp #yiv2583187408hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv2583187408 #yiv2583187408ygrp-mkp #yiv2583187408ads
{margin-bottom:10px;}#yiv2583187408 #yiv2583187408ygrp-mkp .yiv2583187408ad
{padding:0 0;}#yiv2583187408 #yiv2583187408ygrp-mkp .yiv2583187408ad p
{margin:0;}#yiv2583187408 #yiv2583187408ygrp-mkp .yiv2583187408ad a
{color:#ff;text-decoration:none;}#yiv2583187408 #yiv2583187408ygrp-sponsor
#yiv2583187408ygrp-lc {font-family:Arial;}#yiv2583187408
#yiv2583187408ygrp-sponsor #yiv2583187408ygrp-lc #yiv2583187408hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2583187408
#yiv2583187408ygrp-sponsor #yiv2583187408ygrp-lc .yiv2583187408ad
{margin-bottom:10px;padding:0 0;}#yiv2583187408 #yiv2583187408actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2583187408
#yiv2583187408activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2583187408
#yiv2583187408activity span {font-weight:700;}#yiv2583187408
#yiv2583187408activity span:first-child
{text-transform:uppercase;}#yiv2583187408 #yiv2583187408activity span a
{color:#5085b6;text-decoration:none;}#yiv2583187408 #yiv2583187408activity span
span {color:#ff7900;}#yiv2583187408 #yiv2583187408activity span
.yiv2583187408underline {text-decoration:underline;}#yiv2583187408
.yiv2583187408attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv2583187408 .yiv2583187408attach div a
{text-decoration:none;}#yiv2583187408 .yiv2583187408attach img
{border:none;padding-right:5px;}#yiv2583187408 .yiv2583187408attach label
{display:block;margin-bottom:5px;}#yiv2583187408 .yiv2583187408attach label a
{text-decoration:none;}#yiv2583187408 blockquote {margin:0 0 0
4px;}#yiv2583187408 .yiv2583187408bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv2583187408
.yiv2583187408bold a {text-decoration:none;}#yiv2583187408 dd.yiv2583187408last
p a {font-family:Verdana;font-weight:700;}#yiv2583187408 dd.yiv2583187408last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2583187408
dd.yiv2583187408last p span.yiv2583187408yshortcuts
{margin-right:0;}#yiv2583187408 div.yiv2583187408attach-table div div a
{text-decoration:none;}#yiv2583187408 div.yiv2583187408attach-table
{width:400px;}#yiv2583187408 div.yiv2583187408file-title a, #yiv2583187408
div.yiv2583187408file-title a:active, #yiv2583187408
div.yiv2583187408file-title a:hover, #yiv2583187408 div.yiv2583187408file-title
a:visited {text-decoration:none;}#yiv2583187408 div.yiv2583187408photo-title a,
#yiv2583187408 div.yiv2583187408photo-title a:active, #yiv2583187408
div.yiv2583187408photo-title a:hover, #yiv2583187408
div.yiv2583187408photo-title a:visited {text-decoration:none;}#yiv2583187408
div#yiv2583187408ygrp-mlmsg #yiv2583187408ygrp-msg p a
span.yiv2583187408yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2583187408
.yiv2583187408green {color:#628c2a;}#yiv2583187408 .yiv2583187408MsoNormal
{margin:0 0 0 0;}#yiv2583187408 o {font-size:0;}#yiv2583187408
#yiv2583187408photos div {float:left;width:72px;}#yiv2583187408
#yiv2583187408photos div div {border:1px solid
#66;min-height:62px;overflow:hidden;width:62px;}#yiv2583187408
#yiv2583187408photos div label
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2583187408
#yiv2583187408reco-category {font-size:77%;}#yiv2583187408
#yiv2583187408reco-desc {font-size:77%;}#yiv2583187408 .yiv2583187408replbq
{margin:4px;}#yiv2583187408 #yiv2583187408ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv2583187408 #yiv2583187408ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2583187408
#yiv2583187408ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2583187408
#yiv2583187408ygrp-mlmsg select, #yiv2583187408 input, #yiv2583187408 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv2583187408
#yiv2583187408ygrp-mlmsg pre, #yiv2583187408 code {font:115%
Re: [belajar-excel] Mengubah Nilai Angka dari Rumus Menjadi Text [1 Attachment]
Masih valid untuk angka kurang dari 1 trilyun
Sandy
On Sunday, September 29, 2019, 08:24:10 AM GMT+7, Cari Kebenaran
cahayailm...@gmail.com [belajar-excel] wrote:
Terima kasih atas tanggapannya. Ya, saya ingin pemisah ribuannya jadi titik
seperti yang dipakai Indonesia.
On Fri, Sep 27, 2019 at 5:21 PM 'Mr. Kid' mr.nm...@gmail.com [belajar-excel]
wrote:
wa'alaikumussalam wr wb
Boleh tahu kenapa diubah jadi bertipe text ? Apakah karena supaya pemisah
ribuannya jadi titik seperti yang dipakai Indonesia ?
On Fri, Sep 27, 2019 at 4:59 PM Cari Kebenaran cahayailm...@gmail.com
[belajar-excel] wrote:
Assalamu'alaikum Wr. Wb.
Para master dan anggota milis yang saya hormati. Tolong dibantu untuk keperluan
saya.
Saya ingin mengubah nilai angka pada suatu range yang dihasilkan dari rumus
menjadi berformat text tanpa menghilangkan tanda titik (.) sebagai separator
ribuannya. Selengkapnya silakan lihat lampiran.
Atas perhatian dan bantuannya saya ucapkan terima kasih
#yiv6289568488 #yiv6289568488 -- #yiv6289568488ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6289568488
#yiv6289568488ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6289568488
#yiv6289568488ygrp-mkp #yiv6289568488hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv6289568488 #yiv6289568488ygrp-mkp #yiv6289568488ads
{margin-bottom:10px;}#yiv6289568488 #yiv6289568488ygrp-mkp .yiv6289568488ad
{padding:0 0;}#yiv6289568488 #yiv6289568488ygrp-mkp .yiv6289568488ad p
{margin:0;}#yiv6289568488 #yiv6289568488ygrp-mkp .yiv6289568488ad a
{color:#ff;text-decoration:none;}#yiv6289568488 #yiv6289568488ygrp-sponsor
#yiv6289568488ygrp-lc {font-family:Arial;}#yiv6289568488
#yiv6289568488ygrp-sponsor #yiv6289568488ygrp-lc #yiv6289568488hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6289568488
#yiv6289568488ygrp-sponsor #yiv6289568488ygrp-lc .yiv6289568488ad
{margin-bottom:10px;padding:0 0;}#yiv6289568488 #yiv6289568488actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6289568488
#yiv6289568488activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6289568488
#yiv6289568488activity span {font-weight:700;}#yiv6289568488
#yiv6289568488activity span:first-child
{text-transform:uppercase;}#yiv6289568488 #yiv6289568488activity span a
{color:#5085b6;text-decoration:none;}#yiv6289568488 #yiv6289568488activity span
span {color:#ff7900;}#yiv6289568488 #yiv6289568488activity span
.yiv6289568488underline {text-decoration:underline;}#yiv6289568488
.yiv6289568488attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv6289568488 .yiv6289568488attach div a
{text-decoration:none;}#yiv6289568488 .yiv6289568488attach img
{border:none;padding-right:5px;}#yiv6289568488 .yiv6289568488attach label
{display:block;margin-bottom:5px;}#yiv6289568488 .yiv6289568488attach label a
{text-decoration:none;}#yiv6289568488 blockquote {margin:0 0 0
4px;}#yiv6289568488 .yiv6289568488bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv6289568488
.yiv6289568488bold a {text-decoration:none;}#yiv6289568488 dd.yiv6289568488last
p a {font-family:Verdana;font-weight:700;}#yiv6289568488 dd.yiv6289568488last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6289568488
dd.yiv6289568488last p span.yiv6289568488yshortcuts
{margin-right:0;}#yiv6289568488 div.yiv6289568488attach-table div div a
{text-decoration:none;}#yiv6289568488 div.yiv6289568488attach-table
{width:400px;}#yiv6289568488 div.yiv6289568488file-title a, #yiv6289568488
div.yiv6289568488file-title a:active, #yiv6289568488
div.yiv6289568488file-title a:hover, #yiv6289568488 div.yiv6289568488file-title
a:visited {text-decoration:none;}#yiv6289568488 div.yiv6289568488photo-title a,
#yiv6289568488 div.yiv6289568488photo-title a:active, #yiv6289568488
div.yiv6289568488photo-title a:hover, #yiv6289568488
div.yiv6289568488photo-title a:visited {text-decoration:none;}#yiv6289568488
div#yiv6289568488ygrp-mlmsg #yiv6289568488ygrp-msg p a
span...yiv6289568488yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6289568488
.yiv6289568488green {color:#628c2a;}#yiv6289568488 .yiv6289568488MsoNormal
{margin:0 0 0 0;}#yiv6289568488 o {font-size:0;}#yiv6289568488
#yiv6289568488photos div {float:left;width:72px;}#yiv6289568488
#yiv6289568488photos div div {border:1px solid
#66;min-height:62px;overflow:hidden;width:62px;}#yiv6289568488
#yiv6289568488photos div label
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6289568488
#yiv6289568488reco-category {font-size:77%;}#yiv6289568488
#yiv6289568488reco-desc {font-size:77%;}#yiv6289568488 .yiv6289568488replbq
{margin:4px;}#yiv6289568488 #yiv6289568488ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv6289568488
Re: [belajar-excel] Fw: [belajar excel] Mencari data pada table
Mungkin begini saja?
Sandy
On Sunday, September 29, 2019, 08:23:37 AM GMT+7, jackie yunianto
tanfidzula...@yahoo.co.id [belajar-excel] wrote:
Dear all
Mohon dibantu, siapa tau terlewat. Atau memang hal ini tidak mungkin dilakukan
via rumus excel?
Sent from Yahoo Mail on Android
- Forwarded Message - From: "jackie yunianto"
To: "BeExcel" Cc:
Sent: Mon, Sep 16, 2019 at 11:00 Subject: [belajar excel] Mencari data pada
table Dear all,
Mohon dibantu.
Saya mempunyai table seperti berikut. 1. List nilai mahasiswa dan mata kuliah
nya2. Mata Kuliah wajib
Yg ingin dicari adalah bagaimana dengan 2 table tersebut dapat di ketahui :1.
Mahasiswa yang Nilai nya belum lengkap 2. Mata kuliah yg belum ada nilainya
Sent from Yahoo Mail on Android
#yiv2528400293 #yiv2528400293 -- #yiv2528400293ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2528400293
#yiv2528400293ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2528400293
#yiv2528400293ygrp-mkp #yiv2528400293hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv2528400293 #yiv2528400293ygrp-mkp #yiv2528400293ads
{margin-bottom:10px;}#yiv2528400293 #yiv2528400293ygrp-mkp .yiv2528400293ad
{padding:0 0;}#yiv2528400293 #yiv2528400293ygrp-mkp .yiv2528400293ad p
{margin:0;}#yiv2528400293 #yiv2528400293ygrp-mkp .yiv2528400293ad a
{color:#ff;text-decoration:none;}#yiv2528400293 #yiv2528400293ygrp-sponsor
#yiv2528400293ygrp-lc {font-family:Arial;}#yiv2528400293
#yiv2528400293ygrp-sponsor #yiv2528400293ygrp-lc #yiv2528400293hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2528400293
#yiv2528400293ygrp-sponsor #yiv2528400293ygrp-lc .yiv2528400293ad
{margin-bottom:10px;padding:0 0;}#yiv2528400293 #yiv2528400293actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2528400293
#yiv2528400293activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2528400293
#yiv2528400293activity span {font-weight:700;}#yiv2528400293
#yiv2528400293activity span:first-child
{text-transform:uppercase;}#yiv2528400293 #yiv2528400293activity span a
{color:#5085b6;text-decoration:none;}#yiv2528400293 #yiv2528400293activity span
span {color:#ff7900;}#yiv2528400293 #yiv2528400293activity span
.yiv2528400293underline {text-decoration:underline;}#yiv2528400293
.yiv2528400293attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv2528400293 .yiv2528400293attach div a
{text-decoration:none;}#yiv2528400293 .yiv2528400293attach img
{border:none;padding-right:5px;}#yiv2528400293 ...yiv2528400293attach label
{display:block;margin-bottom:5px;}#yiv2528400293 .yiv2528400293attach label a
{text-decoration:none;}#yiv2528400293 blockquote {margin:0 0 0
4px;}#yiv2528400293 .yiv2528400293bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv2528400293
.yiv2528400293bold a {text-decoration:none;}#yiv2528400293 dd.yiv2528400293last
p a {font-family:Verdana;font-weight:700;}#yiv2528400293 dd.yiv2528400293last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2528400293
dd.yiv2528400293last p span.yiv2528400293yshortcuts
{margin-right:0;}#yiv2528400293 div.yiv2528400293attach-table div div a
{text-decoration:none;}#yiv2528400293 div.yiv2528400293attach-table
{width:400px;}#yiv2528400293 div.yiv2528400293file-title a, #yiv2528400293
div.yiv2528400293file-title a:active, #yiv2528400293
div.yiv2528400293file-title a:hover, #yiv2528400293 div.yiv2528400293file-title
a:visited {text-decoration:none;}#yiv2528400293 div.yiv2528400293photo-title a,
#yiv2528400293 div.yiv2528400293photo-title a:active, #yiv2528400293
div.yiv2528400293photo-title a:hover, #yiv2528400293
div.yiv2528400293photo-title a:visited {text-decoration:none;}#yiv2528400293
div#yiv2528400293ygrp-mlmsg #yiv2528400293ygrp-msg p a
span.yiv2528400293yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2528400293
.yiv2528400293green {color:#628c2a;}#yiv2528400293 .yiv2528400293MsoNormal
{margin:0 0 0 0;}#yiv2528400293 o {font-size:0;}#yiv2528400293
#yiv2528400293photos div {float:left;width:72px;}#yiv2528400293
#yiv2528400293photos div div {border:1px solid
#66;min-height:62px;overflow:hidden;width:62px;}#yiv2528400293
#yiv2528400293photos div label
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2528400293
#yiv2528400293reco-category {font-size:77%;}#yiv2528400293
#yiv2528400293reco-desc {font-size:77%;}#yiv2528400293 .yiv2528400293replbq
{margin:4px;}#yiv2528400293 #yiv2528400293ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv2528400293 #yiv2528400293ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2528400293
#yiv2528400293ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2528400293
#yiv2528400293ygrp-mlmsg select, #yiv2528400293
