[belajar-excel] Digest Number 3972

Milis Belajar Microsoft Excel Group

5 Messages

Digest #3972

1a

mohon dibantu solusi excel by "indria pie" mas_pie3

1b

Bls: [belajar-excel] mohon dibantu solusi excel [1 Attachment] by "odong nando"

1c

Bls: [belajar-excel] mohon dibantu solusi excel by "indria pie" mas_pie3

2a

Re: KOPDAR III by idz.iman

3

Cell Style (sampah) by idz.iman

Messages

1a

mohon dibantu solusi excel

Wed Sep 21, 2016 2:11 am (PDT) . Posted by:

"indria pie" mas_pie3

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

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

1b

Bls: [belajar-excel] mohon dibantu solusi excel [1 Attachment]

Wed Sep 21, 2016 3:20 am (PDT) . Posted by:

"odong nando"

pake rumus sumif ja...
=SUMIF($B$3:$B$19;I5;C3:C19)
 br,

odong nando

Dari: "indria pie mas_pie3@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com>
Kepada: "belajar-excel@yahoogroups.com" <belajar-excel@yahoogroups.com>
Dikirim: Rabu, 21 September 2016 16:05
Judul: [belajar-excel] mohon dibantu solusi excel [1 Attachment]

  Yth. Bapak-Ibu member belajar excel group
dh,mohon bantuan solusi untuk masalah kami, sesuai attach email berikut
demikian dan terima kasih
salam,kang pi #yiv9387488355 #yiv9387488355 -- #yiv9387488355ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9387488355 #yiv9387488355ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9387488355 #yiv9387488355ygrp-mkp #yiv9387488355hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv9387488355 #yiv9387488355ygrp-mkp #yiv9387488355ads {margin-bottom:10px;}#yiv9387488355 #yiv9387488355ygrp-mkp .yiv9387488355ad {padding:0 0;}#yiv9387488355 #yiv9387488355ygrp-mkp .yiv9387488355ad p {margin:0;}#yiv9387488355 #yiv9387488355ygrp-mkp .yiv9387488355ad a {color:#0000ff;text-decoration:none;}#yiv9387488355 #yiv9387488355ygrp-sponsor #yiv9387488355ygrp-lc {font-family:Arial;}#yiv9387488355 #yiv9387488355ygrp-sponsor #yiv9387488355ygrp-lc #yiv9387488355hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9387488355 #yiv9387488355ygrp-sponsor #yiv9387488355ygrp-lc .yiv9387488355ad {margin-bottom:10px;padding:0 0;}#yiv9387488355 #yiv9387488355actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9387488355 #yiv9387488355activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9387488355 #yiv9387488355activity span {font-weight:700;}#yiv9387488355 #yiv9387488355activity span:first-child {text-transform:uppercase;}#yiv9387488355 #yiv9387488355activity span a {color:#5085b6;text-decoration:none;}#yiv9387488355 #yiv9387488355activity span span {color:#ff7900;}#yiv9387488355 #yiv9387488355activity span .yiv9387488355underline {text-decoration:underline;}#yiv9387488355 .yiv9387488355attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv9387488355 .yiv9387488355attach div a {text-decoration:none;}#yiv9387488355 .yiv9387488355attach img {border:none;padding-right:5px;}#yiv9387488355 .yiv9387488355attach label {display:block;margin-bottom:5px;}#yiv9387488355 .yiv9387488355attach label a {text-decoration:none;}#yiv9387488355 blockquote {margin:0 0 0 4px;}#yiv9387488355 .yiv9387488355bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv9387488355 .yiv9387488355bold a {text-decoration:none;}#yiv9387488355 dd.yiv9387488355last p a {font-family:Verdana;font-weight:700;}#yiv9387488355 dd.yiv9387488355last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9387488355 dd.yiv9387488355last p span.yiv9387488355yshortcuts {margin-right:0;}#yiv9387488355 div.yiv9387488355attach-table div div a {text-decoration:none;}#yiv9387488355 div.yiv9387488355attach-table {width:400px;}#yiv9387488355 div.yiv9387488355file-title a, #yiv9387488355 div.yiv9387488355file-title a:active, #yiv9387488355 div.yiv9387488355file-title a:hover, #yiv9387488355 div.yiv9387488355file-title a:visited {text-decoration:none;}#yiv9387488355 div.yiv9387488355photo-title a, #yiv9387488355 div.yiv9387488355photo-title a:active, #yiv9387488355 div.yiv9387488355photo-title a:hover, #yiv9387488355 div.yiv9387488355photo-title a:visited {text-decoration:none;}#yiv9387488355 div#yiv9387488355ygrp-mlmsg #yiv9387488355ygrp-msg p a span.yiv9387488355yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9387488355 .yiv9387488355green {color:#628c2a;}#yiv9387488355 .yiv9387488355MsoNormal {margin:0 0 0 0;}#yiv9387488355 o {font-size:0;}#yiv9387488355 #yiv9387488355photos div {float:left;width:72px;}#yiv9387488355 #yiv9387488355photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv9387488355 #yiv9387488355photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9387488355 #yiv9387488355reco-category {font-size:77%;}#yiv9387488355 #yiv9387488355reco-desc {font-size:77%;}#yiv9387488355 .yiv9387488355replbq {margin:4px;}#yiv9387488355 #yiv9387488355ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv9387488355 #yiv9387488355ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9387488355 #yiv9387488355ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9387488355 #yiv9387488355ygrp-mlmsg select, #yiv9387488355 input, #yiv9387488355 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv9387488355 #yiv9387488355ygrp-mlmsg pre, #yiv9387488355 code {font:115% monospace;}#yiv9387488355 #yiv9387488355ygrp-mlmsg * {line-height:1.22em;}#yiv9387488355 #yiv9387488355ygrp-mlmsg #yiv9387488355logo {padding-bottom:10px;}#yiv9387488355 #yiv9387488355ygrp-msg p a {font-family:Verdana;}#yiv9387488355 #yiv9387488355ygrp-msg p#yiv9387488355attach-count span {color:#1E66AE;font-weight:700;}#yiv9387488355 #yiv9387488355ygrp-reco #yiv9387488355reco-head {color:#ff7900;font-weight:700;}#yiv9387488355 #yiv9387488355ygrp-reco {margin-bottom:20px;padding:0px;}#yiv9387488355 #yiv9387488355ygrp-sponsor #yiv9387488355ov li a {font-size:130%;text-decoration:none;}#yiv9387488355 #yiv9387488355ygrp-sponsor #yiv9387488355ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv9387488355 #yiv9387488355ygrp-sponsor #yiv9387488355ov ul {margin:0;padding:0 0 0 8px;}#yiv9387488355 #yiv9387488355ygrp-text {font-family:Georgia;}#yiv9387488355 #yiv9387488355ygrp-text p {margin:0 0 1em 0;}#yiv9387488355 #yiv9387488355ygrp-text tt {font-size:120%;}#yiv9387488355 #yiv9387488355ygrp-vital ul li:last-child {border-right:none !important;}#yiv9387488355

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

1c

Bls: [belajar-excel] mohon dibantu solusi excel

Wed Sep 21, 2016 9:20 am (PDT) . Posted by:

"indria pie" mas_pie3

dear bang odong nando,
terima kasih bantuannya
salam,kang pi

Pada Rabu, 21 September 2016 17:20, "odong nando odongnando@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  pake rumus sumif ja...
=SUMIF($B$3:$B$19;I5;C3:C19)
 br,

odong nando

Dari: "indria pie mas_pie3@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com>
Kepada: "belajar-excel@yahoogroups.com" <belajar-excel@yahoogroups.com>
Dikirim: Rabu, 21 September 2016 16:05
Judul: [belajar-excel] mohon dibantu solusi excel [1 Attachment]

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

#yiv9608683920 #yiv9608683920 -- #yiv9608683920ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9608683920 #yiv9608683920ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9608683920 #yiv9608683920ygrp-mkp #yiv9608683920hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv9608683920 #yiv9608683920ygrp-mkp #yiv9608683920ads {margin-bottom:10px;}#yiv9608683920 #yiv9608683920ygrp-mkp .yiv9608683920ad {padding:0 0;}#yiv9608683920 #yiv9608683920ygrp-mkp .yiv9608683920ad p {margin:0;}#yiv9608683920 #yiv9608683920ygrp-mkp .yiv9608683920ad a {color:#0000ff;text-decoration:none;}#yiv9608683920 #yiv9608683920ygrp-sponsor #yiv9608683920ygrp-lc {font-family:Arial;}#yiv9608683920 #yiv9608683920ygrp-sponsor #yiv9608683920ygrp-lc #yiv9608683920hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9608683920 #yiv9608683920ygrp-sponsor #yiv9608683920ygrp-lc .yiv9608683920ad {margin-bottom:10px;padding:0 0;}#yiv9608683920 #yiv9608683920actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9608683920 #yiv9608683920activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9608683920 #yiv9608683920activity span {font-weight:700;}#yiv9608683920 #yiv9608683920activity span:first-child {text-transform:uppercase;}#yiv9608683920 #yiv9608683920activity span a {color:#5085b6;text-decoration:none;}#yiv9608683920 #yiv9608683920activity span span {color:#ff7900;}#yiv9608683920 #yiv9608683920activity span .yiv9608683920underline {text-decoration:underline;}#yiv9608683920 .yiv9608683920attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv9608683920 .yiv9608683920attach div a {text-decoration:none;}#yiv9608683920 .yiv9608683920attach img {border:none;padding-right:5px;}#yiv9608683920 .yiv9608683920attach label {display:block;margin-bottom:5px;}#yiv9608683920 .yiv9608683920attach label a {text-decoration:none;}#yiv9608683920 blockquote {margin:0 0 0 4px;}#yiv9608683920 .yiv9608683920bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv9608683920 .yiv9608683920bold a {text-decoration:none;}#yiv9608683920 dd.yiv9608683920last p a {font-family:Verdana;font-weight:700;}#yiv9608683920 dd.yiv9608683920last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9608683920 dd.yiv9608683920last p span.yiv9608683920yshortcuts {margin-right:0;}#yiv9608683920 div.yiv9608683920attach-table div div a {text-decoration:none;}#yiv9608683920 div.yiv9608683920attach-table {width:400px;}#yiv9608683920 div.yiv9608683920file-title a, #yiv9608683920 div.yiv9608683920file-title a:active, #yiv9608683920 div.yiv9608683920file-title a:hover, #yiv9608683920 div.yiv9608683920file-title a:visited {text-decoration:none;}#yiv9608683920 div.yiv9608683920photo-title a, #yiv9608683920 div.yiv9608683920photo-title a:active, #yiv9608683920 div.yiv9608683920photo-title a:hover, #yiv9608683920 div.yiv9608683920photo-title a:visited {text-decoration:none;}#yiv9608683920 div#yiv9608683920ygrp-mlmsg #yiv9608683920ygrp-msg p a span.yiv9608683920yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9608683920 .yiv9608683920green {color:#628c2a;}#yiv9608683920 .yiv9608683920MsoNormal {margin:0 0 0 0;}#yiv9608683920 o {font-size:0;}#yiv9608683920 #yiv9608683920photos div {float:left;width:72px;}#yiv9608683920 #yiv9608683920photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv9608683920 #yiv9608683920photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9608683920 #yiv9608683920reco-category {font-size:77%;}#yiv9608683920 #yiv9608683920reco-desc {font-size:77%;}#yiv9608683920 .yiv9608683920replbq {margin:4px;}#yiv9608683920 #yiv9608683920ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv9608683920 #yiv9608683920ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9608683920 #yiv9608683920ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9608683920 #yiv9608683920ygrp-mlmsg select, #yiv9608683920 input, #yiv9608683920 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv9608683920 #yiv9608683920ygrp-mlmsg pre, #yiv9608683920 code {font:115% monospace;}#yiv9608683920 #yiv9608683920ygrp-mlmsg * {line-height:1.22em;}#yiv9608683920 #yiv9608683920ygrp-mlmsg #yiv9608683920logo {padding-bottom:10px;}#yiv9608683920 #yiv9608683920ygrp-msg p a {font-family:Verdana;}#yiv9608683920 #yiv9608683920ygrp-msg p#yiv9608683920attach-count span {color:#1E66AE;font-weight:700;}#yiv9608683920 #yiv9608683920ygrp-reco #yiv9608683920reco-head {color:#ff7900;font-weight:700;}#yiv9608683920 #yiv9608683920ygrp-reco {margin-bottom:20px;padding:0px;}#yiv9608683920 #yiv9608683920ygrp-sponsor #yiv9608683920ov li a {font-size:130%;text-decoration:none;}#yiv9608683920 #yiv9608683920ygrp-sponsor #yiv9608683920ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv9608683920 #yiv9608683920ygrp-sponsor #yiv9608683920ov ul {margin:0;padding:0 0 0 8px;}#yiv9608683920 #yiv9608683920ygrp-text {font-family:Georgia;}#yiv9608683920 #yiv9608683920ygrp-text p {margin:0 0 1em 0;}#yiv9608683920 #yiv9608683920ygrp-text tt {font-size:120%;}#yiv9608683920 #yiv9608683920ygrp-vital ul li:last-child {border-right:none !important;}#yiv9608683920

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

2a

Re: KOPDAR III

Wed Sep 21, 2016 6:21 pm (PDT) . Posted by:

idz.iman

wah ide Menarik nih...

ikut nyimak yaaa

salam
Iman

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

3

Cell Style (sampah)

Wed Sep 21, 2016 6:37 pm (PDT) . Posted by:

idz.iman

Assalammualaikum wr.wb.

Semangat PAGI!!

Halo para master, saya mau nanya nih siapa tahu ada yang bisa bantu.

saya ada file excel given dari orang2 sebelum saya (hehe), nah disini banyak sekali "sampahnya&quot;.
salah satunya Cell Style nih seperti gambar terlampir bagaimana cara "me-Normalkan-nya" ya?

salam
Iman DZ

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

============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com
posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com
berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com
keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------

Visit Your Group

• New Members 4

• Privacy • Unsubscribe • Terms of Use