[belajar-excel] Digest Number 4905

Milis Belajar Microsoft Excel Group

7 Messages

Digest #4905

1a

menampilkan data dengan memilih data dari List Box ActiveX Controls by "HAIRUL ALAM"

1b

Re: menampilkan data dengan memilih data dari List Box ActiveX Contr by "Sony Ario"

1c

Re: menampilkan data dengan memilih data dari List Box ActiveX Contr by "Contract Mining Assistant, Asam-Asam"

2

Huruf acak tdk berulang by indra_psr

3a

pisahkan data antara koma by "HAIRUL ALAM"

3b

Re: pisahkan data antara koma [1 Attachment] by "ghozi alkatiri" ghozialkatiri

4a

Re: hitung nilai angka diantara Text by "HAIRUL ALAM"

Messages

1a

menampilkan data dengan memilih data dari List Box ActiveX Controls

Sun Nov 24, 2019 11:29 pm (PST) . Posted by:

"HAIRUL ALAM"

Salam Member
Selamat Pagi
Semoga selalu dalam keadaan sehat
hendak membuat link data dari List Box ActiveX Controls Excel cuma belum dapat caranya.
seperti data terlampir

Mohon solusinya
Terimakasih
Assalamualaikum

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

1b

Re: menampilkan data dengan memilih data dari List Box ActiveX Contr

Mon Nov 25, 2019 12:49 am (PST) . Posted by:

"Sony Ario"

Waalaikumsalaam.

Sambil tunggu yg lain. Ini dari saya.

Difile yang saya lampirkan listbox nya hanya ada 2. Maaf saya kurang paham
knp harus ada 6 ya.

Semoga membantu.

Wassalam

On Mon, Nov 25, 2019 at 2:30 PM HAIRUL ALAM ha_mj76@yahoo.co.id
[belajar-excel] <belajar-excel@yahoogroups.com> wrote:

>
>
> Salam Member
>
> Selamat Pagi
>
> Semoga selalu dalam keadaan sehat
>
> hendak membuat link data dari List Box ActiveX Controls Excel cuma belum
> dapat caranya.
>
> seperti data terlampir
>
> [image: Jadikan gambar sebaris]
>
>
> Mohon solusinya
>
> Terimakasih
>
> Assalamualaikum
>
>
>

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

1c

Re: menampilkan data dengan memilih data dari List Box ActiveX Contr

Mon Nov 25, 2019 2:57 am (PST) . Posted by:

"Contract Mining Assistant, Asam-Asam"

Seperti terlampir kah maksudnya.
Source data mengacu pada column D.

Salam, Rasyid

From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: Monday, November 25, 2019 12:27 PM
To: belajar-excel@yahoogroups.com
Subject: [belajar-excel] menampilkan data dengan memilih data dari List Box ActiveX Controls [2 Attachments]


Salam Member

Selamat Pagi

Semoga selalu dalam keadaan sehat

hendak membuat link data dari List Box ActiveX Controls Excel cuma belum dapat caranya.

seperti data terlampir

[Jadikan gambar sebaris]

Mohon solusinya

Terimakasih

Assalamualaikum

Disclaimer - This message including any attachments and information contained
herein ("Message"; ) may contain privileged information or otherwise is protected
from disclosure. Any unauthorized use of this Message by any person may lead to
legal consequences. If you receive this Message in error, or if the recipient
of this Message is not the intended recipient or the employee or agent authorized
for delivering this Message to the intended recipient you are hereby notified that
any disclosure, dissemination, distribution or copying of this Message or let or
cause this Message to be disclosed,disseminated, distributed, or copied is strictly
prohibited, and please notify the sender by return message and immediately delete
this Message from your system. Incoming and outgoing communications using this
electronic mail may be monitored by PT Arutmin Indonesia,as permitted by applicable
law and regulations. Unless it is made by the authorized person,any views expressed
in this Message are those of the individual sender and may not necessarily reflect
the views of PT Arutmin Indonesia.
You should check attachments for viruses and defects before opening or using them.
We are not liable to recover any injuries caused by virused or defected attachments.

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

2

Huruf acak tdk berulang

Mon Nov 25, 2019 2:56 am (PST) . Posted by:

indra_psr

Dh,

Mohon pencerahannya, jika saya mempunyai huruf :

A, C, D, F

Dari keempat huruf itu di buat huruf acak tdk berulang akan tetapi hanya 3
huruf saja yang saya inginkan, seperti :

A, C, D

D, C, F

C, D, F

A, F, C

Terimakasih

Salam,

Indra

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

3a

pisahkan data antara koma

Mon Nov 25, 2019 2:56 am (PST) . Posted by:

"HAIRUL ALAM"

Salam Master
Terlampir data seperti dibawah bagaimana RUMUS pisahkan data ;
12.230, acc 250, 6.560, m 250, 11.560, 6.400, 3.222, m 23

yang diinginkan hasil terpisah per data diantara pemisah koma menyusun row kebawah
12.230acc 2506.560m 25011.5606.4003.222m 23
Mohon Solusinya
Terimakasih
Hairul Alam

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

3b

Re: pisahkan data antara koma [1 Attachment]

Mon Nov 25, 2019 3:24 am (PST) . Posted by:

"ghozi alkatiri" ghozialkatiri

tulis di D3
=TRIM(MID(SUBSTITUTE(B$3,",",REPT(" ",LEN(B$3))),(ROW(A1)-1)*LEN(B$3)+1,LEN(B$3)))

copy ke bawah
wassalaam
Ghozi Alkatiri Pada Senin, 25 November 2019 17.57.41 WIB, HAIRUL ALAM ha_mj76@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

 

Salam Master
Terlampir data seperti dibawah bagaimana RUMUS pisahkan data ;
12.230, acc 250, 6.560, m 250, 11.560, 6.400, 3.222, m 23

yang diinginkan hasil terpisah per data diantara pemisah koma menyusun row kebawah
12.230acc 2506.560m 25011.5606.4003.222m 23
Mohon Solusinya
Terimakasih
Hairul Alam #yiv8586637638 #yiv8586637638 -- #yiv8586637638ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8586637638 #yiv8586637638ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8586637638 #yiv8586637638ygrp-mkp #yiv8586637638hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8586637638 #yiv8586637638ygrp-mkp #yiv8586637638ads {margin-bottom:10px;}#yiv8586637638 #yiv8586637638ygrp-mkp .yiv8586637638ad {padding:0 0;}#yiv8586637638 #yiv8586637638ygrp-mkp .yiv8586637638ad p {margin:0;}#yiv8586637638 #yiv8586637638ygrp-mkp .yiv8586637638ad a {color:#0000ff;text-decoration:none;}#yiv8586637638 #yiv8586637638ygrp-sponsor #yiv8586637638ygrp-lc {font-family:Arial;}#yiv8586637638 #yiv8586637638ygrp-sponsor #yiv8586637638ygrp-lc #yiv8586637638hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8586637638 #yiv8586637638ygrp-sponsor #yiv8586637638ygrp-lc ..yiv8586637638ad {margin-bottom:10px;padding:0 0;}#yiv8586637638 #yiv8586637638actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8586637638 #yiv8586637638activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8586637638 #yiv8586637638activity span {font-weight:700;}#yiv8586637638 #yiv8586637638activity span:first-child {text-transform:uppercase;}#yiv8586637638 #yiv8586637638activity span a {color:#5085b6;text-decoration:none;}#yiv8586637638 #yiv8586637638activity span span {color:#ff7900;}#yiv8586637638 #yiv8586637638activity span .yiv8586637638underline {text-decoration:underline;}#yiv8586637638 .yiv8586637638attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8586637638 .yiv8586637638attach div a {text-decoration:none;}#yiv8586637638 ..yiv8586637638attach img {border:none;padding-right:5px;}#yiv8586637638 .yiv8586637638attach label {display:block;margin-bottom:5px;}#yiv8586637638 .yiv8586637638attach label a {text-decoration:none;}#yiv8586637638 blockquote {margin:0 0 0 4px;}#yiv8586637638 .yiv8586637638bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8586637638 .yiv8586637638bold a {text-decoration:none;}#yiv8586637638 dd.yiv8586637638last p a {font-family:Verdana;font-weight:700;}#yiv8586637638 dd.yiv8586637638last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8586637638 dd.yiv8586637638last p span.yiv8586637638yshortcuts {margin-right:0;}#yiv8586637638 div.yiv8586637638attach-table div div a {text-decoration:none;}#yiv8586637638 div.yiv8586637638attach-table {width:400px;}#yiv8586637638 div.yiv8586637638file-title a, #yiv8586637638 div.yiv8586637638file-title a:active, #yiv8586637638 div.yiv8586637638file-title a:hover, #yiv8586637638 div.yiv8586637638file-title a:visited {text-decoration:none;}#yiv8586637638 div.yiv8586637638photo-title a, #yiv8586637638 div.yiv8586637638photo-title a:active, #yiv8586637638 div.yiv8586637638photo-title a:hover, #yiv8586637638 div.yiv8586637638photo-title a:visited {text-decoration:none;}#yiv8586637638 div#yiv8586637638ygrp-mlmsg #yiv8586637638ygrp-msg p a span.yiv8586637638yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8586637638 .yiv8586637638green {color:#628c2a;}#yiv8586637638 .yiv8586637638MsoNormal {margin:0 0 0 0;}#yiv8586637638 o {font-size:0;}#yiv8586637638 #yiv8586637638photos div {float:left;width:72px;}#yiv8586637638 #yiv8586637638photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv8586637638 #yiv8586637638photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8586637638 #yiv8586637638reco-category {font-size:77%;}#yiv8586637638 #yiv8586637638reco-desc {font-size:77%;}#yiv8586637638 .yiv8586637638replbq {margin:4px;}#yiv8586637638 #yiv8586637638ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8586637638 #yiv8586637638ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8586637638 #yiv8586637638ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8586637638 #yiv8586637638ygrp-mlmsg select, #yiv8586637638 input, #yiv8586637638 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8586637638 #yiv8586637638ygrp-mlmsg pre, #yiv8586637638 code {font:115% monospace;}#yiv8586637638 #yiv8586637638ygrp-mlmsg * {line-height:1.22em;}#yiv8586637638 #yiv8586637638ygrp-mlmsg #yiv8586637638logo {padding-bottom:10px;}#yiv8586637638 #yiv8586637638ygrp-msg p a {font-family:Verdana;}#yiv8586637638 #yiv8586637638ygrp-msg p#yiv8586637638attach-count span {color:#1E66AE;font-weight:700;}#yiv8586637638 #yiv8586637638ygrp-reco #yiv8586637638reco-head {color:#ff7900;font-weight:700;}#yiv8586637638 #yiv8586637638ygrp-reco {margin-bottom:20px;padding:0px;}#yiv8586637638 #yiv8586637638ygrp-sponsor #yiv8586637638ov li a {font-size:130%;text-decoration:none;}#yiv8586637638 #yiv8586637638ygrp-sponsor #yiv8586637638ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv8586637638 #yiv8586637638ygrp-sponsor #yiv8586637638ov ul {margin:0;padding:0 0 0 8px;}#yiv8586637638 #yiv8586637638ygrp-text {font-family:Georgia;}#yiv8586637638 #yiv8586637638ygrp-text p {margin:0 0 1em 0;}#yiv8586637638 #yiv8586637638ygrp-text tt {font-size:120%;}#yiv8586637638 #yiv8586637638ygrp-vital ul li:last-child {border-right:none !important;}#yiv8586637638

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

4a

Re: hitung nilai angka diantara Text

Mon Nov 25, 2019 2:58 am (PST) . Posted by:

"HAIRUL ALAM"

Salam Master 
Selamat Malam
Simple tapi cari di mbah google belum dapat, bagaimana rumus hitung nilai angka diantara text
misalkan 12.000, 4.655 yang seharusnya nilainya 16.655acc 22, rep 23 nilainya harusnya 45
Terimakasih Solusinya
Assalamualaikum
Hairul Alam

Pada Jumat, 25 Oktober 2019 08.08.08 GMT+7, HAIRUL ALAM <ha_mj76@yahoo.co.id> menulis:

Salam Member
Selamat Pagi
Simple tapi cari di mbah google belum dapat, bagaimana rumus hitung nilai angka diantara text
misalkan 12.000, 4.655 yang seharusnya nilainya 16.655acc 22, rep 23 nilainya harusnya 45
Terimakasih Solusinya
Assalamualaikum
Hairul Alam

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . 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

• Privacy • Unsubscribe • Terms of Use