Selasa, 31 Maret 2015

[belajar-excel] Digest Number 3365

10 Messages

Digest #3365
1a
Re: Selisih Jarak Tempuh by "Mr. Kid" nmkid.family@ymail.com
2
GoalSeek by "Dwi Hartanto"
5a
Formula Absensi by teguh.indrawanto
5b
Re: Formula Absensi [1 Attachment] by "Mr. Kid" nmkid.family@ymail.com
5d
Re: Bls: [belajar-excel] Formula Absensi by "teguh indrawanto" teguh.indrawanto
6

Messages

Mon Mar 30, 2015 5:45 pm (PDT) . Posted by:

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

Kok sampai sekarang penanya belum melampirkan ulang file lampiran yang
ukurannya maksimal 250KB ya.
Atau mungkin permasalahannya sudah terselesaikan ya

On Mon, Mar 23, 2015 at 2:22 PM, Samsudin samsudin@bayan.com.sg
[belajar-excel] <belajar-excel@yahoogroups.com> wrote:

>
>
> Dear Master Excel,
>
>
>
> Mohon bantuannya, saya mempunyai data Km dari unit, pada saat dihitung
> jarak tempuh dalam satu bulan dan jika dipecahkan ke dalam mingguan, kenapa
> hasilnya berbeda? Maksudnya pada hasil cell am4:am8 jika dikompare dengan
> hasil cell at4:at8 ada perbedaan (cell au4:au8).
>
>
>
> Mohon pencerahan dan solusinya, atas bantuannya diucapkan terima kasih.
>
>
>
>
>
> Hormat saya,
>
>
>
> *Samsudin*
>
>
>
> --- Mods ---
>
> File lampiran yang melebihi 250KB dilepas dari email. Silakan penanya
> melampirkan ulang file yang berukuran maksimal 250KB dengan cara me-reply
> email ini.
>
> ----------------
>
>
>
>
> ----------------------------------------------------------
>
> This message (including any attachments) contains confidential information intended
> for a specific individual and purpose, and is protected by law. If you are not the
> intended recipient, you should delete this message and hereby notified that any
> disclosure, copying, or distribution of this message (or any part thereof), or the
> taking of any action based on it, is strictly prohibited. No liability or responsibility
> is accepted if information or data is, for whatever reason corrupted or does not reach
> its intended recipient. No warranty is given that this email is free of viruses. The
> views expressed in this email are, unless otherwise stated, those of the author and
> not those of the Company or its management. The Company reserves the right to monitor,
> intercept and block emails addressed to its users or take any other action in accordance
> with its email use policy.
>
>
>

Mon Mar 30, 2015 6:55 pm (PDT) . Posted by:

"Dwi Hartanto"

Ass...Mau tanya dong rumus macro utk goalseek sampai data terakhirTrims
Wass..

Mon Mar 30, 2015 9:40 pm (PDT) . Posted by:

"iwan sujarwadi" iwansujarwadi

Dear Suhu Excel ,

Saya mau tanya bagaimana rumus menjumlah apabila data yang sama tidak di hitung


NO NAMA BUAH 1 APEL * 2 PISANG 3 APEL * 4 JERUK * 5 MELON 6 JERUK * 7 MANGGIS JUMLAH ? ( BAGAIMANA MENJUMLAH APABILA NAMA BUAH YANG SAMA DI HITUNG 1 )

Terima kasih


Salam


IWAN SUJARWADI

--- Mods ---
Dimohon pada postingan berikutnya untuk menggunakan huruf kapital pada awal kalimat atau pada sebuah frase yang dianggap penting saja. Hindari penggunaan huruf kapital diseluruh karakter dalam suatu kalimat, karena bisa diartikan Anda sedang berteriak meminta prioritas pertama untuk segera diperhatikan dan direspon secepatnya.
-----------------



Mon Mar 30, 2015 10:04 pm (PDT) . Posted by:

"uharyanto" uharyanto@ymail.com

Coba pake ini pak =SUMPRODUCT(1/COUNTIF($B$2:$B$8,$B$2:$B$8))

tks

On 31/03/2015 10:22 AM, iwan sujarwadi iwansujarwadi@yahoo.co.id
[belajar-excel] wrote:
> Dear Suhu Excel ,
>
> Saya mau tanya bagaimana rumus menjumlah apabila data yang sama tidak
> di hitung
>
> NO NAMA BUAH
> 1 APEL *
> 2 PISANG
> 3 APEL *
> 4 JERUK *
> 5 MELON
> 6 JERUK *
> 7 MANGGIS
> JUMLAH ? ( BAGAIMANA MENJUMLAH APABILA NAMA BUAH YANG
> SAMA DI HITUNG 1 )
>
>
> Terima kasih
>
> Salam
>
> IWAN SUJARWADI
>
> --- Mods ---
> Dimohon pada postingan berikutnya untuk menggunakan huruf kapital pada
> awal kalimat atau pada sebuah frase yang dianggap penting saja.
> Hindari penggunaan huruf kapital diseluruh karakter dalam suatu
> kalimat, karena bisa diartikan Anda sedang berteriak meminta prioritas
> pertama untuk segera diperhatikan dan direspon secepatnya.
> -----------------
>

Mon Mar 30, 2015 11:14 pm (PDT) . Posted by:

"Yulianti Agustina" lie_evil_4

kalau boleh tau rules dari 2 kriteria itu bagaimana ya..?

2015-03-27 16:56 GMT+07:00 Krisan Flower krisan_flower@rocketmail.com
[belajar-excel] <belajar-excel@yahoogroups.com>:

>
>
> Dear Para Master ,
>
> Salam..
>
> Mohon pencerahan untuk mencari nilai di sebuah shell dengan 2 kriteria
> yang ada,
> saya menggunakan fungsi if tapi hasilnya malah value, coba utak atik pake
> vlookup tapi masih gak sesuai harapan.
> Mohon bantuannya Master,,,
>

> Suwun..
>
> Krisan.
>
>
>

Tue Mar 31, 2015 12:03 am (PDT) . Posted by:

teguh.indrawanto

Dear Pakar Excel,


Mohon bantuannya untuk memcahkan soal terlampir !!


atas perhatian dan bantuannya diucapkan banyak terima kasih.


Regards,


Teguh

Tue Mar 31, 2015 12:17 am (PDT) . Posted by:

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

Hai Teguh,

File terlampir memanfaatkan format number untuk menampilkan suatu makna
teks dari suatu nilai numerik.

Wassalam,
Kid.

2015-03-31 17:32 GMT+11:00 teguh.indrawanto@yahoo.com [belajar-excel] <
belajar-excel@yahoogroups.com>:

>
>
> Dear Pakar Excel,
>
>
> Mohon bantuannya untuk memcahkan soal terlampir !!
>
>
> atas perhatian dan bantuannya diucapkan banyak terima kasih.
>
>
> Regards,
>
>
> Teguh
>
>
>

Tue Mar 31, 2015 12:55 am (PDT) . Posted by:

"Toby kenzo" tobykenzo

Dear Teguh, Coba pake ini : =IF((D4-C4)-(8*360/(60*144))<0,"-"& TEXT(ABS(D6-C6)-((8*360)/(60*144)),"h:mm"),(D4-C4)-(8*360/(60*144))) jika hasilnya "-" (minus) maka kurangnya waktu bekeja, jika tidak ada tanda apapun maka itu lebihnya waktu dalam bekerja. Jangan lupa di setting pada excelnya "Use 1904 date system" (8*360/(60*144)) = 8 jam   TerimaKasih.  

Pada Selasa, 31 Maret 2015 14:03, "teguh.indrawanto@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Dear Pakar Excel,
Mohon bantuannya untuk memcahkan soal terlampir !!
atas perhatian dan bantuannya diucapkan banyak terima kasih.
Regards,
Teguh #yiv2103762097 #yiv2103762097 -- #yiv2103762097ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2103762097 #yiv2103762097ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2103762097 #yiv2103762097ygrp-mkp #yiv2103762097hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2103762097 #yiv2103762097ygrp-mkp #yiv2103762097ads {margin-bottom:10px;}#yiv2103762097 #yiv2103762097ygrp-mkp .yiv2103762097ad {padding:0 0;}#yiv2103762097 #yiv2103762097ygrp-mkp .yiv2103762097ad p {margin:0;}#yiv2103762097 #yiv2103762097ygrp-mkp .yiv2103762097ad a {color:#0000ff;text-decoration:none;}#yiv2103762097 #yiv2103762097ygrp-sponsor #yiv2103762097ygrp-lc {font-family:Arial;}#yiv2103762097 #yiv2103762097ygrp-sponsor #yiv2103762097ygrp-lc #yiv2103762097hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2103762097 #yiv2103762097ygrp-sponsor #yiv2103762097ygrp-lc .yiv2103762097ad {margin-bottom:10px;padding:0 0;}#yiv2103762097 #yiv2103762097actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2103762097 #yiv2103762097activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2103762097 #yiv2103762097activity span {font-weight:700;}#yiv2103762097 #yiv2103762097activity span:first-child {text-transform:uppercase;}#yiv2103762097 #yiv2103762097activity span a {color:#5085b6;text-decoration:none;}#yiv2103762097 #yiv2103762097activity span span {color:#ff7900;}#yiv2103762097 #yiv2103762097activity span .yiv2103762097underline {text-decoration:underline;}#yiv2103762097 .yiv2103762097attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2103762097 .yiv2103762097attach div a {text-decoration:none;}#yiv2103762097 .yiv2103762097attach img {border:none;padding-right:5px;}#yiv2103762097 .yiv2103762097attach label {display:block;margin-bottom:5px;}#yiv2103762097 .yiv2103762097attach label a {text-decoration:none;}#yiv2103762097 blockquote {margin:0 0 0 4px;}#yiv2103762097 .yiv2103762097bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2103762097 .yiv2103762097bold a {text-decoration:none;}#yiv2103762097 dd.yiv2103762097last p a {font-family:Verdana;font-weight:700;}#yiv2103762097 dd.yiv2103762097last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2103762097 dd.yiv2103762097last p span.yiv2103762097yshortcuts {margin-right:0;}#yiv2103762097 div.yiv2103762097attach-table div div a {text-decoration:none;}#yiv2103762097 div.yiv2103762097attach-table {width:400px;}#yiv2103762097 div.yiv2103762097file-title a, #yiv2103762097 div.yiv2103762097file-title a:active, #yiv2103762097 div.yiv2103762097file-title a:hover, #yiv2103762097 div.yiv2103762097file-title a:visited {text-decoration:none;}#yiv2103762097 div.yiv2103762097photo-title a, #yiv2103762097 div.yiv2103762097photo-title a:active, #yiv2103762097 div.yiv2103762097photo-title a:hover, #yiv2103762097 div.yiv2103762097photo-title a:visited {text-decoration:none;}#yiv2103762097 div#yiv2103762097ygrp-mlmsg #yiv2103762097ygrp-msg p a span.yiv2103762097yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2103762097 .yiv2103762097green {color:#628c2a;}#yiv2103762097 .yiv2103762097MsoNormal {margin:0 0 0 0;}#yiv2103762097 o {font-size:0;}#yiv2103762097 #yiv2103762097photos div {float:left;width:72px;}#yiv2103762097 #yiv2103762097photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv2103762097 #yiv2103762097photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2103762097 #yiv2103762097reco-category {font-size:77%;}#yiv2103762097 #yiv2103762097reco-desc {font-size:77%;}#yiv2103762097 .yiv2103762097replbq {margin:4px;}#yiv2103762097 #yiv2103762097ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2103762097 #yiv2103762097ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2103762097 #yiv2103762097ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2103762097 #yiv2103762097ygrp-mlmsg select, #yiv2103762097 input, #yiv2103762097 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2103762097 #yiv2103762097ygrp-mlmsg pre, #yiv2103762097 code {font:115% monospace;}#yiv2103762097 #yiv2103762097ygrp-mlmsg * {line-height:1.22em;}#yiv2103762097 #yiv2103762097ygrp-mlmsg #yiv2103762097logo {padding-bottom:10px;}#yiv2103762097 #yiv2103762097ygrp-msg p a {font-family:Verdana;}#yiv2103762097 #yiv2103762097ygrp-msg p#yiv2103762097attach-count span {color:#1E66AE;font-weight:700;}#yiv2103762097 #yiv2103762097ygrp-reco #yiv2103762097reco-head {color:#ff7900;font-weight:700;}#yiv2103762097 #yiv2103762097ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2103762097 #yiv2103762097ygrp-sponsor #yiv2103762097ov li a {font-size:130%;text-decoration:none;}#yiv2103762097 #yiv2103762097ygrp-sponsor #yiv2103762097ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2103762097 #yiv2103762097ygrp-sponsor #yiv2103762097ov ul {margin:0;padding:0 0 0 8px;}#yiv2103762097 #yiv2103762097ygrp-text {font-family:Georgia;}#yiv2103762097 #yiv2103762097ygrp-text p {margin:0 0 1em 0;}#yiv2103762097 #yiv2103762097ygrp-text tt {font-size:120%;}#yiv2103762097 #yiv2103762097ygrp-vital ul li:last-child {border-right:none !important;}#yiv2103762097

Tue Mar 31, 2015 1:06 am (PDT) . Posted by:

"teguh indrawanto" teguh.indrawanto

OK Pak,akan saya coba dlu. mohon arahannya kembali apabila belum berhasil..

terima kasih banyak atas jawabanya..
Regards,
Teguh

On Tuesday, March 31, 2015 2:55 PM, "Toby kenzo tobykenzo@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> wrote:


  Dear Teguh, Coba pake ini : =IF((D4-C4)-(8*360/(60*144))<0,"-"& TEXT(ABS(D6-C6)-((8*360)/(60*144)),"h:mm"),(D4-C4)-(8*360/(60*144))) jika hasilnya "-" (minus) maka kurangnya waktu bekeja, jika tidak ada tanda apapun maka itu lebihnya waktu dalam bekerja. Jangan lupa di setting pada excelnya "Use 1904 date system" (8*360/(60*144)) = 8 jam   TerimaKasih.  

Pada Selasa, 31 Maret 2015 14:03, "teguh.indrawanto@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Dear Pakar Excel,
Mohon bantuannya untuk memcahkan soal terlampir !!
atas perhatian dan bantuannya diucapkan banyak terima kasih.
Regards,
Teguh

#yiv9610212537 #yiv9610212537 -- #yiv9610212537ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9610212537 #yiv9610212537ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9610212537 #yiv9610212537ygrp-mkp #yiv9610212537hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv9610212537 #yiv9610212537ygrp-mkp #yiv9610212537ads {margin-bottom:10px;}#yiv9610212537 #yiv9610212537ygrp-mkp .yiv9610212537ad {padding:0 0;}#yiv9610212537 #yiv9610212537ygrp-mkp .yiv9610212537ad p {margin:0;}#yiv9610212537 #yiv9610212537ygrp-mkp .yiv9610212537ad a {color:#0000ff;text-decoration:none;}#yiv9610212537 #yiv9610212537ygrp-sponsor #yiv9610212537ygrp-lc {font-family:Arial;}#yiv9610212537 #yiv9610212537ygrp-sponsor #yiv9610212537ygrp-lc #yiv9610212537hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9610212537 #yiv9610212537ygrp-sponsor #yiv9610212537ygrp-lc .yiv9610212537ad {margin-bottom:10px;padding:0 0;}#yiv9610212537 #yiv9610212537actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9610212537 #yiv9610212537activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9610212537 #yiv9610212537activity span {font-weight:700;}#yiv9610212537 #yiv9610212537activity span:first-child {text-transform:uppercase;}#yiv9610212537 #yiv9610212537activity span a {color:#5085b6;text-decoration:none;}#yiv9610212537 #yiv9610212537activity span span {color:#ff7900;}#yiv9610212537 #yiv9610212537activity span .yiv9610212537underline {text-decoration:underline;}#yiv9610212537 .yiv9610212537attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv9610212537 .yiv9610212537attach div a {text-decoration:none;}#yiv9610212537 .yiv9610212537attach img {border:none;padding-right:5px;}#yiv9610212537 .yiv9610212537attach label {display:block;margin-bottom:5px;}#yiv9610212537 .yiv9610212537attach label a {text-decoration:none;}#yiv9610212537 blockquote {margin:0 0 0 4px;}#yiv9610212537 .yiv9610212537bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv9610212537 .yiv9610212537bold a {text-decoration:none;}#yiv9610212537 dd.yiv9610212537last p a {font-family:Verdana;font-weight:700;}#yiv9610212537 dd.yiv9610212537last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9610212537 dd.yiv9610212537last p span.yiv9610212537yshortcuts {margin-right:0;}#yiv9610212537 div.yiv9610212537attach-table div div a {text-decoration:none;}#yiv9610212537 div.yiv9610212537attach-table {width:400px;}#yiv9610212537 div.yiv9610212537file-title a, #yiv9610212537 div.yiv9610212537file-title a:active, #yiv9610212537 div.yiv9610212537file-title a:hover, #yiv9610212537 div.yiv9610212537file-title a:visited {text-decoration:none;}#yiv9610212537 div.yiv9610212537photo-title a, #yiv9610212537 div.yiv9610212537photo-title a:active, #yiv9610212537 div.yiv9610212537photo-title a:hover, #yiv9610212537 div.yiv9610212537photo-title a:visited {text-decoration:none;}#yiv9610212537 div#yiv9610212537ygrp-mlmsg #yiv9610212537ygrp-msg p a span.yiv9610212537yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9610212537 .yiv9610212537green {color:#628c2a;}#yiv9610212537 .yiv9610212537MsoNormal {margin:0 0 0 0;}#yiv9610212537 o {font-size:0;}#yiv9610212537 #yiv9610212537photos div {float:left;width:72px;}#yiv9610212537 #yiv9610212537photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv9610212537 #yiv9610212537photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9610212537 #yiv9610212537reco-category {font-size:77%;}#yiv9610212537 #yiv9610212537reco-desc {font-size:77%;}#yiv9610212537 .yiv9610212537replbq {margin:4px;}#yiv9610212537 #yiv9610212537ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv9610212537 #yiv9610212537ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9610212537 #yiv9610212537ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9610212537 #yiv9610212537ygrp-mlmsg select, #yiv9610212537 input, #yiv9610212537 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv9610212537 #yiv9610212537ygrp-mlmsg pre, #yiv9610212537 code {font:115% monospace;}#yiv9610212537 #yiv9610212537ygrp-mlmsg * {line-height:1.22em;}#yiv9610212537 #yiv9610212537ygrp-mlmsg #yiv9610212537logo {padding-bottom:10px;}#yiv9610212537 #yiv9610212537ygrp-msg p a {font-family:Verdana;}#yiv9610212537 #yiv9610212537ygrp-msg p#yiv9610212537attach-count span {color:#1E66AE;font-weight:700;}#yiv9610212537 #yiv9610212537ygrp-reco #yiv9610212537reco-head {color:#ff7900;font-weight:700;}#yiv9610212537 #yiv9610212537ygrp-reco {margin-bottom:20px;padding:0px;}#yiv9610212537 #yiv9610212537ygrp-sponsor #yiv9610212537ov li a {font-size:130%;text-decoration:none;}#yiv9610212537 #yiv9610212537ygrp-sponsor #yiv9610212537ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv9610212537 #yiv9610212537ygrp-sponsor #yiv9610212537ov ul {margin:0;padding:0 0 0 8px;}#yiv9610212537 #yiv9610212537ygrp-text {font-family:Georgia;}#yiv9610212537 #yiv9610212537ygrp-text p {margin:0 0 1em 0;}#yiv9610212537 #yiv9610212537ygrp-text tt {font-size:120%;}#yiv9610212537 #yiv9610212537ygrp-vital ul li:last-child {border-right:none !important;}#yiv9610212537

Tue Mar 31, 2015 2:34 am (PDT) . Posted by:

"ahari49" ahari49



KepadaYth.
 para master excel

Salam kenal nama saya Agung  

Saya mempunyai permasalahan (terlampir).
Bagaimana rumusnya agar kolom NIK pada sheet KK dapat terisi (isinnya biar ngak manual....capekkk!!) Kolom NIK pd Sheet No. NIK. 

Terima kasih

Terkirim dari tablet Samsung

Terkirim dari tablet Samsung
============================================================
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:

Posting Komentar