Selasa, 09 Juni 2015

[belajar-excel] Digest Number 3465

8 Messages

Digest #3465

Messages

Mon Jun 8, 2015 7:32 am (PDT) . Posted by:

"Toby kenzo" tobykenzo

Dear pak Tjahya,

Berikut filenya.

TerimaKasih.

Sent from Yahoo Mail on Android

Mon Jun 8, 2015 1:31 pm (PDT) . Posted by:

"Tjahya Hartono" tjahyahartono

Terima kasih Ibu Jan dan khususnya Pak Toby yang sudah sangat membantu atas problemnya. Terima kasih untuk masukannya.

Salam Hangat

Tjahya  


Pada Senin, 8 Juni 2015 21:32, "Toby kenzo tobykenzo@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


 
| Dear pak Tjahya,Berikut filenya.TerimaKasih.Sent from Yahoo Mail on Android |

From: Tjahya Hartono tjahyahartono@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com>;
To: <belajar-excel@yahoogroups.com>;
Subject: Bls: [belajar-excel] Cara hitung lembur [1 Attachment]
Sent: Mon, Jun 8, 2015 9:59:22 AM


|   Dear Bpk Tobby
Terima kasih untuk bantuan yang sudah anda berikan, tetapi saya masih bingung, karenaada yang tidak sesuai dengan harapan. Saya berikan dalam sebuah file terlampir, untuk menjelaskanperihal tersebut.
Salam Hangat

Tjahya
 


Pada Minggu, 7 Juni 2015 19:00, "Toby kenzo tobykenzo@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


 
| Dear pak Tjahya,Mungkin file ini bisa membantu.TerimaKasih.Sent from Yahoo Mail on Android |

From: Tjahya Hartono tjahyahartono@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com>;
To: <belajar-excel@yahoogroups.com>;
Subject: [belajar-excel] Cara hitung lembur [1 Attachment]
Sent: Fri, Jun 5, 2015 8:25:52 AM


|     Dear Be Excel,Bagaimanacaranya ya mengisi lembur dari input absen, tetapi hasilnya langsung dimasukkanlangsung kedalam cell G8. Berikut saya lampirkan datanya dibawah.Terimakasih

SalamHangat

Tjahya

|

|

#yiv0506612921 #yiv0506612921 -- #yiv0506612921ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0506612921 #yiv0506612921ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0506612921 #yiv0506612921ygrp-mkp #yiv0506612921hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0506612921 #yiv0506612921ygrp-mkp #yiv0506612921ads {margin-bottom:10px;}#yiv0506612921 #yiv0506612921ygrp-mkp .yiv0506612921ad {padding:0 0;}#yiv0506612921 #yiv0506612921ygrp-mkp .yiv0506612921ad p {margin:0;}#yiv0506612921 #yiv0506612921ygrp-mkp .yiv0506612921ad a {color:#0000ff;text-decoration:none;}#yiv0506612921 #yiv0506612921ygrp-sponsor #yiv0506612921ygrp-lc {font-family:Arial;}#yiv0506612921 #yiv0506612921ygrp-sponsor #yiv0506612921ygrp-lc #yiv0506612921hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0506612921 #yiv0506612921ygrp-sponsor #yiv0506612921ygrp-lc .yiv0506612921ad {margin-bottom:10px;padding:0 0;}#yiv0506612921 #yiv0506612921actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0506612921 #yiv0506612921activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0506612921 #yiv0506612921activity span {font-weight:700;}#yiv0506612921 #yiv0506612921activity span:first-child {text-transform:uppercase;}#yiv0506612921 #yiv0506612921activity span a {color:#5085b6;text-decoration:none;}#yiv0506612921 #yiv0506612921activity span span {color:#ff7900;}#yiv0506612921 #yiv0506612921activity span .yiv0506612921underline {text-decoration:underline;}#yiv0506612921 .yiv0506612921attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0506612921 .yiv0506612921attach div a {text-decoration:none;}#yiv0506612921 .yiv0506612921attach img {border:none;padding-right:5px;}#yiv0506612921 .yiv0506612921attach label {display:block;margin-bottom:5px;}#yiv0506612921 .yiv0506612921attach label a {text-decoration:none;}#yiv0506612921 blockquote {margin:0 0 0 4px;}#yiv0506612921 .yiv0506612921bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0506612921 .yiv0506612921bold a {text-decoration:none;}#yiv0506612921 dd.yiv0506612921last p a {font-family:Verdana;font-weight:700;}#yiv0506612921 dd.yiv0506612921last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0506612921 dd.yiv0506612921last p span.yiv0506612921yshortcuts {margin-right:0;}#yiv0506612921 div.yiv0506612921attach-table div div a {text-decoration:none;}#yiv0506612921 div.yiv0506612921attach-table {width:400px;}#yiv0506612921 div.yiv0506612921file-title a, #yiv0506612921 div.yiv0506612921file-title a:active, #yiv0506612921 div.yiv0506612921file-title a:hover, #yiv0506612921 div.yiv0506612921file-title a:visited {text-decoration:none;}#yiv0506612921 div.yiv0506612921photo-title a, #yiv0506612921 div.yiv0506612921photo-title a:active, #yiv0506612921 div.yiv0506612921photo-title a:hover, #yiv0506612921 div.yiv0506612921photo-title a:visited {text-decoration:none;}#yiv0506612921 div#yiv0506612921ygrp-mlmsg #yiv0506612921ygrp-msg p a span.yiv0506612921yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0506612921 .yiv0506612921green {color:#628c2a;}#yiv0506612921 .yiv0506612921MsoNormal {margin:0 0 0 0;}#yiv0506612921 o {font-size:0;}#yiv0506612921 #yiv0506612921photos div {float:left;width:72px;}#yiv0506612921 #yiv0506612921photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv0506612921 #yiv0506612921photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0506612921 #yiv0506612921reco-category {font-size:77%;}#yiv0506612921 #yiv0506612921reco-desc {font-size:77%;}#yiv0506612921 .yiv0506612921replbq {margin:4px;}#yiv0506612921 #yiv0506612921ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0506612921 #yiv0506612921ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0506612921 #yiv0506612921ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0506612921 #yiv0506612921ygrp-mlmsg select, #yiv0506612921 input, #yiv0506612921 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0506612921 #yiv0506612921ygrp-mlmsg pre, #yiv0506612921 code {font:115% monospace;}#yiv0506612921 #yiv0506612921ygrp-mlmsg * {line-height:1.22em;}#yiv0506612921 #yiv0506612921ygrp-mlmsg #yiv0506612921logo {padding-bottom:10px;}#yiv0506612921 #yiv0506612921ygrp-msg p a {font-family:Verdana;}#yiv0506612921 #yiv0506612921ygrp-msg p#yiv0506612921attach-count span {color:#1E66AE;font-weight:700;}#yiv0506612921 #yiv0506612921ygrp-reco #yiv0506612921reco-head {color:#ff7900;font-weight:700;}#yiv0506612921 #yiv0506612921ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0506612921 #yiv0506612921ygrp-sponsor #yiv0506612921ov li a {font-size:130%;text-decoration:none;}#yiv0506612921 #yiv0506612921ygrp-sponsor #yiv0506612921ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0506612921 #yiv0506612921ygrp-sponsor #yiv0506612921ov ul {margin:0;padding:0 0 0 8px;}#yiv0506612921 #yiv0506612921ygrp-text {font-family:Georgia;}#yiv0506612921 #yiv0506612921ygrp-text p {margin:0 0 1em 0;}#yiv0506612921 #yiv0506612921ygrp-text tt {font-size:120%;}#yiv0506612921 #yiv0506612921ygrp-vital ul li:last-child {border-right:none !important;}#yiv0506612921

Mon Jun 8, 2015 7:57 am (PDT) . Posted by:

"Toby kenzo" tobykenzo

Dear pak Saryono,

Coba di buka2 lg threat sebelum2nya,ada yg bahas apa yg bapak inginkan.

TerimaKasih.

Sent from Yahoo Mail on Android

Mon Jun 8, 2015 5:47 pm (PDT) . Posted by:

"Agusti Dartius"

Terima kasih banyak pak Kid.Its helpful


On Saturday, June 6, 2015 6:09 PM, "'Mr. Kid' mr.nmkid@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com> wrote:


  Hai Agus,

File terlampir.

Regard,
Kid

2015-06-06 17:37 GMT+10:00 Agusti Dartius adartius@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com>:

  Selamat sore semuanya.Saya ada pertanyaan. Pertanyaan saya sudah saya tilis di dlama file terlampirMohon bantuannya master2 semua.
Terima Kasih


#yiv5099847547 #yiv5099847547 -- #yiv5099847547ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5099847547 #yiv5099847547ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5099847547 #yiv5099847547ygrp-mkp #yiv5099847547hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5099847547 #yiv5099847547ygrp-mkp #yiv5099847547ads {margin-bottom:10px;}#yiv5099847547 #yiv5099847547ygrp-mkp .yiv5099847547ad {padding:0 0;}#yiv5099847547 #yiv5099847547ygrp-mkp .yiv5099847547ad p {margin:0;}#yiv5099847547 #yiv5099847547ygrp-mkp .yiv5099847547ad a {color:#0000ff;text-decoration:none;}#yiv5099847547 #yiv5099847547ygrp-sponsor #yiv5099847547ygrp-lc {font-family:Arial;}#yiv5099847547 #yiv5099847547ygrp-sponsor #yiv5099847547ygrp-lc #yiv5099847547hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5099847547 #yiv5099847547ygrp-sponsor #yiv5099847547ygrp-lc .yiv5099847547ad {margin-bottom:10px;padding:0 0;}#yiv5099847547 #yiv5099847547actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5099847547 #yiv5099847547activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5099847547 #yiv5099847547activity span {font-weight:700;}#yiv5099847547 #yiv5099847547activity span:first-child {text-transform:uppercase;}#yiv5099847547 #yiv5099847547activity span a {color:#5085b6;text-decoration:none;}#yiv5099847547 #yiv5099847547activity span span {color:#ff7900;}#yiv5099847547 #yiv5099847547activity span .yiv5099847547underline {text-decoration:underline;}#yiv5099847547 .yiv5099847547attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv5099847547 .yiv5099847547attach div a {text-decoration:none;}#yiv5099847547 .yiv5099847547attach img {border:none;padding-right:5px;}#yiv5099847547 .yiv5099847547attach label {display:block;margin-bottom:5px;}#yiv5099847547 .yiv5099847547attach label a {text-decoration:none;}#yiv5099847547 blockquote {margin:0 0 0 4px;}#yiv5099847547 .yiv5099847547bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv5099847547 .yiv5099847547bold a {text-decoration:none;}#yiv5099847547 dd.yiv5099847547last p a {font-family:Verdana;font-weight:700;}#yiv5099847547 dd.yiv5099847547last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5099847547 dd.yiv5099847547last p span.yiv5099847547yshortcuts {margin-right:0;}#yiv5099847547 div.yiv5099847547attach-table div div a {text-decoration:none;}#yiv5099847547 div.yiv5099847547attach-table {width:400px;}#yiv5099847547 div.yiv5099847547file-title a, #yiv5099847547 div.yiv5099847547file-title a:active, #yiv5099847547 div.yiv5099847547file-title a:hover, #yiv5099847547 div.yiv5099847547file-title a:visited {text-decoration:none;}#yiv5099847547 div.yiv5099847547photo-title a, #yiv5099847547 div.yiv5099847547photo-title a:active, #yiv5099847547 div.yiv5099847547photo-title a:hover, #yiv5099847547 div.yiv5099847547photo-title a:visited {text-decoration:none;}#yiv5099847547 div#yiv5099847547ygrp-mlmsg #yiv5099847547ygrp-msg p a span.yiv5099847547yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5099847547 .yiv5099847547green {color:#628c2a;}#yiv5099847547 .yiv5099847547MsoNormal {margin:0 0 0 0;}#yiv5099847547 o {font-size:0;}#yiv5099847547 #yiv5099847547photos div {float:left;width:72px;}#yiv5099847547 #yiv5099847547photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv5099847547 #yiv5099847547photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5099847547 #yiv5099847547reco-category {font-size:77%;}#yiv5099847547 #yiv5099847547reco-desc {font-size:77%;}#yiv5099847547 .yiv5099847547replbq {margin:4px;}#yiv5099847547 #yiv5099847547ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv5099847547 #yiv5099847547ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5099847547 #yiv5099847547ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5099847547 #yiv5099847547ygrp-mlmsg select, #yiv5099847547 input, #yiv5099847547 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv5099847547 #yiv5099847547ygrp-mlmsg pre, #yiv5099847547 code {font:115% monospace;}#yiv5099847547 #yiv5099847547ygrp-mlmsg * {line-height:1.22em;}#yiv5099847547 #yiv5099847547ygrp-mlmsg #yiv5099847547logo {padding-bottom:10px;}#yiv5099847547 #yiv5099847547ygrp-msg p a {font-family:Verdana;}#yiv5099847547 #yiv5099847547ygrp-msg p#yiv5099847547attach-count span {color:#1E66AE;font-weight:700;}#yiv5099847547 #yiv5099847547ygrp-reco #yiv5099847547reco-head {color:#ff7900;font-weight:700;}#yiv5099847547 #yiv5099847547ygrp-reco {margin-bottom:20px;padding:0px;}#yiv5099847547 #yiv5099847547ygrp-sponsor #yiv5099847547ov li a {font-size:130%;text-decoration:none;}#yiv5099847547 #yiv5099847547ygrp-sponsor #yiv5099847547ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv5099847547 #yiv5099847547ygrp-sponsor #yiv5099847547ov ul {margin:0;padding:0 0 0 8px;}#yiv5099847547 #yiv5099847547ygrp-text {font-family:Georgia;}#yiv5099847547 #yiv5099847547ygrp-text p {margin:0 0 1em 0;}#yiv5099847547 #yiv5099847547ygrp-text tt {font-size:120%;}#yiv5099847547 #yiv5099847547ygrp-vital ul li:last-child {border-right:none !important;}#yiv5099847547

Mon Jun 8, 2015 7:02 pm (PDT) . Posted by:

"Subroto, Matzen"

Mr. Kid

Syukron, semoga Manfaat


Terima kasih atas perhatian dan kerjasamanya, dan saya mohon maaf apabila ada kata-kata yang kurang berkenan


Terima Kasih

Matzen



From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: 08 Juni 2015 15:51
To: BeExcel
Subject: Re: [belajar-excel] Membatasi View range..


Pak Matzen,
Kolom dan baris kosongnya di-hide.
Wassalam,
Kid



2015-06-08 18:44 GMT+10:00 'Subroto, Matzen' matzen.subroto@akzonobel.com<mailto:matzen.subroto@akzonobel.com> [belajar-excel] <belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com>>:

Dear Master,

Mohon pencerahan, gimana cara membatasi range seperti gambar di bawah ini step by step nya.

Terima kasih atas perhatian dan kerjasamanya, dan saya mohon maaf apabila ada kata-kata yang kurang berkenan


Terima Kasih

Matzen




__________________________________________________________
This email has been scanned for Viruses and Spam. For more information
please contact your local Business Unit Information Security representative.
__________________________________________________________

Mon Jun 8, 2015 9:53 pm (PDT) . Posted by:

"Syaiful Hanan"

السَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ
​bagaimana kita bisa mencari jumlah nama yang kita inginkan ?​

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

Mon Jun 8, 2015 10:11 pm (PDT) . Posted by:

"Andrie -" sioean2

Dear Syaiful,
Dicoba memakai formula berikut :=COUNTIF(B2:B8,"ramli")

Regards,Andrie
From: "Syaiful Hanan ananinadam@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Tuesday, June 9, 2015 11:47 AM
Subject: [belajar-excel] penjumlahan nama [1 Attachment]

 
السَّلَامُعَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ​bagaimana kita bisa mencari jumlah nama yang kita inginkan ?​
 وَالسَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ 

#yiv7752572321 #yiv7752572321 -- #yiv7752572321ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7752572321 #yiv7752572321ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7752572321 #yiv7752572321ygrp-mkp #yiv7752572321hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7752572321 #yiv7752572321ygrp-mkp #yiv7752572321ads {margin-bottom:10px;}#yiv7752572321 #yiv7752572321ygrp-mkp .yiv7752572321ad {padding:0 0;}#yiv7752572321 #yiv7752572321ygrp-mkp .yiv7752572321ad p {margin:0;}#yiv7752572321 #yiv7752572321ygrp-mkp .yiv7752572321ad a {color:#0000ff;text-decoration:none;}#yiv7752572321 #yiv7752572321ygrp-sponsor #yiv7752572321ygrp-lc {font-family:Arial;}#yiv7752572321 #yiv7752572321ygrp-sponsor #yiv7752572321ygrp-lc #yiv7752572321hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7752572321 #yiv7752572321ygrp-sponsor #yiv7752572321ygrp-lc .yiv7752572321ad {margin-bottom:10px;padding:0 0;}#yiv7752572321 #yiv7752572321actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7752572321 #yiv7752572321activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7752572321 #yiv7752572321activity span {font-weight:700;}#yiv7752572321 #yiv7752572321activity span:first-child {text-transform:uppercase;}#yiv7752572321 #yiv7752572321activity span a {color:#5085b6;text-decoration:none;}#yiv7752572321 #yiv7752572321activity span span {color:#ff7900;}#yiv7752572321 #yiv7752572321activity span .yiv7752572321underline {text-decoration:underline;}#yiv7752572321 .yiv7752572321attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7752572321 .yiv7752572321attach div a {text-decoration:none;}#yiv7752572321 .yiv7752572321attach img {border:none;padding-right:5px;}#yiv7752572321 .yiv7752572321attach label {display:block;margin-bottom:5px;}#yiv7752572321 .yiv7752572321attach label a {text-decoration:none;}#yiv7752572321 blockquote {margin:0 0 0 4px;}#yiv7752572321 .yiv7752572321bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7752572321 .yiv7752572321bold a {text-decoration:none;}#yiv7752572321 dd.yiv7752572321last p a {font-family:Verdana;font-weight:700;}#yiv7752572321 dd.yiv7752572321last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7752572321 dd.yiv7752572321last p span.yiv7752572321yshortcuts {margin-right:0;}#yiv7752572321 div.yiv7752572321attach-table div div a {text-decoration:none;}#yiv7752572321 div.yiv7752572321attach-table {width:400px;}#yiv7752572321 div.yiv7752572321file-title a, #yiv7752572321 div.yiv7752572321file-title a:active, #yiv7752572321 div.yiv7752572321file-title a:hover, #yiv7752572321 div.yiv7752572321file-title a:visited {text-decoration:none;}#yiv7752572321 div.yiv7752572321photo-title a, #yiv7752572321 div.yiv7752572321photo-title a:active, #yiv7752572321 div.yiv7752572321photo-title a:hover, #yiv7752572321 div.yiv7752572321photo-title a:visited {text-decoration:none;}#yiv7752572321 div#yiv7752572321ygrp-mlmsg #yiv7752572321ygrp-msg p a span.yiv7752572321yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7752572321 .yiv7752572321green {color:#628c2a;}#yiv7752572321 .yiv7752572321MsoNormal {margin:0 0 0 0;}#yiv7752572321 o {font-size:0;}#yiv7752572321 #yiv7752572321photos div {float:left;width:72px;}#yiv7752572321 #yiv7752572321photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv7752572321 #yiv7752572321photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7752572321 #yiv7752572321reco-category {font-size:77%;}#yiv7752572321 #yiv7752572321reco-desc {font-size:77%;}#yiv7752572321 .yiv7752572321replbq {margin:4px;}#yiv7752572321 #yiv7752572321ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv7752572321 #yiv7752572321ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7752572321 #yiv7752572321ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7752572321 #yiv7752572321ygrp-mlmsg select, #yiv7752572321 input, #yiv7752572321 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv7752572321 #yiv7752572321ygrp-mlmsg pre, #yiv7752572321 code {font:115% monospace;}#yiv7752572321 #yiv7752572321ygrp-mlmsg * {line-height:1.22em;}#yiv7752572321 #yiv7752572321ygrp-mlmsg #yiv7752572321logo {padding-bottom:10px;}#yiv7752572321 #yiv7752572321ygrp-msg p a {font-family:Verdana;}#yiv7752572321 #yiv7752572321ygrp-msg p#yiv7752572321attach-count span {color:#1E66AE;font-weight:700;}#yiv7752572321 #yiv7752572321ygrp-reco #yiv7752572321reco-head {color:#ff7900;font-weight:700;}#yiv7752572321 #yiv7752572321ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7752572321 #yiv7752572321ygrp-sponsor #yiv7752572321ov li a {font-size:130%;text-decoration:none;}#yiv7752572321 #yiv7752572321ygrp-sponsor #yiv7752572321ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7752572321 #yiv7752572321ygrp-sponsor #yiv7752572321ov ul {margin:0;padding:0 0 0 8px;}#yiv7752572321 #yiv7752572321ygrp-text {font-family:Georgia;}#yiv7752572321 #yiv7752572321ygrp-text p {margin:0 0 1em 0;}#yiv7752572321 #yiv7752572321ygrp-text tt {font-size:120%;}#yiv7752572321 #yiv7752572321ygrp-vital ul li:last-child {border-right:none !important;}#yiv7752572321

Mon Jun 8, 2015 10:04 pm (PDT) . Posted by:

"Hendrik Karnadi" hendrikkarnadi

Coba ketik =Countif (range, criteria)
Jika reg setting Indonesien, ganti tanda , dengan ;

Salam,
HK

Sent from Samsung Mobile

<div>-------- Original message --------</div><div>From: "Syaiful Hanan ananinadam@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com> </div><div>Date:09/06/2015 11:47 AM (GMT+07:00) </div><div>To: belajar-excel@yahoogroups.com </div><div>Subject: [belajar-excel] penjumlahan nama [1 Attachment] </div><div>
</div>
السَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ
​bagaimana kita bisa mencari jumlah nama yang kita inginkan ?​

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


============================================================
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