Jumat, 16 Desember 2016

[belajar-excel] Digest Number 4043

6 Messages

Digest #4043

Messages

Thu Dec 15, 2016 7:26 am (PST) . Posted by:

"Prodev SIMPLE PB" prodev_simple

Terima kasih atas bantuannya...it's done!Tadi sempat juga mencoba dengan kolom bantu tersendiri untuk Golongan dan Masa KerjaSempat lupa memanfaatkan fungsi RANGE dan NAME RANGE... :)
 - prodev simple -


Pada Jumat, 9 Desember 2016 8:33, "Eira I Arie cheivory_bridge@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Hai Prodev :
silakan dicoba langkah berikut (semoga sesuai keinginan) :
1 buatlah name range di sheet database sell A6:A39 (menunjukkan "masa kerja") dengan nama (misalnya) "masakerja". Blok A6:A39 lalu namai di kotak name range kiri atas dengan nama (misalnya) "masa kerja"
2 buatlah name range di sheet database sell B4:R4 (menunjukkan "golongan") dengan nama (misalnya) "golongan". Blok B4:R4 lalu namai di kotak name range kiri atas dengan nama (misalnya) "golongan"
3 masuk di sheet 2 di kolom C (kolom golongan). di sell C5 buatlah data validationnya dengan cara : blok di sell C5:C530 , klik Data -> DaTA vALIDATION -> di tab setting pada kotak allow silakan pilih LIST. -> di kotak source isikan sesuai dengan keinginan dengan cara tekan F3 pada keyboard, silakan pilih yang mana yang mau dijadikan sumber data validation .. Dalam kasus di kolom C ini, maka kita pilih "golongan" -> lalu tekan OKE
4 untuk kolom masa kerja, pada prinsipnya sama dengan proses nomer 3, cuma waktu memilih source datavalidation, maka yang dipilih adalah "masakerja"

sekian
semoga sesuai dan bermanfaat

On Thursday, December 8, 2016 3:01 PM, "Prodev SIMPLE PB prodev_simple@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> wrote:


  Assalamu'alaikum Wr. Wb.
Maaf ikut nimbrung di case ini... :)Mohon petunjuk, bagaimana cara memanfaatkan fitur DATA VALIDATION sehingga pada pemilihan GOL dan MASA KERJA bisa tinggal Klik Pilih (tidak ditulis manual).
Terima kasih atas penjelasannya.
Wassalam.
 - prodev simple -


Pada Senin, 28 November 2016 8:09, "Cobain Donk cobaindonk31@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  thanks for your help mrs  eira

Pada Jumat, 25 November 2016 19:51, "Eira I Arie cheivory_bridge@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Hai Cobain 
Semoga file terlampir sesuai harapan  ..

eira_arie

On Friday, November 25, 2016 8:05 PM, "Cobain Donk cobaindonk31@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> wrote:


   Yth. Bapak-Ibu member belajar excel group
mohon bantuan solusi untuk masalah kami, sesuai attach email berikut
demikian dan terima kasih

salam hormat

   cobain

#yiv5052853262 #yiv5052853262 -- #yiv5052853262ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5052853262 #yiv5052853262ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5052853262 #yiv5052853262ygrp-mkp #yiv5052853262hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5052853262 #yiv5052853262ygrp-mkp #yiv5052853262ads {margin-bottom:10px;}#yiv5052853262 #yiv5052853262ygrp-mkp .yiv5052853262ad {padding:0 0;}#yiv5052853262 #yiv5052853262ygrp-mkp .yiv5052853262ad p {margin:0;}#yiv5052853262 #yiv5052853262ygrp-mkp .yiv5052853262ad a {color:#0000ff;text-decoration:none;}#yiv5052853262 #yiv5052853262ygrp-sponsor #yiv5052853262ygrp-lc {font-family:Arial;}#yiv5052853262 #yiv5052853262ygrp-sponsor #yiv5052853262ygrp-lc #yiv5052853262hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5052853262 #yiv5052853262ygrp-sponsor #yiv5052853262ygrp-lc .yiv5052853262ad {margin-bottom:10px;padding:0 0;}#yiv5052853262 #yiv5052853262actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5052853262 #yiv5052853262activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5052853262 #yiv5052853262activity span {font-weight:700;}#yiv5052853262 #yiv5052853262activity span:first-child {text-transform:uppercase;}#yiv5052853262 #yiv5052853262activity span a {color:#5085b6;text-decoration:none;}#yiv5052853262 #yiv5052853262activity span span {color:#ff7900;}#yiv5052853262 #yiv5052853262activity span .yiv5052853262underline {text-decoration:underline;}#yiv5052853262 .yiv5052853262attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv5052853262 .yiv5052853262attach div a {text-decoration:none;}#yiv5052853262 .yiv5052853262attach img {border:none;padding-right:5px;}#yiv5052853262 .yiv5052853262attach label {display:block;margin-bottom:5px;}#yiv5052853262 .yiv5052853262attach label a {text-decoration:none;}#yiv5052853262 blockquote {margin:0 0 0 4px;}#yiv5052853262 .yiv5052853262bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv5052853262 .yiv5052853262bold a {text-decoration:none;}#yiv5052853262 dd.yiv5052853262last p a {font-family:Verdana;font-weight:700;}#yiv5052853262 dd.yiv5052853262last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5052853262 dd.yiv5052853262last p span.yiv5052853262yshortcuts {margin-right:0;}#yiv5052853262 div.yiv5052853262attach-table div div a {text-decoration:none;}#yiv5052853262 div.yiv5052853262attach-table {width:400px;}#yiv5052853262 div.yiv5052853262file-title a, #yiv5052853262 div.yiv5052853262file-title a:active, #yiv5052853262 div.yiv5052853262file-title a:hover, #yiv5052853262 div.yiv5052853262file-title a:visited {text-decoration:none;}#yiv5052853262 div.yiv5052853262photo-title a, #yiv5052853262 div.yiv5052853262photo-title a:active, #yiv5052853262 div.yiv5052853262photo-title a:hover, #yiv5052853262 div.yiv5052853262photo-title a:visited {text-decoration:none;}#yiv5052853262 div#yiv5052853262ygrp-mlmsg #yiv5052853262ygrp-msg p a span.yiv5052853262yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5052853262 .yiv5052853262green {color:#628c2a;}#yiv5052853262 .yiv5052853262MsoNormal {margin:0 0 0 0;}#yiv5052853262 o {font-size:0;}#yiv5052853262 #yiv5052853262photos div {float:left;width:72px;}#yiv5052853262 #yiv5052853262photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv5052853262 #yiv5052853262photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5052853262 #yiv5052853262reco-category {font-size:77%;}#yiv5052853262 #yiv5052853262reco-desc {font-size:77%;}#yiv5052853262 .yiv5052853262replbq {margin:4px;}#yiv5052853262 #yiv5052853262ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv5052853262 #yiv5052853262ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5052853262 #yiv5052853262ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5052853262 #yiv5052853262ygrp-mlmsg select, #yiv5052853262 input, #yiv5052853262 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv5052853262 #yiv5052853262ygrp-mlmsg pre, #yiv5052853262 code {font:115% monospace;}#yiv5052853262 #yiv5052853262ygrp-mlmsg * {line-height:1.22em;}#yiv5052853262 #yiv5052853262ygrp-mlmsg #yiv5052853262logo {padding-bottom:10px;}#yiv5052853262 #yiv5052853262ygrp-msg p a {font-family:Verdana;}#yiv5052853262 #yiv5052853262ygrp-msg p#yiv5052853262attach-count span {color:#1E66AE;font-weight:700;}#yiv5052853262 #yiv5052853262ygrp-reco #yiv5052853262reco-head {color:#ff7900;font-weight:700;}#yiv5052853262 #yiv5052853262ygrp-reco {margin-bottom:20px;padding:0px;}#yiv5052853262 #yiv5052853262ygrp-sponsor #yiv5052853262ov li a {font-size:130%;text-decoration:none;}#yiv5052853262 #yiv5052853262ygrp-sponsor #yiv5052853262ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv5052853262 #yiv5052853262ygrp-sponsor #yiv5052853262ov ul {margin:0;padding:0 0 0 8px;}#yiv5052853262 #yiv5052853262ygrp-text {font-family:Georgia;}#yiv5052853262 #yiv5052853262ygrp-text p {margin:0 0 1em 0;}#yiv5052853262 #yiv5052853262ygrp-text tt {font-size:120%;}#yiv5052853262 #yiv5052853262ygrp-vital ul li:last-child {border-right:none !important;}#yiv5052853262

Thu Dec 15, 2016 4:53 pm (PST) . Posted by:

"dedril cecen" dedril_cc

dear bapak/ibu guru belajar-excel
saya mempunyai pembukuan surat menyurat data suratnya seperti pada file dibawah inisaya ingin memisahkan kelompok arsip sesuai dengan pengelolanyaapabila pengelolanya kasubbag umum maka tersimpat di sheet arsip umumapabila pengelolanya Kasi Pemerintahan maka tersimpat di sheet arsip pemerintahan
apabila pengelolanya Bendahara maka tersimpat di sheet arsip bendahara apabila pengelolanya kasi pmd maka tersimpat di sheet arsi pmdddan seterusnya
 setiap mengisi buku induk otomatis sheet sesuai pengelola langsung mengsi tersendirimohon bantuannya dalam penulisan script nya. trims

Thu Dec 15, 2016 7:47 pm (PST) . Posted by:

"Nang Agus"

2016-12-15 22:39 GMT+07:00 dedril cecen dedril_cc@yahoo.com [belajar-excel]
<belajar-excel@yahoogroups.com>:

>
>
> dear
> bapak/ibu guru belajar-excel
>
> saya mempunyai pembukuan surat menyurat data suratnya seperti pada file
> dibawah ini
> saya ingin memisahkan kelompok arsip sesuai dengan pengelolanya
> apabila pengelolanya kasubbag umum maka tersimpat di sheet arsip umum
> apabila pengelolanya Kasi Pemerintahan maka tersimpat di sheet arsip
> pemerintahan
> apabila pengelolanya Bendahara maka tersimpat di sheet arsip bendahara
> apabila pengelolanya kasi pmd maka tersimpat di sheet arsi pmd
> ddan seterusnya
>
> setiap mengisi buku induk otomatis sheet sesuai pengelola langsung mengsi
> tersendiri
> mohon bantuannya dalam penulisan script nya. trims
>
>
>

Thu Dec 15, 2016 7:22 pm (PST) . Posted by:

"Lazuardi Biru" lazuardi_biru84

baik pak,, tapi setelah saya pindah formulanya ke helper tidak scan2
sepertinya ada yang belum masuk tanggalnya.
filenya saya lampirkan lagi.

Pada Kamis, 15 Desember 2016 15:13, "odong nando odongnando@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  "tidak scan 1" yang saya kerjakan dapat di jadikan contoh untuk mengerjakan "tidak scan 2" dan "tidak hadir" br,

odong nando

Dari: "Lazuardi Biru lazuardi_biru84@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
Kepada: BeExcel <belajar-excel@yahoogroups.com>
Dikirim: Kamis, 15 Desember 2016 11:49
Judul: [belajar-excel] mengambil tanggal sebagai keterangan [1 Attachment]

   dh.rekan be-excel.
bagaimana mengambil tanggal dengan kretiria untuk keterangan.
untuk jelasnya file terlampir.
salam
lb


#yiv9109408453 #yiv9109408453 -- #yiv9109408453ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9109408453 #yiv9109408453ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9109408453 #yiv9109408453ygrp-mkp #yiv9109408453hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv9109408453 #yiv9109408453ygrp-mkp #yiv9109408453ads {margin-bottom:10px;}#yiv9109408453 #yiv9109408453ygrp-mkp .yiv9109408453ad {padding:0 0;}#yiv9109408453 #yiv9109408453ygrp-mkp .yiv9109408453ad p {margin:0;}#yiv9109408453 #yiv9109408453ygrp-mkp .yiv9109408453ad a {color:#0000ff;text-decoration:none;}#yiv9109408453 #yiv9109408453ygrp-sponsor #yiv9109408453ygrp-lc {font-family:Arial;}#yiv9109408453 #yiv9109408453ygrp-sponsor #yiv9109408453ygrp-lc #yiv9109408453hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9109408453 #yiv9109408453ygrp-sponsor #yiv9109408453ygrp-lc .yiv9109408453ad {margin-bottom:10px;padding:0 0;}#yiv9109408453 #yiv9109408453actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9109408453 #yiv9109408453activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9109408453 #yiv9109408453activity span {font-weight:700;}#yiv9109408453 #yiv9109408453activity span:first-child {text-transform:uppercase;}#yiv9109408453 #yiv9109408453activity span a {color:#5085b6;text-decoration:none;}#yiv9109408453 #yiv9109408453activity span span {color:#ff7900;}#yiv9109408453 #yiv9109408453activity span .yiv9109408453underline {text-decoration:underline;}#yiv9109408453 .yiv9109408453attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv9109408453 .yiv9109408453attach div a {text-decoration:none;}#yiv9109408453 .yiv9109408453attach img {border:none;padding-right:5px;}#yiv9109408453 .yiv9109408453attach label {display:block;margin-bottom:5px;}#yiv9109408453 .yiv9109408453attach label a {text-decoration:none;}#yiv9109408453 blockquote {margin:0 0 0 4px;}#yiv9109408453 .yiv9109408453bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv9109408453 .yiv9109408453bold a {text-decoration:none;}#yiv9109408453 dd.yiv9109408453last p a {font-family:Verdana;font-weight:700;}#yiv9109408453 dd.yiv9109408453last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9109408453 dd.yiv9109408453last p span.yiv9109408453yshortcuts {margin-right:0;}#yiv9109408453 div.yiv9109408453attach-table div div a {text-decoration:none;}#yiv9109408453 div.yiv9109408453attach-table {width:400px;}#yiv9109408453 div.yiv9109408453file-title a, #yiv9109408453 div.yiv9109408453file-title a:active, #yiv9109408453 div.yiv9109408453file-title a:hover, #yiv9109408453 div.yiv9109408453file-title a:visited {text-decoration:none;}#yiv9109408453 div.yiv9109408453photo-title a, #yiv9109408453 div.yiv9109408453photo-title a:active, #yiv9109408453 div.yiv9109408453photo-title a:hover, #yiv9109408453 div.yiv9109408453photo-title a:visited {text-decoration:none;}#yiv9109408453 div#yiv9109408453ygrp-mlmsg #yiv9109408453ygrp-msg p a span.yiv9109408453yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9109408453 .yiv9109408453green {color:#628c2a;}#yiv9109408453 .yiv9109408453MsoNormal {margin:0 0 0 0;}#yiv9109408453 o {font-size:0;}#yiv9109408453 #yiv9109408453photos div {float:left;width:72px;}#yiv9109408453 #yiv9109408453photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv9109408453 #yiv9109408453photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9109408453 #yiv9109408453reco-category {font-size:77%;}#yiv9109408453 #yiv9109408453reco-desc {font-size:77%;}#yiv9109408453 .yiv9109408453replbq {margin:4px;}#yiv9109408453 #yiv9109408453ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv9109408453 #yiv9109408453ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9109408453 #yiv9109408453ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9109408453 #yiv9109408453ygrp-mlmsg select, #yiv9109408453 input, #yiv9109408453 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv9109408453 #yiv9109408453ygrp-mlmsg pre, #yiv9109408453 code {font:115% monospace;}#yiv9109408453 #yiv9109408453ygrp-mlmsg * {line-height:1.22em;}#yiv9109408453 #yiv9109408453ygrp-mlmsg #yiv9109408453logo {padding-bottom:10px;}#yiv9109408453 #yiv9109408453ygrp-msg p a {font-family:Verdana;}#yiv9109408453 #yiv9109408453ygrp-msg p#yiv9109408453attach-count span {color:#1E66AE;font-weight:700;}#yiv9109408453 #yiv9109408453ygrp-reco #yiv9109408453reco-head {color:#ff7900;font-weight:700;}#yiv9109408453 #yiv9109408453ygrp-reco {margin-bottom:20px;padding:0px;}#yiv9109408453 #yiv9109408453ygrp-sponsor #yiv9109408453ov li a {font-size:130%;text-decoration:none;}#yiv9109408453 #yiv9109408453ygrp-sponsor #yiv9109408453ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv9109408453 #yiv9109408453ygrp-sponsor #yiv9109408453ov ul {margin:0;padding:0 0 0 8px;}#yiv9109408453 #yiv9109408453ygrp-text {font-family:Georgia;}#yiv9109408453 #yiv9109408453ygrp-text p {margin:0 0 1em 0;}#yiv9109408453 #yiv9109408453ygrp-text tt {font-size:120%;}#yiv9109408453 #yiv9109408453ygrp-vital ul li:last-child {border-right:none !important;}#yiv9109408453

Thu Dec 15, 2016 8:15 pm (PST) . Posted by:

"Lazuardi Biru" lazuardi_biru84

 dengan banyak kolom bantu akirnya hampir sdah sesuai keinginan.mingkin ada yang berkenan koreksi.ini saya lampirkan hasilnya.

salam
lb

Pada Jumat, 16 Desember 2016 10:22, "Lazuardi Biru lazuardi_biru84@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  baik pak,, tapi setelah saya pindah formulanya ke helper tidak scan2
sepertinya ada yang belum masuk tanggalnya.
filenya saya lampirkan lagi.

Pada Kamis, 15 Desember 2016 15:13, "odong nando odongnando@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  "tidak scan 1" yang saya kerjakan dapat di jadikan contoh untuk mengerjakan "tidak scan 2" dan "tidak hadir" br,

odong nando

Dari: "Lazuardi Biru lazuardi_biru84@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
Kepada: BeExcel <belajar-excel@yahoogroups.com>
Dikirim: Kamis, 15 Desember 2016 11:49
Judul: [belajar-excel] mengambil tanggal sebagai keterangan [1 Attachment]

   dh.rekan be-excel.
bagaimana mengambil tanggal dengan kretiria untuk keterangan.
untuk jelasnya file terlampir.
salam
lb


#yiv8481478554 #yiv8481478554 -- #yiv8481478554ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8481478554 #yiv8481478554ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8481478554 #yiv8481478554ygrp-mkp #yiv8481478554hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8481478554 #yiv8481478554ygrp-mkp #yiv8481478554ads {margin-bottom:10px;}#yiv8481478554 #yiv8481478554ygrp-mkp .yiv8481478554ad {padding:0 0;}#yiv8481478554 #yiv8481478554ygrp-mkp .yiv8481478554ad p {margin:0;}#yiv8481478554 #yiv8481478554ygrp-mkp .yiv8481478554ad a {color:#0000ff;text-decoration:none;}#yiv8481478554 #yiv8481478554ygrp-sponsor #yiv8481478554ygrp-lc {font-family:Arial;}#yiv8481478554 #yiv8481478554ygrp-sponsor #yiv8481478554ygrp-lc #yiv8481478554hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8481478554 #yiv8481478554ygrp-sponsor #yiv8481478554ygrp-lc .yiv8481478554ad {margin-bottom:10px;padding:0 0;}#yiv8481478554 #yiv8481478554actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8481478554 #yiv8481478554activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8481478554 #yiv8481478554activity span {font-weight:700;}#yiv8481478554 #yiv8481478554activity span:first-child {text-transform:uppercase;}#yiv8481478554 #yiv8481478554activity span a {color:#5085b6;text-decoration:none;}#yiv8481478554 #yiv8481478554activity span span {color:#ff7900;}#yiv8481478554 #yiv8481478554activity span .yiv8481478554underline {text-decoration:underline;}#yiv8481478554 .yiv8481478554attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8481478554 .yiv8481478554attach div a {text-decoration:none;}#yiv8481478554 .yiv8481478554attach img {border:none;padding-right:5px;}#yiv8481478554 .yiv8481478554attach label {display:block;margin-bottom:5px;}#yiv8481478554 .yiv8481478554attach label a {text-decoration:none;}#yiv8481478554 blockquote {margin:0 0 0 4px;}#yiv8481478554 .yiv8481478554bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8481478554 .yiv8481478554bold a {text-decoration:none;}#yiv8481478554 dd.yiv8481478554last p a {font-family:Verdana;font-weight:700;}#yiv8481478554 dd.yiv8481478554last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8481478554 dd.yiv8481478554last p span.yiv8481478554yshortcuts {margin-right:0;}#yiv8481478554 div.yiv8481478554attach-table div div a {text-decoration:none;}#yiv8481478554 div.yiv8481478554attach-table {width:400px;}#yiv8481478554 div.yiv8481478554file-title a, #yiv8481478554 div.yiv8481478554file-title a:active, #yiv8481478554 div.yiv8481478554file-title a:hover, #yiv8481478554 div.yiv8481478554file-title a:visited {text-decoration:none;}#yiv8481478554 div.yiv8481478554photo-title a, #yiv8481478554 div.yiv8481478554photo-title a:active, #yiv8481478554 div.yiv8481478554photo-title a:hover, #yiv8481478554 div.yiv8481478554photo-title a:visited {text-decoration:none;}#yiv8481478554 div#yiv8481478554ygrp-mlmsg #yiv8481478554ygrp-msg p a span.yiv8481478554yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8481478554 .yiv8481478554green {color:#628c2a;}#yiv8481478554 .yiv8481478554MsoNormal {margin:0 0 0 0;}#yiv8481478554 o {font-size:0;}#yiv8481478554 #yiv8481478554photos div {float:left;width:72px;}#yiv8481478554 #yiv8481478554photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv8481478554 #yiv8481478554photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8481478554 #yiv8481478554reco-category {font-size:77%;}#yiv8481478554 #yiv8481478554reco-desc {font-size:77%;}#yiv8481478554 .yiv8481478554replbq {margin:4px;}#yiv8481478554 #yiv8481478554ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8481478554 #yiv8481478554ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8481478554 #yiv8481478554ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8481478554 #yiv8481478554ygrp-mlmsg select, #yiv8481478554 input, #yiv8481478554 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8481478554 #yiv8481478554ygrp-mlmsg pre, #yiv8481478554 code {font:115% monospace;}#yiv8481478554 #yiv8481478554ygrp-mlmsg * {line-height:1.22em;}#yiv8481478554 #yiv8481478554ygrp-mlmsg #yiv8481478554logo {padding-bottom:10px;}#yiv8481478554 #yiv8481478554ygrp-msg p a {font-family:Verdana;}#yiv8481478554 #yiv8481478554ygrp-msg p#yiv8481478554attach-count span {color:#1E66AE;font-weight:700;}#yiv8481478554 #yiv8481478554ygrp-reco #yiv8481478554reco-head {color:#ff7900;font-weight:700;}#yiv8481478554 #yiv8481478554ygrp-reco {margin-bottom:20px;padding:0px;}#yiv8481478554 #yiv8481478554ygrp-sponsor #yiv8481478554ov li a {font-size:130%;text-decoration:none;}#yiv8481478554 #yiv8481478554ygrp-sponsor #yiv8481478554ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv8481478554 #yiv8481478554ygrp-sponsor #yiv8481478554ov ul {margin:0;padding:0 0 0 8px;}#yiv8481478554 #yiv8481478554ygrp-text {font-family:Georgia;}#yiv8481478554 #yiv8481478554ygrp-text p {margin:0 0 1em 0;}#yiv8481478554 #yiv8481478554ygrp-text tt {font-size:120%;}#yiv8481478554 #yiv8481478554ygrp-vital ul li:last-child {border-right:none !important;}#yiv8481478554

Thu Dec 15, 2016 9:44 pm (PST) . Posted by:

"odong nando"

pada kolom "tidak scan 2" formula yang berbunyi :

($E$4:$E$128="")

yang di ambil dari "tidak scan 1", seharusnya

($H$4:$H$128="")

pada kolom "tidak scan 2".

sama juga untuk berikutnya tolong dilihat lagi kebutuhannya apa2 saja yang mau kita ambil...
silakan dicoba lagi untuk kolom "tidak hadir"

:)

br,

odong nando

--------------------------------------------
Pada Jum, 16/12/16, Lazuardi Biru lazuardi_biru84@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

Judul: Bls: [belajar-excel] mengambil tanggal sebagai keterangan [1 Attachment]
Kepada: "belajar-excel@yahoogroups.com" <belajar-excel@yahoogroups.com>
Tanggal: Jumat, 16 Desember, 2016, 10:19 AM


 









baik
pak,, tapi setelah saya pindah formulanya ke helper tidak
scan2
sepertinya
ada yang belum masuk tanggalnya.
filenya
saya lampirkan lagi.


Pada Kamis, 15
Desember 2016 15:13, "odong nando odongnando@yahoo.com
[belajar-excel]" <belajar-excel@yahoogroups.com>
menulis:



 









"tidak
scan 1" yang saya kerjakan dapat di jadikan contoh
untuk mengerjakan "tidak scan 2" dan "tidak
hadir" br,

odong
nando




Dari: "Lazuardi
Biru lazuardi_biru84@yahoo.com [belajar-excel]"
<belajar-excel@yahoogroups.com>

Kepada:
BeExcel <belajar-excel@yahoogroups.com>
Dikirim: Kamis, 15
Desember 2016 11:49
Judul: [belajar-excel]
mengambil tanggal sebagai keterangan [1 Attachment]


 









 dh.rekan
be-excel.
bagaimana
mengambil tanggal dengan kretiria untuk
keterangan.
untuk
jelasnya file terlampir.
salam
lb


































#yiv0664220106 #yiv0664220106 --
#yiv0664220106ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}

#yiv0664220106 #yiv0664220106ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv0664220106 #yiv0664220106ygrp-mkp #yiv0664220106hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv0664220106 #yiv0664220106ygrp-mkp #yiv0664220106ads {
margin-bottom:10px;}

#yiv0664220106 #yiv0664220106ygrp-mkp .yiv0664220106ad {
padding:0 0;}

#yiv0664220106 #yiv0664220106ygrp-mkp .yiv0664220106ad p {
margin:0;}

#yiv0664220106 #yiv0664220106ygrp-mkp .yiv0664220106ad a {
color:#0000ff;text-decoration:none;}
#yiv0664220106 #yiv0664220106ygrp-sponsor
#yiv0664220106ygrp-lc {
font-family:Arial;}

#yiv0664220106 #yiv0664220106ygrp-sponsor
#yiv0664220106ygrp-lc #yiv0664220106hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv0664220106 #yiv0664220106ygrp-sponsor
#yiv0664220106ygrp-lc .yiv0664220106ad {
margin-bottom:10px;padding:0 0;}

#yiv0664220106 #yiv0664220106actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#yiv0664220106 #yiv0664220106activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#yiv0664220106 #yiv0664220106activity span {
font-weight:700;}

#yiv0664220106 #yiv0664220106activity span:first-child {
text-transform:uppercase;}

#yiv0664220106 #yiv0664220106activity span a {
color:#5085b6;text-decoration:none;}

#yiv0664220106 #yiv0664220106activity span span {
color:#ff7900;}

#yiv0664220106 #yiv0664220106activity span
.yiv0664220106underline {
text-decoration:underline;}

#yiv0664220106 .yiv0664220106attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}

#yiv0664220106 .yiv0664220106attach div a {
text-decoration:none;}

#yiv0664220106 .yiv0664220106attach img {
border:none;padding-right:5px;}

#yiv0664220106 .yiv0664220106attach label {
display:block;margin-bottom:5px;}

#yiv0664220106 .yiv0664220106attach label a {
text-decoration:none;}

#yiv0664220106 blockquote {
margin:0 0 0 4px;}

#yiv0664220106 .yiv0664220106bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv0664220106 .yiv0664220106bold a {
text-decoration:none;}

#yiv0664220106 dd.yiv0664220106last p a {
font-family:Verdana;font-weight:700;}

#yiv0664220106 dd.yiv0664220106last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#yiv0664220106 dd.yiv0664220106last p
span.yiv0664220106yshortcuts {
margin-right:0;}

#yiv0664220106 div.yiv0664220106attach-table div div a {
text-decoration:none;}

#yiv0664220106 div.yiv0664220106attach-table {
width:400px;}

#yiv0664220106 div.yiv0664220106file-title a, #yiv0664220106
div.yiv0664220106file-title a:active, #yiv0664220106
div.yiv0664220106file-title a:hover, #yiv0664220106
div.yiv0664220106file-title a:visited {
text-decoration:none;}

#yiv0664220106 div.yiv0664220106photo-title a,
#yiv0664220106 div.yiv0664220106photo-title a:active,
#yiv0664220106 div.yiv0664220106photo-title a:hover,
#yiv0664220106 div.yiv0664220106photo-title a:visited {
text-decoration:none;}

#yiv0664220106 div#yiv0664220106ygrp-mlmsg
#yiv0664220106ygrp-msg p a span.yiv0664220106yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv0664220106 .yiv0664220106green {
color:#628c2a;}

#yiv0664220106 .yiv0664220106MsoNormal {
margin:0 0 0 0;}

#yiv0664220106 o {
font-size:0;}

#yiv0664220106 #yiv0664220106photos div {
float:left;width:72px;}

#yiv0664220106 #yiv0664220106photos div div {
border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}

#yiv0664220106 #yiv0664220106photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#yiv0664220106 #yiv0664220106reco-category {
font-size:77%;}

#yiv0664220106 #yiv0664220106reco-desc {
font-size:77%;}

#yiv0664220106 .yiv0664220106replbq {
margin:4px;}

#yiv0664220106 #yiv0664220106ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#yiv0664220106 #yiv0664220106ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}

#yiv0664220106 #yiv0664220106ygrp-mlmsg table {
font-size:inherit;font:100%;}

#yiv0664220106 #yiv0664220106ygrp-mlmsg select,
#yiv0664220106 input, #yiv0664220106 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#yiv0664220106 #yiv0664220106ygrp-mlmsg pre, #yiv0664220106
code {
font:115% monospace;}

#yiv0664220106 #yiv0664220106ygrp-mlmsg * {
line-height:1.22em;}

#yiv0664220106 #yiv0664220106ygrp-mlmsg #yiv0664220106logo {
padding-bottom:10px;}


#yiv0664220106 #yiv0664220106ygrp-msg p a {
font-family:Verdana;}

#yiv0664220106 #yiv0664220106ygrp-msg
p#yiv0664220106attach-count span {
color:#1E66AE;font-weight:700;}

#yiv0664220106 #yiv0664220106ygrp-reco
#yiv0664220106reco-head {
color:#ff7900;font-weight:700;}

#yiv0664220106 #yiv0664220106ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv0664220106 #yiv0664220106ygrp-sponsor #yiv0664220106ov
li a {
font-size:130%;text-decoration:none;}

#yiv0664220106 #yiv0664220106ygrp-sponsor #yiv0664220106ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv0664220106 #yiv0664220106ygrp-sponsor #yiv0664220106ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv0664220106 #yiv0664220106ygrp-text {
font-family:Georgia;}

#yiv0664220106 #yiv0664220106ygrp-text p {
margin:0 0 1em 0;}

#yiv0664220106 #yiv0664220106ygrp-text tt {
font-size:120%;}

#yiv0664220106 #yiv0664220106ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv0664220106


============================================================
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
---------------------------------------------------------------------
Diposting oleh EXCEL FEED LEARNING di 01.54

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)