[belajar-excel] Digest Number 4473

Milis Belajar Microsoft Excel Group

3 Messages

Digest #4473

1a

Re: Identifikasi Multi Drop & Multi Pick Up Shipment [1 Attachment] by "Arif Wijaya" arifw1979

2a

Re: ambil angka berbeda kondisi by "M.Ade Alfarid" aderyo

2b

Format desimal by "Heru Safrudin" heru.safrudin

Messages

1a

Re: Identifikasi Multi Drop & Multi Pick Up Shipment [1 Attachment]

Mon Apr 2, 2018 11:55 am (PDT) . Posted by:

"Arif Wijaya" arifw1979

Hai Mas EshaKlo kriterianya hanya seperti itu bisa langsung pakai fungsi Countifs

Sent from Yahoo Mail on Android

On Mon, Apr 2, 2018 at 18:10, mas_esha@yahoo.com [belajar-excel]<belajar-excel@yahoogroups.com> wrote:  
Selamat siang rekan2...

Mohon bantuan dan masukannya bagaimana cara mengidentifikasi pengiriman yang terdiri dari beberapa tujuan (multi drop), yang muat dari beberapa gudang (multi pick up), dan normal (muat di satu gudang dengan satu tujuan)

Terlampir contoh kasus dan hasil yang diharapkan..

Terimakasih atas bantuannya

Susila

#yiv1574455860 #yiv1574455860 -- #yiv1574455860ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1574455860 #yiv1574455860ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1574455860 #yiv1574455860ygrp-mkp #yiv1574455860hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv1574455860 #yiv1574455860ygrp-mkp #yiv1574455860ads {margin-bottom:10px;}#yiv1574455860 #yiv1574455860ygrp-mkp .yiv1574455860ad {padding:0 0;}#yiv1574455860 #yiv1574455860ygrp-mkp .yiv1574455860ad p {margin:0;}#yiv1574455860 #yiv1574455860ygrp-mkp .yiv1574455860ad a {color:#0000ff;text-decoration:none;}#yiv1574455860 #yiv1574455860ygrp-sponsor #yiv1574455860ygrp-lc {font-family:Arial;}#yiv1574455860 #yiv1574455860ygrp-sponsor #yiv1574455860ygrp-lc #yiv1574455860hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1574455860 #yiv1574455860ygrp-sponsor #yiv1574455860ygrp-lc .yiv1574455860ad {margin-bottom:10px;padding:0 0;}#yiv1574455860 #yiv1574455860actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1574455860 #yiv1574455860activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1574455860 #yiv1574455860activity span {font-weight:700;}#yiv1574455860 #yiv1574455860activity span:first-child {text-transform:uppercase;}#yiv1574455860 #yiv1574455860activity span a {color:#5085b6;text-decoration:none;}#yiv1574455860 #yiv1574455860activity span span {color:#ff7900;}#yiv1574455860 #yiv1574455860activity span .yiv1574455860underline {text-decoration:underline;}#yiv1574455860 .yiv1574455860attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv1574455860 .yiv1574455860attach div a {text-decoration:none;}#yiv1574455860 .yiv1574455860attach img {border:none;padding-right:5px;}#yiv1574455860 .yiv1574455860attach label {display:block;margin-bottom:5px;}#yiv1574455860 .yiv1574455860attach label a {text-decoration:none;}#yiv1574455860 blockquote {margin:0 0 0 4px;}#yiv1574455860 .yiv1574455860bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv1574455860 .yiv1574455860bold a {text-decoration:none;}#yiv1574455860 dd.yiv1574455860last p a {font-family:Verdana;font-weight:700;}#yiv1574455860 dd.yiv1574455860last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1574455860 dd.yiv1574455860last p span.yiv1574455860yshortcuts {margin-right:0;}#yiv1574455860 div.yiv1574455860attach-table div div a {text-decoration:none;}#yiv1574455860 div.yiv1574455860attach-table {width:400px;}#yiv1574455860 div.yiv1574455860file-title a, #yiv1574455860 div.yiv1574455860file-title a:active, #yiv1574455860 div.yiv1574455860file-title a:hover, #yiv1574455860 div.yiv1574455860file-title a:visited {text-decoration:none;}#yiv1574455860 div.yiv1574455860photo-title a, #yiv1574455860 div.yiv1574455860photo-title a:active, #yiv1574455860 div.yiv1574455860photo-title a:hover, #yiv1574455860 div.yiv1574455860photo-title a:visited {text-decoration:none;}#yiv1574455860 div#yiv1574455860ygrp-mlmsg #yiv1574455860ygrp-msg p a span.yiv1574455860yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1574455860 .yiv1574455860green {color:#628c2a;}#yiv1574455860 .yiv1574455860MsoNormal {margin:0 0 0 0;}#yiv1574455860 o {font-size:0;}#yiv1574455860 #yiv1574455860photos div {float:left;width:72px;}#yiv1574455860 #yiv1574455860photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv1574455860 #yiv1574455860photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1574455860 #yiv1574455860reco-category {font-size:77%;}#yiv1574455860 #yiv1574455860reco-desc {font-size:77%;}#yiv1574455860 .yiv1574455860replbq {margin:4px;}#yiv1574455860 #yiv1574455860ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv1574455860 #yiv1574455860ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1574455860 #yiv1574455860ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1574455860 #yiv1574455860ygrp-mlmsg select, #yiv1574455860 input, #yiv1574455860 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv1574455860 #yiv1574455860ygrp-mlmsg pre, #yiv1574455860 code {font:115% monospace;}#yiv1574455860 #yiv1574455860ygrp-mlmsg * {line-height:1.22em;}#yiv1574455860 #yiv1574455860ygrp-mlmsg #yiv1574455860logo {padding-bottom:10px;}#yiv1574455860 #yiv1574455860ygrp-msg p a {font-family:Verdana;}#yiv1574455860 #yiv1574455860ygrp-msg p#yiv1574455860attach-count span {color:#1E66AE;font-weight:700;}#yiv1574455860 #yiv1574455860ygrp-reco #yiv1574455860reco-head {color:#ff7900;font-weight:700;}#yiv1574455860 #yiv1574455860ygrp-reco {margin-bottom:20px;padding:0px;}#yiv1574455860 #yiv1574455860ygrp-sponsor #yiv1574455860ov li a {font-size:130%;text-decoration:none;}#yiv1574455860 #yiv1574455860ygrp-sponsor #yiv1574455860ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv1574455860 #yiv1574455860ygrp-sponsor #yiv1574455860ov ul {margin:0;padding:0 0 0 8px;}#yiv1574455860 #yiv1574455860ygrp-text {font-family:Georgia;}#yiv1574455860 #yiv1574455860ygrp-text p {margin:0 0 1em 0;}#yiv1574455860 #yiv1574455860ygrp-text tt {font-size:120%;}#yiv1574455860 #yiv1574455860ygrp-vital ul li:last-child {border-right:none !important;}#yiv1574455860

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

2a

Re: ambil angka berbeda kondisi

Mon Apr 2, 2018 9:35 pm (PDT) . Posted by:

"M.Ade Alfarid" aderyo

sama

*From:* belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]

*Sent:* Monday, April 2, 2018 2:19 PM
*To:* belajar-excel@yahoogroups.com
*Subject:* Re: [belajar-excel] ambil angka berbeda kondisi

Sekalian belajar bang Gozi, apa tanda "--" pada --(Mid; dst.... apakah
maksudnya sama dengan (Mid; dst....)*1 ?

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

2b

Format desimal

Tue Apr 3, 2018 1:18 am (PDT) . Posted by:

"Heru Safrudin" heru.safrudin

Dear B-Exceller,

Diketahui data dari excel sbb:

91.02

91.35

91,56

90,57

Misal nama variablenya DT

Bagaimana caranya supaya data tipe numerik diatas dengan menggunakan macro, dengan koneksi ADO, dengan perintah sbb:

CON.Execute "insert into data`.Stock (DT) SELECT '" & DT "'"

Sehingga data diterima di Access menjadi data numerik dengan format desimal (2 angka dibelakang koma) sbb:

91,02

91,35

91,56

90,57

Mohon pencerahannya

Wassalam

Heru

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

• Privacy • Unsubscribe • Terms of Use