Jumat, 16 Oktober 2015

[belajar-excel] Digest Number 3601

9 Messages

Digest #3601

Messages

Thu Oct 15, 2015 6:04 am (PDT) . Posted by:

"Fajar Fatahillah" fajar.fatahillah

Dear Master excel, saya mau tanya cara menghitung durasi dari tanggal dan jam untuk pemakaian suatu perangkat. misal akun AA dengan penggunaan perangkat 5 kali dengan waktu yang berbeda beda dan akun AB dengan penggunaan perangkat 3 kali dengan waktu yang berbeda pula.
contoh file terlampir
mohon masukannya ya..


terima kasih

Best Regards, Fajar Fatahillah








Thu Oct 15, 2015 5:12 pm (PDT) . Posted by:

"Heri Pamungkas ( Gmail )" dchoosen88


السَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ
Semangat pagi,.

Sambil menunggu para pakar,
File terlampir mungkin bisa membantu...

وَالسَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ

Warm Regards,

On 15/10/2015 19:56, Fajar Fatahillah fajar.fatahillah@yahoo.com
[belajar-excel] wrote:
> Dear Master excel, saya mau tanya cara menghitung durasi dari tanggal
> dan jam untuk pemakaian suatu perangkat. misal akun AA dengan
> penggunaan perangkat 5 kali dengan waktu yang berbeda beda dan akun AB
> dengan penggunaan perangkat 3 kali dengan waktu yang berbeda pula.
> contoh file terlampir
> mohon masukannya ya..
>
> terima kasih
> Best Regards, Fajar Fatahillah
>
>

Thu Oct 15, 2015 5:19 pm (PDT) . Posted by:

"Nang Agus"

mungkin begini:
{=MAX(($A$2:$A$15=H2)*($C$2:$C$15))-MIN(IF($A$2:$A$15=H2;$C$2:$C$15;9^99))}
ini merupakan array formula

2015-10-15 19:56 GMT+07:00 Fajar Fatahillah fajar.fatahillah@yahoo.com
[belajar-excel] <belajar-excel@yahoogroups.com>:

>
>
> Dear Master excel, saya mau tanya cara menghitung durasi dari tanggal dan
> jam untuk pemakaian suatu perangkat. misal akun AA dengan penggunaan
> perangkat 5 kali dengan waktu yang berbeda beda dan akun AB dengan
> penggunaan perangkat 3 kali dengan waktu yang berbeda pula.
> contoh file terlampir
> mohon masukannya ya..
>
> terima kasih
>
> Best Regards, Fajar Fatahillah
>
>
>

Thu Oct 15, 2015 8:23 pm (PDT) . Posted by:

"odong nando"

dear fajar,bisa pake rumus
=TEXT(MAX(INDEX(($A$2:$A$15=H2)*$C$2:$C$15;0))-VLOOKUP(H2;$A$2:$C$15;3;0);"[m]")&" menit"
ganti titik koma ";" dengan koma "," bila komputer anda ber regional english
 thx,

odong nando


Pada Jumat, 16 Oktober 2015 7:19, "Nang Agus nangagus@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  mungkin begini:
{=MAX(($A$2:$A$15=H2)*($C$2:$C$15))-MIN(IF($A$2:$A$15=H2;$C$2:$C$15;9^99))}
ini merupakan array formula

2015-10-15 19:56 GMT+07:00 Fajar Fatahillah fajar.fatahillah@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com>:

  Dear Master excel, saya mau tanya cara menghitung durasi dari tanggal dan jam untuk pemakaian suatu perangkat. misal akun AA dengan penggunaan perangkat 5 kali dengan waktu yang berbeda beda dan akun AB dengan penggunaan perangkat 3 kali dengan waktu yang berbeda pula.contoh file terlampirmohon masukannya ya..
terima kasih Best Regards, Fajar Fatahillah


#yiv9630356179 #yiv9630356179 -- #yiv9630356179ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9630356179 #yiv9630356179ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9630356179 #yiv9630356179ygrp-mkp #yiv9630356179hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv9630356179 #yiv9630356179ygrp-mkp #yiv9630356179ads {margin-bottom:10px;}#yiv9630356179 #yiv9630356179ygrp-mkp .yiv9630356179ad {padding:0 0;}#yiv9630356179 #yiv9630356179ygrp-mkp .yiv9630356179ad p {margin:0;}#yiv9630356179 #yiv9630356179ygrp-mkp .yiv9630356179ad a {color:#0000ff;text-decoration:none;}#yiv9630356179 #yiv9630356179ygrp-sponsor #yiv9630356179ygrp-lc {font-family:Arial;}#yiv9630356179 #yiv9630356179ygrp-sponsor #yiv9630356179ygrp-lc #yiv9630356179hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9630356179 #yiv9630356179ygrp-sponsor #yiv9630356179ygrp-lc .yiv9630356179ad {margin-bottom:10px;padding:0 0;}#yiv9630356179 #yiv9630356179actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9630356179 #yiv9630356179activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9630356179 #yiv9630356179activity span {font-weight:700;}#yiv9630356179 #yiv9630356179activity span:first-child {text-transform:uppercase;}#yiv9630356179 #yiv9630356179activity span a {color:#5085b6;text-decoration:none;}#yiv9630356179 #yiv9630356179activity span span {color:#ff7900;}#yiv9630356179 #yiv9630356179activity span .yiv9630356179underline {text-decoration:underline;}#yiv9630356179 .yiv9630356179attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv9630356179 .yiv9630356179attach div a {text-decoration:none;}#yiv9630356179 .yiv9630356179attach img {border:none;padding-right:5px;}#yiv9630356179 .yiv9630356179attach label {display:block;margin-bottom:5px;}#yiv9630356179 .yiv9630356179attach label a {text-decoration:none;}#yiv9630356179 blockquote {margin:0 0 0 4px;}#yiv9630356179 .yiv9630356179bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv9630356179 .yiv9630356179bold a {text-decoration:none;}#yiv9630356179 dd.yiv9630356179last p a {font-family:Verdana;font-weight:700;}#yiv9630356179 dd.yiv9630356179last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9630356179 dd.yiv9630356179last p span.yiv9630356179yshortcuts {margin-right:0;}#yiv9630356179 div.yiv9630356179attach-table div div a {text-decoration:none;}#yiv9630356179 div.yiv9630356179attach-table {width:400px;}#yiv9630356179 div.yiv9630356179file-title a, #yiv9630356179 div.yiv9630356179file-title a:active, #yiv9630356179 div.yiv9630356179file-title a:hover, #yiv9630356179 div.yiv9630356179file-title a:visited {text-decoration:none;}#yiv9630356179 div.yiv9630356179photo-title a, #yiv9630356179 div.yiv9630356179photo-title a:active, #yiv9630356179 div.yiv9630356179photo-title a:hover, #yiv9630356179 div.yiv9630356179photo-title a:visited {text-decoration:none;}#yiv9630356179 div#yiv9630356179ygrp-mlmsg #yiv9630356179ygrp-msg p a span.yiv9630356179yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9630356179 .yiv9630356179green {color:#628c2a;}#yiv9630356179 .yiv9630356179MsoNormal {margin:0 0 0 0;}#yiv9630356179 o {font-size:0;}#yiv9630356179 #yiv9630356179photos div {float:left;width:72px;}#yiv9630356179 #yiv9630356179photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv9630356179 #yiv9630356179photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9630356179 #yiv9630356179reco-category {font-size:77%;}#yiv9630356179 #yiv9630356179reco-desc {font-size:77%;}#yiv9630356179 .yiv9630356179replbq {margin:4px;}#yiv9630356179 #yiv9630356179ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv9630356179 #yiv9630356179ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9630356179 #yiv9630356179ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9630356179 #yiv9630356179ygrp-mlmsg select, #yiv9630356179 input, #yiv9630356179 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv9630356179 #yiv9630356179ygrp-mlmsg pre, #yiv9630356179 code {font:115% monospace;}#yiv9630356179 #yiv9630356179ygrp-mlmsg * {line-height:1.22em;}#yiv9630356179 #yiv9630356179ygrp-mlmsg #yiv9630356179logo {padding-bottom:10px;}#yiv9630356179 #yiv9630356179ygrp-msg p a {font-family:Verdana;}#yiv9630356179 #yiv9630356179ygrp-msg p#yiv9630356179attach-count span {color:#1E66AE;font-weight:700;}#yiv9630356179 #yiv9630356179ygrp-reco #yiv9630356179reco-head {color:#ff7900;font-weight:700;}#yiv9630356179 #yiv9630356179ygrp-reco {margin-bottom:20px;padding:0px;}#yiv9630356179 #yiv9630356179ygrp-sponsor #yiv9630356179ov li a {font-size:130%;text-decoration:none;}#yiv9630356179 #yiv9630356179ygrp-sponsor #yiv9630356179ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv9630356179 #yiv9630356179ygrp-sponsor #yiv9630356179ov ul {margin:0;padding:0 0 0 8px;}#yiv9630356179 #yiv9630356179ygrp-text {font-family:Georgia;}#yiv9630356179 #yiv9630356179ygrp-text p {margin:0 0 1em 0;}#yiv9630356179 #yiv9630356179ygrp-text tt {font-size:120%;}#yiv9630356179 #yiv9630356179ygrp-vital ul li:last-child {border-right:none !important;}#yiv9630356179

Thu Oct 15, 2015 7:42 pm (PDT) . Posted by:

"odong nando"

dear Rakhmad,
ini cuma salah satu solusi yang mungkin tidak sesimple para master yang ada di milis ini, terlampir yang hampir mirip dengan keinginan mu tp masih 3x kerja, tp klo banyak datanya lumayan bisa menghemat waktu, hehe....
 thx,

odong nando


Pada Kamis, 17 September 2015 10:06, "'Rakhmad' rkusyanto@luxasia.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Dear pakar Exceller,  Mohon pencerahan saya mengalami kesulitan dalam lookup data.Menggabungan batch yang ada pada packing list dengan Invoice.Format yang saya inginkan adalah sebagai berikut:Invoice :
| Code | Qty | Batch |
| MB001A01 | 24 | 08E49E269 |
| MB005A01 | 240 | 08F11F035, 08F11F035, 08F13F035 |
| MB008A01 | 154 | 08F11F040 |
| MB008A07 | 2 | 08E12E057 |
| MB008C31 | 60 | 5163A |
| MB010C08 | 60 | 5156B |
| MB001P80 | 6 | 08E43E269 |
| MB003P80 | 36 | 08F15E356 |
| MB004P80 | 8 | 08E44E241, 08F07E303 |
| MB005P80 | 8 | 08F10F008 |

Diambil dari data dibawah ini :Packing list ,Source data :
| Pallet | Carton | Code | Qty | Batch |
| 01 | 01 | MB004P80 | 6 | 08E44E241 |
| 01 | 01 | MB005P80 | 8 | 08F10F008 |
| 01 | 01 | MB004P80 | 2 | 08F07E303 |
| 01 | 01 | MB001P80 | 6 | 08E43E269 |
| 01 | 02 | MB003P80 | 18 | 08F15E356 |
| 01 | 03 | MB003P80 | 18 | 08F15E356 |
| 02 | 01 TO 11 | MB008A01 | 154 | 08F11F040 |
| 02 | 12 TO 17 | MB005A01 | 162 | 08F11F035 |
| 02 | 18 | MB005A01 | 24 | 08F11F035 |
| 02 | 19 | MB005A01 | 27 | 08F10F035 |
| 02 | 20 | MB005A01 | 27 | 08F13F035 |
| 02 | 21 | MB001A01 | 24 | 08E49E269 |
| 02 | 22 | MB008A07 | 2 | 08E12E057 |
| 02 | 23 TO 24 | MB010C08 | 60 | 5156B |
| 02 | 25 TO 29 | MB008C31 | 60 | 5163A |

 Mohon bantuan cara pemecahannya dengan fungsi Excel, bukan dengan Pivot.  Terima kasih,  Rakhmad     #yiv1377362896 #yiv1377362896 -- #yiv1377362896ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1377362896 #yiv1377362896ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1377362896 #yiv1377362896ygrp-mkp #yiv1377362896hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv1377362896 #yiv1377362896ygrp-mkp #yiv1377362896ads {margin-bottom:10px;}#yiv1377362896 #yiv1377362896ygrp-mkp .yiv1377362896ad {padding:0 0;}#yiv1377362896 #yiv1377362896ygrp-mkp .yiv1377362896ad p {margin:0;}#yiv1377362896 #yiv1377362896ygrp-mkp .yiv1377362896ad a {color:#0000ff;text-decoration:none;}#yiv1377362896 #yiv1377362896ygrp-sponsor #yiv1377362896ygrp-lc {font-family:Arial;}#yiv1377362896 #yiv1377362896ygrp-sponsor #yiv1377362896ygrp-lc #yiv1377362896hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1377362896 #yiv1377362896ygrp-sponsor #yiv1377362896ygrp-lc .yiv1377362896ad {margin-bottom:10px;padding:0 0;}#yiv1377362896 #yiv1377362896actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1377362896 #yiv1377362896activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1377362896 #yiv1377362896activity span {font-weight:700;}#yiv1377362896 #yiv1377362896activity span:first-child {text-transform:uppercase;}#yiv1377362896 #yiv1377362896activity span a {color:#5085b6;text-decoration:none;}#yiv1377362896 #yiv1377362896activity span span {color:#ff7900;}#yiv1377362896 #yiv1377362896activity span .yiv1377362896underline {text-decoration:underline;}#yiv1377362896 .yiv1377362896attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv1377362896 .yiv1377362896attach div a {text-decoration:none;}#yiv1377362896 .yiv1377362896attach img {border:none;padding-right:5px;}#yiv1377362896 .yiv1377362896attach label {display:block;margin-bottom:5px;}#yiv1377362896 .yiv1377362896attach label a {text-decoration:none;}#yiv1377362896 blockquote {margin:0 0 0 4px;}#yiv1377362896 .yiv1377362896bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv1377362896 .yiv1377362896bold a {text-decoration:none;}#yiv1377362896 dd.yiv1377362896last p a {font-family:Verdana;font-weight:700;}#yiv1377362896 dd.yiv1377362896last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1377362896 dd.yiv1377362896last p span.yiv1377362896yshortcuts {margin-right:0;}#yiv1377362896 div.yiv1377362896attach-table div div a {text-decoration:none;}#yiv1377362896 div.yiv1377362896attach-table {width:400px;}#yiv1377362896 div.yiv1377362896file-title a, #yiv1377362896 div.yiv1377362896file-title a:active, #yiv1377362896 div.yiv1377362896file-title a:hover, #yiv1377362896 div.yiv1377362896file-title a:visited {text-decoration:none;}#yiv1377362896 div.yiv1377362896photo-title a, #yiv1377362896 div.yiv1377362896photo-title a:active, #yiv1377362896 div.yiv1377362896photo-title a:hover, #yiv1377362896 div.yiv1377362896photo-title a:visited {text-decoration:none;}#yiv1377362896 div#yiv1377362896ygrp-mlmsg #yiv1377362896ygrp-msg p a span.yiv1377362896yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1377362896 .yiv1377362896green {color:#628c2a;}#yiv1377362896 .yiv1377362896MsoNormal {margin:0 0 0 0;}#yiv1377362896 o {font-size:0;}#yiv1377362896 #yiv1377362896photos div {float:left;width:72px;}#yiv1377362896 #yiv1377362896photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv1377362896 #yiv1377362896photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1377362896 #yiv1377362896reco-category {font-size:77%;}#yiv1377362896 #yiv1377362896reco-desc {font-size:77%;}#yiv1377362896 .yiv1377362896replbq {margin:4px;}#yiv1377362896 #yiv1377362896ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv1377362896 #yiv1377362896ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1377362896 #yiv1377362896ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1377362896 #yiv1377362896ygrp-mlmsg select, #yiv1377362896 input, #yiv1377362896 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv1377362896 #yiv1377362896ygrp-mlmsg pre, #yiv1377362896 code {font:115% monospace;}#yiv1377362896 #yiv1377362896ygrp-mlmsg * {line-height:1.22em;}#yiv1377362896 #yiv1377362896ygrp-mlmsg #yiv1377362896logo {padding-bottom:10px;}#yiv1377362896 #yiv1377362896ygrp-msg p a {font-family:Verdana;}#yiv1377362896 #yiv1377362896ygrp-msg p#yiv1377362896attach-count span {color:#1E66AE;font-weight:700;}#yiv1377362896 #yiv1377362896ygrp-reco #yiv1377362896reco-head {color:#ff7900;font-weight:700;}#yiv1377362896 #yiv1377362896ygrp-reco {margin-bottom:20px;padding:0px;}#yiv1377362896 #yiv1377362896ygrp-sponsor #yiv1377362896ov li a {font-size:130%;text-decoration:none;}#yiv1377362896 #yiv1377362896ygrp-sponsor #yiv1377362896ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv1377362896 #yiv1377362896ygrp-sponsor #yiv1377362896ov ul {margin:0;padding:0 0 0 8px;}#yiv1377362896 #yiv1377362896ygrp-text {font-family:Georgia;}#yiv1377362896 #yiv1377362896ygrp-text p {margin:0 0 1em 0;}#yiv1377362896 #yiv1377362896ygrp-text tt {font-size:120%;}#yiv1377362896 #yiv1377362896ygrp-vital ul li:last-child {border-right:none !important;}#yiv1377362896

Thu Oct 15, 2015 8:10 pm (PDT) . Posted by:

"ris ha" har1sn.excel

Assalamu'alaikumpara master semuaMohonbantuannya, bagaimana formula atau macronya untuk memisahkan nama berdasarkan urutan letaknama seperti kasus terlampir.
Terima kasih atas Solusinya, semogamenjadi amal jariyah bagi semua. Amin
SalamHaris

Thu Oct 15, 2015 10:52 pm (PDT) . Posted by:

"hendrik karnadi" hendrikkarnadi

Hai Haris,
Pakai Menu Data, Text to Columns, Delimited, Next, Pilih ",", Next, ketik sel tujuan, Finish.
Salam,HK
From: "ris ha har1sn.excel@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
To: BeExcel <belajar-excel@yahoogroups.com>
Sent: Friday, 16 October 2015, 10:07
Subject: [belajar-excel] Memisahkan nama berdasarkan urutan letak [1 Attachment]

  Assalamu'alaikumpara master semuaMohonbantuannya, bagaimana formula atau macronya untuk memisahkan nama berdasarkan urutan letaknama seperti kasus terlampir.
Terima kasih atas Solusinya, semogamenjadi amal jariyah bagi semua. Amin
SalamHaris
#yiv6427484368 #yiv6427484368 -- #yiv6427484368ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6427484368 #yiv6427484368ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6427484368 #yiv6427484368ygrp-mkp #yiv6427484368hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv6427484368 #yiv6427484368ygrp-mkp #yiv6427484368ads {margin-bottom:10px;}#yiv6427484368 #yiv6427484368ygrp-mkp .yiv6427484368ad {padding:0 0;}#yiv6427484368 #yiv6427484368ygrp-mkp .yiv6427484368ad p {margin:0;}#yiv6427484368 #yiv6427484368ygrp-mkp .yiv6427484368ad a {color:#0000ff;text-decoration:none;}#yiv6427484368 #yiv6427484368ygrp-sponsor #yiv6427484368ygrp-lc {font-family:Arial;}#yiv6427484368 #yiv6427484368ygrp-sponsor #yiv6427484368ygrp-lc #yiv6427484368hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6427484368 #yiv6427484368ygrp-sponsor #yiv6427484368ygrp-lc .yiv6427484368ad {margin-bottom:10px;padding:0 0;}#yiv6427484368 #yiv6427484368actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6427484368 #yiv6427484368activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6427484368 #yiv6427484368activity span {font-weight:700;}#yiv6427484368 #yiv6427484368activity span:first-child {text-transform:uppercase;}#yiv6427484368 #yiv6427484368activity span a {color:#5085b6;text-decoration:none;}#yiv6427484368 #yiv6427484368activity span span {color:#ff7900;}#yiv6427484368 #yiv6427484368activity span .yiv6427484368underline {text-decoration:underline;}#yiv6427484368 .yiv6427484368attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv6427484368 .yiv6427484368attach div a {text-decoration:none;}#yiv6427484368 .yiv6427484368attach img {border:none;padding-right:5px;}#yiv6427484368 .yiv6427484368attach label {display:block;margin-bottom:5px;}#yiv6427484368 .yiv6427484368attach label a {text-decoration:none;}#yiv6427484368 blockquote {margin:0 0 0 4px;}#yiv6427484368 .yiv6427484368bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv6427484368 .yiv6427484368bold a {text-decoration:none;}#yiv6427484368 dd.yiv6427484368last p a {font-family:Verdana;font-weight:700;}#yiv6427484368 dd.yiv6427484368last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6427484368 dd.yiv6427484368last p span.yiv6427484368yshortcuts {margin-right:0;}#yiv6427484368 div.yiv6427484368attach-table div div a {text-decoration:none;}#yiv6427484368 div.yiv6427484368attach-table {width:400px;}#yiv6427484368 div.yiv6427484368file-title a, #yiv6427484368 div.yiv6427484368file-title a:active, #yiv6427484368 div.yiv6427484368file-title a:hover, #yiv6427484368 div.yiv6427484368file-title a:visited {text-decoration:none;}#yiv6427484368 div.yiv6427484368photo-title a, #yiv6427484368 div.yiv6427484368photo-title a:active, #yiv6427484368 div.yiv6427484368photo-title a:hover, #yiv6427484368 div.yiv6427484368photo-title a:visited {text-decoration:none;}#yiv6427484368 div#yiv6427484368ygrp-mlmsg #yiv6427484368ygrp-msg p a span.yiv6427484368yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6427484368 .yiv6427484368green {color:#628c2a;}#yiv6427484368 .yiv6427484368MsoNormal {margin:0 0 0 0;}#yiv6427484368 o {font-size:0;}#yiv6427484368 #yiv6427484368photos div {float:left;width:72px;}#yiv6427484368 #yiv6427484368photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv6427484368 #yiv6427484368photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6427484368 #yiv6427484368reco-category {font-size:77%;}#yiv6427484368 #yiv6427484368reco-desc {font-size:77%;}#yiv6427484368 .yiv6427484368replbq {margin:4px;}#yiv6427484368 #yiv6427484368ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv6427484368 #yiv6427484368ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6427484368 #yiv6427484368ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6427484368 #yiv6427484368ygrp-mlmsg select, #yiv6427484368 input, #yiv6427484368 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv6427484368 #yiv6427484368ygrp-mlmsg pre, #yiv6427484368 code {font:115% monospace;}#yiv6427484368 #yiv6427484368ygrp-mlmsg * {line-height:1.22em;}#yiv6427484368 #yiv6427484368ygrp-mlmsg #yiv6427484368logo {padding-bottom:10px;}#yiv6427484368 #yiv6427484368ygrp-msg p a {font-family:Verdana;}#yiv6427484368 #yiv6427484368ygrp-msg p#yiv6427484368attach-count span {color:#1E66AE;font-weight:700;}#yiv6427484368 #yiv6427484368ygrp-reco #yiv6427484368reco-head {color:#ff7900;font-weight:700;}#yiv6427484368 #yiv6427484368ygrp-reco {margin-bottom:20px;padding:0px;}#yiv6427484368 #yiv6427484368ygrp-sponsor #yiv6427484368ov li a {font-size:130%;text-decoration:none;}#yiv6427484368 #yiv6427484368ygrp-sponsor #yiv6427484368ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv6427484368 #yiv6427484368ygrp-sponsor #yiv6427484368ov ul {margin:0;padding:0 0 0 8px;}#yiv6427484368 #yiv6427484368ygrp-text {font-family:Georgia;}#yiv6427484368 #yiv6427484368ygrp-text p {margin:0 0 1em 0;}#yiv6427484368 #yiv6427484368ygrp-text tt {font-size:120%;}#yiv6427484368 #yiv6427484368ygrp-vital ul li:last-child {border-right:none !important;}#yiv6427484368

Thu Oct 15, 2015 11:09 pm (PDT) . Posted by:

"odong nando"

dear ahs_grt,
pada cell m2 bisa di tulis rumus
=IFERROR(INDEX($F$2:$F$9;MATCH($L3&M$2;INDEX($A$2:$A$9&$B$2:$B$9;0);0));"")
copykan rumus ke setiap cell yang membutuhkan, ganti titik koma ";" dengan koma "," bila regional komputer anda english.
 thx,

odong nando


Pada Kamis, 8 Oktober 2015 11:49, "ahs_grt@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Dear All,
Saya mentok dalam menggunakan fungsi Hlookup untuk menempatkan nilai dari "Status_1" ke kolom tanggal.Gimana logikanya untuk penempatan huruf K tersebut menggunakan formula?
File terlampir
Terimakasih

#yiv2033051897 #yiv2033051897 -- #yiv2033051897ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2033051897 #yiv2033051897ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2033051897 #yiv2033051897ygrp-mkp #yiv2033051897hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2033051897 #yiv2033051897ygrp-mkp #yiv2033051897ads {margin-bottom:10px;}#yiv2033051897 #yiv2033051897ygrp-mkp .yiv2033051897ad {padding:0 0;}#yiv2033051897 #yiv2033051897ygrp-mkp .yiv2033051897ad p {margin:0;}#yiv2033051897 #yiv2033051897ygrp-mkp .yiv2033051897ad a {color:#0000ff;text-decoration:none;}#yiv2033051897 #yiv2033051897ygrp-sponsor #yiv2033051897ygrp-lc {font-family:Arial;}#yiv2033051897 #yiv2033051897ygrp-sponsor #yiv2033051897ygrp-lc #yiv2033051897hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2033051897 #yiv2033051897ygrp-sponsor #yiv2033051897ygrp-lc .yiv2033051897ad {margin-bottom:10px;padding:0 0;}#yiv2033051897 #yiv2033051897actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2033051897 #yiv2033051897activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2033051897 #yiv2033051897activity span {font-weight:700;}#yiv2033051897 #yiv2033051897activity span:first-child {text-transform:uppercase;}#yiv2033051897 #yiv2033051897activity span a {color:#5085b6;text-decoration:none;}#yiv2033051897 #yiv2033051897activity span span {color:#ff7900;}#yiv2033051897 #yiv2033051897activity span .yiv2033051897underline {text-decoration:underline;}#yiv2033051897 .yiv2033051897attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2033051897 .yiv2033051897attach div a {text-decoration:none;}#yiv2033051897 .yiv2033051897attach img {border:none;padding-right:5px;}#yiv2033051897 .yiv2033051897attach label {display:block;margin-bottom:5px;}#yiv2033051897 .yiv2033051897attach label a {text-decoration:none;}#yiv2033051897 blockquote {margin:0 0 0 4px;}#yiv2033051897 .yiv2033051897bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2033051897 .yiv2033051897bold a {text-decoration:none;}#yiv2033051897 dd.yiv2033051897last p a {font-family:Verdana;font-weight:700;}#yiv2033051897 dd.yiv2033051897last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2033051897 dd.yiv2033051897last p span.yiv2033051897yshortcuts {margin-right:0;}#yiv2033051897 div.yiv2033051897attach-table div div a {text-decoration:none;}#yiv2033051897 div.yiv2033051897attach-table {width:400px;}#yiv2033051897 div.yiv2033051897file-title a, #yiv2033051897 div.yiv2033051897file-title a:active, #yiv2033051897 div.yiv2033051897file-title a:hover, #yiv2033051897 div.yiv2033051897file-title a:visited {text-decoration:none;}#yiv2033051897 div.yiv2033051897photo-title a, #yiv2033051897 div.yiv2033051897photo-title a:active, #yiv2033051897 div.yiv2033051897photo-title a:hover, #yiv2033051897 div.yiv2033051897photo-title a:visited {text-decoration:none;}#yiv2033051897 div#yiv2033051897ygrp-mlmsg #yiv2033051897ygrp-msg p a span.yiv2033051897yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2033051897 .yiv2033051897green {color:#628c2a;}#yiv2033051897 .yiv2033051897MsoNormal {margin:0 0 0 0;}#yiv2033051897 o {font-size:0;}#yiv2033051897 #yiv2033051897photos div {float:left;width:72px;}#yiv2033051897 #yiv2033051897photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv2033051897 #yiv2033051897photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2033051897 #yiv2033051897reco-category {font-size:77%;}#yiv2033051897 #yiv2033051897reco-desc {font-size:77%;}#yiv2033051897 .yiv2033051897replbq {margin:4px;}#yiv2033051897 #yiv2033051897ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2033051897 #yiv2033051897ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2033051897 #yiv2033051897ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2033051897 #yiv2033051897ygrp-mlmsg select, #yiv2033051897 input, #yiv2033051897 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2033051897 #yiv2033051897ygrp-mlmsg pre, #yiv2033051897 code {font:115% monospace;}#yiv2033051897 #yiv2033051897ygrp-mlmsg * {line-height:1.22em;}#yiv2033051897 #yiv2033051897ygrp-mlmsg #yiv2033051897logo {padding-bottom:10px;}#yiv2033051897 #yiv2033051897ygrp-msg p a {font-family:Verdana;}#yiv2033051897 #yiv2033051897ygrp-msg p#yiv2033051897attach-count span {color:#1E66AE;font-weight:700;}#yiv2033051897 #yiv2033051897ygrp-reco #yiv2033051897reco-head {color:#ff7900;font-weight:700;}#yiv2033051897 #yiv2033051897ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2033051897 #yiv2033051897ygrp-sponsor #yiv2033051897ov li a {font-size:130%;text-decoration:none;}#yiv2033051897 #yiv2033051897ygrp-sponsor #yiv2033051897ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2033051897 #yiv2033051897ygrp-sponsor #yiv2033051897ov ul {margin:0;padding:0 0 0 8px;}#yiv2033051897 #yiv2033051897ygrp-text {font-family:Georgia;}#yiv2033051897 #yiv2033051897ygrp-text p {margin:0 0 1em 0;}#yiv2033051897 #yiv2033051897ygrp-text tt {font-size:120%;}#yiv2033051897 #yiv2033051897ygrp-vital ul li:last-child {border-right:none !important;}#yiv2033051897

Fri Oct 16, 2015 2:04 am (PDT) . Posted by:

"Modby Matsnawabi"

Dear rekan-rekan bexcel,,

mohon bantuan yang sudah pernah buat macro untuk simpan data otomatis/copy
data ke sheet lain. tolong di share macro nya yah..
saya punya case terlampir..

tanya juga untuk excel dengan macro harus disave dengan file XLSM? apa
nanti akan compatible dengan ms office 2007 ke bawah..

terima kasih

Modby.M
============================================================
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
---------------------------------------------------------------------

Tidak ada komentar:

Poskan Komentar