[belajar-excel] Digest Number 4359

Milis Belajar Microsoft Excel Group

7 Messages

Digest #4359

1a

Bls: [belajar-excel] Tanya_Menyerderhanakan data [1 Attachment] by "odong nando"

2a

Re: Problem Excel by "Anwar Tarigan"

2b

Problem Excel by "Anwar Tarigan"

2c

Re: Problem Excel [1 Attachment] by "hendrik karnadi" hendrikkarnadi

3a

Re: SORT [1 Attachment] by "M FATHIAN" fathianm

4a

Re: Listbox, Combobox, dan Textbox [1 Attachment] by "Mr. Kid" nmkid.family@ymail.com

4b

Re: Listbox, Combobox, dan Textbox [1 Attachment] by "Sony Ario"

Messages

1a

Bls: [belajar-excel] Tanya_Menyerderhanakan data [1 Attachment]

Thu Nov 23, 2017 4:29 pm (PST) . Posted by:

"odong nando"

hai MH,
terlampir fariasi yang bisa di manfaatkan, selain dari yang telah di jabarkan boz kid...
formula terlampir jg atas arahan boz kid terdahulu, cuma mungkin boz kid mau kasih cara lain, sehingga terbukalah wawasan qt...
:)
 br,

odong nando

Dari: "'Mr. Kid' mr.nmkid@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com>
Kepada: BeExcel <belajar-excel@yahoogroups.com>
Dikirim: Jumat, 17 November 2017 14:05
Judul: Re: [belajar-excel] Tanya_Menyerderhanakan data [1 Attachment]

  Hai MH,

Kira-kira seperti file terlampir.

Regards,
Kid

2017-11-16 12:59 GMT+07:00 muhammad hendra robertmart77@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com>:

  Dear Para Suhu Excel
semoga dalam keadaan sehat.
Mohon bantuan untuk file terlampir,
pertanyaan saya, bagaimana cara menggabungkan hasil look-up dengan satu referensi tetapi dengan hasil yang sudah digabungkan di cell yang diinginkan
Terima kasih sebelumnya atas bantuannya
mh


#yiv7409734432 #yiv7409734432 -- #yiv7409734432ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7409734432 #yiv7409734432ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7409734432 #yiv7409734432ygrp-mkp #yiv7409734432hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7409734432 #yiv7409734432ygrp-mkp #yiv7409734432ads {margin-bottom:10px;}#yiv7409734432 #yiv7409734432ygrp-mkp .yiv7409734432ad {padding:0 0;}#yiv7409734432 #yiv7409734432ygrp-mkp .yiv7409734432ad p {margin:0;}#yiv7409734432 #yiv7409734432ygrp-mkp .yiv7409734432ad a {color:#0000ff;text-decoration:none;}#yiv7409734432 #yiv7409734432ygrp-sponsor #yiv7409734432ygrp-lc {font-family:Arial;}#yiv7409734432 #yiv7409734432ygrp-sponsor #yiv7409734432ygrp-lc #yiv7409734432hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7409734432 #yiv7409734432ygrp-sponsor #yiv7409734432ygrp-lc .yiv7409734432ad {margin-bottom:10px;padding:0 0;}#yiv7409734432 #yiv7409734432actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7409734432 #yiv7409734432activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7409734432 #yiv7409734432activity span {font-weight:700;}#yiv7409734432 #yiv7409734432activity span:first-child {text-transform:uppercase;}#yiv7409734432 #yiv7409734432activity span a {color:#5085b6;text-decoration:none;}#yiv7409734432 #yiv7409734432activity span span {color:#ff7900;}#yiv7409734432 #yiv7409734432activity span .yiv7409734432underline {text-decoration:underline;}#yiv7409734432 .yiv7409734432attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7409734432 .yiv7409734432attach div a {text-decoration:none;}#yiv7409734432 .yiv7409734432attach img {border:none;padding-right:5px;}#yiv7409734432 .yiv7409734432attach label {display:block;margin-bottom:5px;}#yiv7409734432 .yiv7409734432attach label a {text-decoration:none;}#yiv7409734432 blockquote {margin:0 0 0 4px;}#yiv7409734432 .yiv7409734432bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7409734432 .yiv7409734432bold a {text-decoration:none;}#yiv7409734432 dd.yiv7409734432last p a {font-family:Verdana;font-weight:700;}#yiv7409734432 dd.yiv7409734432last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7409734432 dd.yiv7409734432last p span.yiv7409734432yshortcuts {margin-right:0;}#yiv7409734432 div.yiv7409734432attach-table div div a {text-decoration:none;}#yiv7409734432 div.yiv7409734432attach-table {width:400px;}#yiv7409734432 div.yiv7409734432file-title a, #yiv7409734432 div.yiv7409734432file-title a:active, #yiv7409734432 div.yiv7409734432file-title a:hover, #yiv7409734432 div.yiv7409734432file-title a:visited {text-decoration:none;}#yiv7409734432 div.yiv7409734432photo-title a, #yiv7409734432 div.yiv7409734432photo-title a:active, #yiv7409734432 div.yiv7409734432photo-title a:hover, #yiv7409734432 div.yiv7409734432photo-title a:visited {text-decoration:none;}#yiv7409734432 div#yiv7409734432ygrp-mlmsg #yiv7409734432ygrp-msg p a span.yiv7409734432yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7409734432 .yiv7409734432green {color:#628c2a;}#yiv7409734432 .yiv7409734432MsoNormal {margin:0 0 0 0;}#yiv7409734432 o {font-size:0;}#yiv7409734432 #yiv7409734432photos div {float:left;width:72px;}#yiv7409734432 #yiv7409734432photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv7409734432 #yiv7409734432photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7409734432 #yiv7409734432reco-category {font-size:77%;}#yiv7409734432 #yiv7409734432reco-desc {font-size:77%;}#yiv7409734432 .yiv7409734432replbq {margin:4px;}#yiv7409734432 #yiv7409734432ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv7409734432 #yiv7409734432ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7409734432 #yiv7409734432ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7409734432 #yiv7409734432ygrp-mlmsg select, #yiv7409734432 input, #yiv7409734432 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv7409734432 #yiv7409734432ygrp-mlmsg pre, #yiv7409734432 code {font:115% monospace;}#yiv7409734432 #yiv7409734432ygrp-mlmsg * {line-height:1.22em;}#yiv7409734432 #yiv7409734432ygrp-mlmsg #yiv7409734432logo {padding-bottom:10px;}#yiv7409734432 #yiv7409734432ygrp-msg p a {font-family:Verdana;}#yiv7409734432 #yiv7409734432ygrp-msg p#yiv7409734432attach-count span {color:#1E66AE;font-weight:700;}#yiv7409734432 #yiv7409734432ygrp-reco #yiv7409734432reco-head {color:#ff7900;font-weight:700;}#yiv7409734432 #yiv7409734432ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7409734432 #yiv7409734432ygrp-sponsor #yiv7409734432ov li a {font-size:130%;text-decoration:none;}#yiv7409734432 #yiv7409734432ygrp-sponsor #yiv7409734432ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7409734432 #yiv7409734432ygrp-sponsor #yiv7409734432ov ul {margin:0;padding:0 0 0 8px;}#yiv7409734432 #yiv7409734432ygrp-text {font-family:Georgia;}#yiv7409734432 #yiv7409734432ygrp-text p {margin:0 0 1em 0;}#yiv7409734432 #yiv7409734432ygrp-text tt {font-size:120%;}#yiv7409734432 #yiv7409734432ygrp-vital ul li:last-child {border-right:none !important;}#yiv7409734432

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

2a

Re: Problem Excel

Thu Nov 23, 2017 4:40 pm (PST) . Posted by:

"Anwar Tarigan"

2017-11-22 15:39 GMT+07:00 Anwar Tarigan <anwartarigan@gmail.com>:

> Dear Excel member,
>
> mohon bantuannya masalah excel yang saya hadapi.
>
> terimakasih atas bantuannya.
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

2b

Problem Excel

Thu Nov 23, 2017 4:50 pm (PST) . Posted by:

"Anwar Tarigan"

Dear Excel member,

mohon bantuannya masalah excel yang saya hadapi.

terimakasih atas bantuannya.

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

2c

Re: Problem Excel [1 Attachment]

Thu Nov 23, 2017 6:33 pm (PST) . Posted by:

"hendrik karnadi" hendrikkarnadi

Hai Anwar,
Identifikasi masalah adalah bagian dari solusi, oleh karena itu inti permasalahan sebaiknya dicantumkan di body email.
Sepanjang struktur/formatnya konsisten pemepatannya maka untuk mengisi kolom L dan M bisa digunakan fungsi IF.Untuk kolom L, =If(sel rujukan <> 0, ambil nama langganan, "").Untuk kolom M, =If(sel rujukan <> 0, ambil kode langganan, "").
Nama dan Kode langganan bersifat tetap (tekan F4, atau kasi tanda $).
Selamat mencoba.

Salam,HK

On Friday, 24 November 2017, 7:52:10 AM GMT+7, Anwar Tarigan anwartarigan@gmail.com [belajar-excel] <belajar-excel@yahoogroups.com> wrote:

 

Dear Excel member,

mohon bantuannya masalah excel yang saya hadapi.

terimakasih atas bantuannya.

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

3a

Re: SORT [1 Attachment]

Thu Nov 23, 2017 4:41 pm (PST) . Posted by:

"M FATHIAN" fathianm

trimakasih Mr. Kid atas solusinya.... On Sunday, November 19, 2017, 10:05:47 AM GMT+7, 'Mr. Kid' mr.nmkid@gmail.com [belajar-excel] <belajar-excel@yahoogroups.com> wrote:

 

Hai Fathian,

Fungsi-fungsi lookup akan menghasilkan error value #N/A jika nilai yang dicari tidak ditemukan.
Itulah yang terjadi pada formula Anda.
Tentang array formula, bisa dilihat disini.

Regards,
Kid

2017-11-18 7:08 GMT+07:00 fathianm@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com>:

 

Mohon bantuanya....knapa ya setiap ada nilai yg sama di tabel warna biru pada satu baris di tabel hasil warna merah selalu N/A??? Trimakasih

File terlampir

#yiv6334745094 #yiv6334745094 -- #yiv6334745094ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6334745094 #yiv6334745094ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6334745094 #yiv6334745094ygrp-mkp #yiv6334745094hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv6334745094 #yiv6334745094ygrp-mkp #yiv6334745094ads {margin-bottom:10px;}#yiv6334745094 #yiv6334745094ygrp-mkp .yiv6334745094ad {padding:0 0;}#yiv6334745094 #yiv6334745094ygrp-mkp .yiv6334745094ad p {margin:0;}#yiv6334745094 #yiv6334745094ygrp-mkp .yiv6334745094ad a {color:#0000ff;text-decoration:none;}#yiv6334745094 #yiv6334745094ygrp-sponsor #yiv6334745094ygrp-lc {font-family:Arial;}#yiv6334745094 #yiv6334745094ygrp-sponsor #yiv6334745094ygrp-lc #yiv6334745094hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6334745094 #yiv6334745094ygrp-sponsor #yiv6334745094ygrp-lc .yiv6334745094ad {margin-bottom:10px;padding:0 0;}#yiv6334745094 #yiv6334745094actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6334745094 #yiv6334745094activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6334745094 #yiv6334745094activity span {font-weight:700;}#yiv6334745094 #yiv6334745094activity span:first-child {text-transform:uppercase;}#yiv6334745094 #yiv6334745094activity span a {color:#5085b6;text-decoration:none;}#yiv6334745094 #yiv6334745094activity span span {color:#ff7900;}#yiv6334745094 #yiv6334745094activity span .yiv6334745094underline {text-decoration:underline;}#yiv6334745094 .yiv6334745094attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv6334745094 .yiv6334745094attach div a {text-decoration:none;}#yiv6334745094 .yiv6334745094attach img {border:none;padding-right:5px;}#yiv6334745094 .yiv6334745094attach label {display:block;margin-bottom:5px;}#yiv6334745094 .yiv6334745094attach label a {text-decoration:none;}#yiv6334745094 blockquote {margin:0 0 0 4px;}#yiv6334745094 .yiv6334745094bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv6334745094 .yiv6334745094bold a {text-decoration:none;}#yiv6334745094 dd.yiv6334745094last p a {font-family:Verdana;font-weight:700;}#yiv6334745094 dd.yiv6334745094last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6334745094 dd.yiv6334745094last p span.yiv6334745094yshortcuts {margin-right:0;}#yiv6334745094 div.yiv6334745094attach-table div div a {text-decoration:none;}#yiv6334745094 div.yiv6334745094attach-table {width:400px;}#yiv6334745094 div.yiv6334745094file-title a, #yiv6334745094 div.yiv6334745094file-title a:active, #yiv6334745094 div.yiv6334745094file-title a:hover, #yiv6334745094 div.yiv6334745094file-title a:visited {text-decoration:none;}#yiv6334745094 div.yiv6334745094photo-title a, #yiv6334745094 div.yiv6334745094photo-title a:active, #yiv6334745094 div.yiv6334745094photo-title a:hover, #yiv6334745094 div.yiv6334745094photo-title a:visited {text-decoration:none;}#yiv6334745094 div#yiv6334745094ygrp-mlmsg #yiv6334745094ygrp-msg p a span.yiv6334745094yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6334745094 .yiv6334745094green {color:#628c2a;}#yiv6334745094 .yiv6334745094MsoNormal {margin:0 0 0 0;}#yiv6334745094 o {font-size:0;}#yiv6334745094 #yiv6334745094photos div {float:left;width:72px;}#yiv6334745094 #yiv6334745094photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv6334745094 #yiv6334745094photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6334745094 #yiv6334745094reco-category {font-size:77%;}#yiv6334745094 #yiv6334745094reco-desc {font-size:77%;}#yiv6334745094 .yiv6334745094replbq {margin:4px;}#yiv6334745094 #yiv6334745094ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv6334745094 #yiv6334745094ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6334745094 #yiv6334745094ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6334745094 #yiv6334745094ygrp-mlmsg select, #yiv6334745094 input, #yiv6334745094 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv6334745094 #yiv6334745094ygrp-mlmsg pre, #yiv6334745094 code {font:115% monospace;}#yiv6334745094 #yiv6334745094ygrp-mlmsg * {line-height:1.22em;}#yiv6334745094 #yiv6334745094ygrp-mlmsg #yiv6334745094logo {padding-bottom:10px;}#yiv6334745094 #yiv6334745094ygrp-msg p a {font-family:Verdana;}#yiv6334745094 #yiv6334745094ygrp-msg p#yiv6334745094attach-count span {color:#1E66AE;font-weight:700;}#yiv6334745094 #yiv6334745094ygrp-reco #yiv6334745094reco-head {color:#ff7900;font-weight:700;}#yiv6334745094 #yiv6334745094ygrp-reco {margin-bottom:20px;padding:0px;}#yiv6334745094 #yiv6334745094ygrp-sponsor #yiv6334745094ov li a {font-size:130%;text-decoration:none;}#yiv6334745094 #yiv6334745094ygrp-sponsor #yiv6334745094ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv6334745094 #yiv6334745094ygrp-sponsor #yiv6334745094ov ul {margin:0;padding:0 0 0 8px;}#yiv6334745094 #yiv6334745094ygrp-text {font-family:Georgia;}#yiv6334745094 #yiv6334745094ygrp-text p {margin:0 0 1em 0;}#yiv6334745094 #yiv6334745094ygrp-text tt {font-size:120%;}#yiv6334745094 #yiv6334745094ygrp-vital ul li:last-child {border-right:none !important;}#yiv6334745094

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

4a

Re: Listbox, Combobox, dan Textbox [1 Attachment]

Thu Nov 23, 2017 4:42 pm (PST) . Posted by:

"Mr. Kid" nmkid.family@ymail.com

Hai Roni,

File terlampir.

Reagrds,
Kid

2017-11-19 14:33 GMT+07:00 y.roni35@yahoo.com [belajar-excel] <
belajar-excel@yahoogroups.com>:

>
>
> Dear Rekan-Rekan,
>
> Mohon dibantu
>
> 1. Pada List Box Akan Tampil No, Nama, Active
>
> 2. Saat Double Klik Nama Pada ListBox akan tampil nama pada TextBox dan
> active pd Combox
>
> 3. Saat di Double Klik ListBox Maka pada combox Non Active (Tampil Warna
> Merah), Pada combox Active (Tampil Warna Hijau)
>
>
> Terlampir Filenya
>
>
>
>
>
>
> Terimakasih
>
> Salam
>
> Yusuf
>
>
>
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

4b

Re: Listbox, Combobox, dan Textbox [1 Attachment]

Thu Nov 23, 2017 6:41 pm (PST) . Posted by:

"Sony Ario"

​Halo Yusuf,

Terlampir dari saya.
Mohon maaf kalau belum sesuai.

Salam
Sony​

*gnl-excelinfo.blogspot.co.id <http://gnl-excelinfo.blogspot.co.id>*

2017-11-19 14:33 GMT+07:00 y.roni35@yahoo.com [belajar-excel] <
belajar-excel@yahoogroups.com>:

>
>
> Dear Rekan-Rekan,
>
> Mohon dibantu
>
> 1. Pada List Box Akan Tampil No, Nama, Active
>
> 2. Saat Double Klik Nama Pada ListBox akan tampil nama pada TextBox dan
> active pd Combox
>
> 3. Saat di Double Klik ListBox Maka pada combox Non Active (Tampil Warna
> Merah), Pada combox Active (Tampil Warna Hijau)
>
>
> Terlampir Filenya
>
>
>
>
>
>
> Terimakasih
>
> Salam
>
> Yusuf
>
>
>
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

============================================================
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
---------------------------------------------------------------------

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use