5 Messages

Digest #3294

Re: pakai rumus apa ya? help (mods : lookup tengok kiri) [1 Attachme by "Dede"

Re: Ambil Header dari data by "Dede"

Bls: [belajar-excel] Rumus untuk menyebutkan nama dalam excel by "Paulus Taripar" paulustaripar@rocketmail.com

Bls: [belajar-excel] Rumus untuk menyebutkan nama dalam excel [1 Att by "Paulus Taripar" paulustaripar@rocketmail.com

Remove duplikat sesuai tanggal by "Rudi Anto" rudi.excel

Messages

1a

Re: pakai rumus apa ya? help (mods : lookup tengok kiri) [1 Attachme

Mon Feb 9, 2015 2:36 am (PST) . Posted by:

"Dede"

Dear Mr Guntur,

Coba pakai formula ini :

=INDEX(FILE1!$1:$1048576;MATCH(A2;FILE1!$G:$G;0);2)

Salam,

DD

From: guntur.novriansyah@ymail.com [belajar-excel] [mailto:belajar-excel@yahoogroups.com]
Sent: 09 Februari 2015 14:58
To: belajar-excel@yahoogroups.com
Subject: [belajar-excel] pakai rumus apa ya? help (mods : lookup tengok kiri) [1 Attachment]

permisi gan saya mau sedikit bertanya tentang rumus yang pas untuk soal seperti ini...

_____

This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual to whom it is addressed. If you have received this email in error please send it back to the person that sent it to you. Any views or opinions presented are solely those of its author and do not necessarily represent those of NABATI or any of its subsidiary companies. Unauthorized publication, use, dissemination, forwarding, printing or copying of this email and its associated attachments is strictly prohibited.

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

2a

Re: Ambil Header dari data

Mon Feb 9, 2015 2:37 am (PST) . Posted by:

"Dede"

Hai Agus,

Kurang lebih terjemahannya seperti ini :

IF(ISNUMBER(B4);INDEX($B$3:$F$7;1;1)&";
";"")

è kalau cell B4 terisi angka, maka terisi cell B3 selain dari itu kosong

Jadi kalau cell itu terisi bukan oleh angka maka hasilnya kosong,

Begitu seterusnya.

Semoga dapat dipahami yah...

Salam,

DD

From: Agus Erwanto erwanto_agus@yahoo.co.id [belajar-excel] [mailto:belajar-excel@yahoogroups.com]
Sent: 06 Februari 2015 11:30
To: belajar-excel@yahoogroups.com
Subject: RE: [belajar-excel] Ambil Header dari data

Terimaksih banyak pak DEDE,
bisakah saya di beritahukan untuk logikanya dalam bentuk tulisan, supaya bisa menerangkan dengan baik.

terimakasih

--------------------------------------------
Pada Rab, 4/2/15, Dede pmaho_log4@nabatisnack.co.id [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

Judul: RE: [belajar-excel] Ambil Header dari data
Kepada: belajar-excel@yahoogroups.com
Tanggal: Rabu, 4 Februari, 2015, 12:10 PM

Hai Agus,

Coba formula ini di
cell H4 :

=IF(ISNUMBER(B4);INDEX($B$3:$F$7;1;1)&";
";"")&IF(ISNUMBER(C4);INDEX($B$3:$F$7;1;2)&";
";"")&IF(ISNUMBER(D4);INDEX($B$3:$F$7;1;3)&";
";"")&IF(ISNUMBER(E4);INDEX($B$3:$F$7;1;4)&";
";"")&IF(ISNUMBER(F4);INDEX($B$3:$F$7;1;5)&";
";"")

Semoga sesuai
harapan.

DD

From: Agus Erwanto
erwanto_agus@yahoo.co.id [belajar-excel]
[mailto:belajar-excel@yahoogroups.com]

Sent: 29 Januari 2015 12:31

To: belajar-excel@yahoogroups.com

Subject: [belajar-excel] Ambil Header dari data [1
Attachment]

Dear Team Excel,

selamat siang,

mohon bantuannya untuk kasus saya dibawah ini.

saya ingin mengandengkan header header yang ada datanya,
tidak masalah itu data
berisi anggak 1, 2, dll

jadi kalau ada data langsung diambil headernya.

utnuk keterangan lebih lanjut saya sertakan
attachmentnya.

regards,

terimakasih

agus erw

This e-mail and any files
transmitted with it are confidential and
intended solely for the use of the individual to whom it is
addressed. If you
have received this email in error please send it back to the
person that sent
it to you. Any views or opinions presented are solely those
of its author and
do not necessarily represent those of NABATI or any of its
subsidiary
companies. Unauthorized publication, use, dissemination,
forwarding, printing
or copying of this email and its associated attachments is
strictly prohibited.

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

#yiv2677261378 #yiv2677261378ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv2677261378 #yiv2677261378ygrp-mkp #yiv2677261378hd {

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

#yiv2677261378 #yiv2677261378ygrp-mkp #yiv2677261378ads {
margin-bottom:10px;}

#yiv2677261378 #yiv2677261378ygrp-mkp .yiv2677261378ad {
padding:0 0;}

#yiv2677261378 #yiv2677261378ygrp-mkp .yiv2677261378ad p {
margin:0;}

#yiv2677261378 #yiv2677261378ygrp-mkp .yiv2677261378ad a {
color:#0000ff;text-decoration:none;}
#yiv2677261378 #yiv2677261378ygrp-sponsor
#yiv2677261378ygrp-lc {
font-family:Arial;}

#yiv2677261378 #yiv2677261378ygrp-sponsor
#yiv2677261378ygrp-lc #yiv2677261378hd {
margin:10px

0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv2677261378 #yiv2677261378ygrp-sponsor
#yiv2677261378ygrp-lc .yiv2677261378ad {
margin-bottom:10px;padding:0 0;}

#yiv2677261378 #yiv2677261378actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

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

#yiv2677261378 #yiv2677261378activity span {
font-weight:700;}

#yiv2677261378 #yiv2677261378activity span:first-child {
text-transform:uppercase;}

#yiv2677261378 #yiv2677261378activity span a {
color:#5085b6;text-decoration:none;}

#yiv2677261378 #yiv2677261378activity span span {
color:#ff7900;}

#yiv2677261378 #yiv2677261378activity span
.yiv2677261378underline {
text-decoration:underline;}

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

#yiv2677261378 .yiv2677261378attach div a {
text-decoration:none;}

#yiv2677261378 .yiv2677261378attach img {
border:none;padding-right:5px;}

#yiv2677261378 .yiv2677261378attach label {
display:block;margin-bottom:5px;}

#yiv2677261378 .yiv2677261378attach label a {
text-decoration:none;}

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

#yiv2677261378 .yiv2677261378bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv2677261378 .yiv2677261378bold a {
text-decoration:none;}

#yiv2677261378 dd.yiv2677261378last p a {
font-family:Verdana;font-weight:700;}

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

#yiv2677261378 dd.yiv2677261378last p
span.yiv2677261378yshortcuts {
margin-right:0;}

#yiv2677261378 div.yiv2677261378attach-table div div a {
text-decoration:none;}

#yiv2677261378 div.yiv2677261378attach-table {
width:400px;}

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

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

#yiv2677261378 div#yiv2677261378ygrp-mlmsg
#yiv2677261378ygrp-msg p a span.yiv2677261378yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv2677261378 .yiv2677261378green {
color:#628c2a;}

#yiv2677261378 .yiv2677261378MsoNormal {
margin:0 0 0 0;}

#yiv2677261378 o {
font-size:0;}

#yiv2677261378 #yiv2677261378photos div {
float:left;width:72px;}

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

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

#yiv2677261378 #yiv2677261378reco-category {
font-size:77%;}

#yiv2677261378 #yiv2677261378reco-desc {
font-size:77%;}

#yiv2677261378 .yiv2677261378replbq {
margin:4px;}

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

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

#yiv2677261378 #yiv2677261378ygrp-mlmsg table {
font-size:inherit;font:100%;}

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

#yiv2677261378 #yiv2677261378ygrp-mlmsg pre, #yiv2677261378
code {
font:115% monospace;}

#yiv2677261378 #yiv2677261378ygrp-mlmsg * {
line-height:1.22em;}

#yiv2677261378 #yiv2677261378ygrp-mlmsg #yiv2677261378logo {
padding-bottom:10px;}

#yiv2677261378 #yiv2677261378ygrp-msg p a {
font-family:Verdana;}

#yiv2677261378 #yiv2677261378ygrp-msg
p#yiv2677261378attach-count span {
color:#1E66AE;font-weight:700;}

#yiv2677261378 #yiv2677261378ygrp-reco
#yiv2677261378reco-head {
color:#ff7900;font-weight:700;}

#yiv2677261378 #yiv2677261378ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv2677261378 #yiv2677261378ygrp-sponsor #yiv2677261378ov
li a {
font-size:130%;text-decoration:none;}

#yiv2677261378 #yiv2677261378ygrp-sponsor #yiv2677261378ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv2677261378 #yiv2677261378ygrp-sponsor #yiv2677261378ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv2677261378 #yiv2677261378ygrp-text {
font-family:Georgia;}

#yiv2677261378 #yiv2677261378ygrp-text p {
margin:0 0 1em 0;}

#yiv2677261378 #yiv2677261378ygrp-text tt {
font-size:120%;}

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

_____

This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual to whom it is addressed. If you have received this email in error please send it back to the person that sent it to you. Any views or opinions presented are solely those of its author and do not necessarily represent those of NABATI or any of its subsidiary companies. Unauthorized publication, use, dissemination, forwarding, printing or copying of this email and its associated attachments is strictly prohibited.

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

3a

Bls: [belajar-excel] Rumus untuk menyebutkan nama dalam excel

Mon Feb 9, 2015 2:37 am (PST) . Posted by:

"Paulus Taripar" paulustaripar@rocketmail.com

oke mas.,thanks'
masalahnya data2nya terlalu banyak, jadi bingung bikin sampelnya. :p tapi udah saya buatkan yg simple [file terlampir]. nanti kalo masih kurang lengkap,saya tambahin lagi mas. hehehhehee... tadinya saya udah coba pake =INDEX tapi yang muncul hnya satu nama saja. padahal disitu tertera namanya lebih dari satu. hehehehhehe... thx ya mas

Pada Senin, 9 Februari 2015 16:36, "Nang Agus nangagus@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:

Dear Paulus,

Salam sejahtera

sebaiknya membuatkan sekedar contoh untuk member dalam bentuk file excel, sehingga pertanyaan akan mudah dipahami. lebih bagus lagi jika diberi hasil secara manual sehingga semua anggota member tahu yang dimaksud.
seperti saya ini yang agak kurang paham dapat mengerti.
mohon maaf jika kata-kata saya menyinggung anda.
salam

2015-02-09 15:53 GMT+07:00 Paulus Taripar paulustaripar@rocketmail.com [belajar-excel] <belajar-excel@yahoogroups.com>:

Selamat siang be excel, tnya mengenai excel untuk menyebutkan nama yang ada di data. Misal, mencari nama Biru dengan kriteria tertentu. Nah, untuk mencari siapa saja yang mendapat nama "Biru" ada rumus excel yang dipake gak? Trims

#yiv1307342309 #yiv1307342309 -- #yiv1307342309ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1307342309 #yiv1307342309ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1307342309 #yiv1307342309ygrp-mkp #yiv1307342309hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv1307342309 #yiv1307342309ygrp-mkp #yiv1307342309ads {margin-bottom:10px;}#yiv1307342309 #yiv1307342309ygrp-mkp .yiv1307342309ad {padding:0 0;}#yiv1307342309 #yiv1307342309ygrp-mkp .yiv1307342309ad p {margin:0;}#yiv1307342309 #yiv1307342309ygrp-mkp .yiv1307342309ad a {color:#0000ff;text-decoration:none;}#yiv1307342309 #yiv1307342309ygrp-sponsor #yiv1307342309ygrp-lc {font-family:Arial;}#yiv1307342309 #yiv1307342309ygrp-sponsor #yiv1307342309ygrp-lc #yiv1307342309hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1307342309 #yiv1307342309ygrp-sponsor #yiv1307342309ygrp-lc .yiv1307342309ad {margin-bottom:10px;padding:0 0;}#yiv1307342309 #yiv1307342309actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1307342309 #yiv1307342309activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1307342309 #yiv1307342309activity span {font-weight:700;}#yiv1307342309 #yiv1307342309activity span:first-child {text-transform:uppercase;}#yiv1307342309 #yiv1307342309activity span a {color:#5085b6;text-decoration:none;}#yiv1307342309 #yiv1307342309activity span span {color:#ff7900;}#yiv1307342309 #yiv1307342309activity span .yiv1307342309underline {text-decoration:underline;}#yiv1307342309 .yiv1307342309attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv1307342309 .yiv1307342309attach div a {text-decoration:none;}#yiv1307342309 .yiv1307342309attach img {border:none;padding-right:5px;}#yiv1307342309 .yiv1307342309attach label {display:block;margin-bottom:5px;}#yiv1307342309 .yiv1307342309attach label a {text-decoration:none;}#yiv1307342309 blockquote {margin:0 0 0 4px;}#yiv1307342309 .yiv1307342309bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv1307342309 .yiv1307342309bold a {text-decoration:none;}#yiv1307342309 dd.yiv1307342309last p a {font-family:Verdana;font-weight:700;}#yiv1307342309 dd.yiv1307342309last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1307342309 dd.yiv1307342309last p span.yiv1307342309yshortcuts {margin-right:0;}#yiv1307342309 div.yiv1307342309attach-table div div a {text-decoration:none;}#yiv1307342309 div.yiv1307342309attach-table {width:400px;}#yiv1307342309 div.yiv1307342309file-title a, #yiv1307342309 div.yiv1307342309file-title a:active, #yiv1307342309 div.yiv1307342309file-title a:hover, #yiv1307342309 div.yiv1307342309file-title a:visited {text-decoration:none;}#yiv1307342309 div.yiv1307342309photo-title a, #yiv1307342309 div.yiv1307342309photo-title a:active, #yiv1307342309 div.yiv1307342309photo-title a:hover, #yiv1307342309 div.yiv1307342309photo-title a:visited {text-decoration:none;}#yiv1307342309 div#yiv1307342309ygrp-mlmsg #yiv1307342309ygrp-msg p a span.yiv1307342309yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1307342309 .yiv1307342309green {color:#628c2a;}#yiv1307342309 .yiv1307342309MsoNormal {margin:0 0 0 0;}#yiv1307342309 o {font-size:0;}#yiv1307342309 #yiv1307342309photos div {float:left;width:72px;}#yiv1307342309 #yiv1307342309photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv1307342309 #yiv1307342309photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1307342309 #yiv1307342309reco-category {font-size:77%;}#yiv1307342309 #yiv1307342309reco-desc {font-size:77%;}#yiv1307342309 .yiv1307342309replbq {margin:4px;}#yiv1307342309 #yiv1307342309ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv1307342309 #yiv1307342309ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1307342309 #yiv1307342309ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1307342309 #yiv1307342309ygrp-mlmsg select, #yiv1307342309 input, #yiv1307342309 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv1307342309 #yiv1307342309ygrp-mlmsg pre, #yiv1307342309 code {font:115% monospace;}#yiv1307342309 #yiv1307342309ygrp-mlmsg * {line-height:1.22em;}#yiv1307342309 #yiv1307342309ygrp-mlmsg #yiv1307342309logo {padding-bottom:10px;}#yiv1307342309 #yiv1307342309ygrp-msg p a {font-family:Verdana;}#yiv1307342309 #yiv1307342309ygrp-msg p#yiv1307342309attach-count span {color:#1E66AE;font-weight:700;}#yiv1307342309 #yiv1307342309ygrp-reco #yiv1307342309reco-head {color:#ff7900;font-weight:700;}#yiv1307342309 #yiv1307342309ygrp-reco {margin-bottom:20px;padding:0px;}#yiv1307342309 #yiv1307342309ygrp-sponsor #yiv1307342309ov li a {font-size:130%;text-decoration:none;}#yiv1307342309 #yiv1307342309ygrp-sponsor #yiv1307342309ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv1307342309 #yiv1307342309ygrp-sponsor #yiv1307342309ov ul {margin:0;padding:0 0 0 8px;}#yiv1307342309 #yiv1307342309ygrp-text {font-family:Georgia;}#yiv1307342309 #yiv1307342309ygrp-text p {margin:0 0 1em 0;}#yiv1307342309 #yiv1307342309ygrp-text tt {font-size:120%;}#yiv1307342309 #yiv1307342309ygrp-vital ul li:last-child {border-right:none !important;}#yiv1307342309

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

3b

Bls: [belajar-excel] Rumus untuk menyebutkan nama dalam excel [1 Att

Mon Feb 9, 2015 3:44 am (PST) . Posted by:

"Paulus Taripar" paulustaripar@rocketmail.com

mohon dibantu ya mas.,thx'

Pada Senin, 9 Februari 2015 17:37, "Paulus Taripar paulustaripar@rocketmail.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:

oke mas.,thanks'
masalahnya data2nya terlalu banyak, jadi bingung bikin sampelnya. :p tapi udah saya buatkan yg simple [file terlampir]. nanti kalo masih kurang lengkap,saya tambahin lagi mas. hehehhehee... tadinya saya udah coba pake =INDEX tapi yang muncul hnya satu nama saja. padahal disitu tertera namanya lebih dari satu. hehehehhehe... thx ya mas

Pada Senin, 9 Februari 2015 16:36, "Nang Agus nangagus@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:

Dear Paulus,

Salam sejahtera

sebaiknya membuatkan sekedar contoh untuk member dalam bentuk file excel, sehingga pertanyaan akan mudah dipahami. lebih bagus lagi jika diberi hasil secara manual sehingga semua anggota member tahu yang dimaksud.
seperti saya ini yang agak kurang paham dapat mengerti.
mohon maaf jika kata-kata saya menyinggung anda.
salam

2015-02-09 15:53 GMT+07:00 Paulus Taripar paulustaripar@rocketmail.com [belajar-excel] <belajar-excel@yahoogroups.com>:

Selamat siang be excel, tnya mengenai excel untuk menyebutkan nama yang ada di data. Misal, mencari nama Biru dengan kriteria tertentu. Nah, untuk mencari siapa saja yang mendapat nama "Biru" ada rumus excel yang dipake gak? Trims

#yiv5006578300 #yiv5006578300 -- #yiv5006578300ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5006578300 #yiv5006578300ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5006578300 #yiv5006578300ygrp-mkp #yiv5006578300hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5006578300 #yiv5006578300ygrp-mkp #yiv5006578300ads {margin-bottom:10px;}#yiv5006578300 #yiv5006578300ygrp-mkp .yiv5006578300ad {padding:0 0;}#yiv5006578300 #yiv5006578300ygrp-mkp .yiv5006578300ad p {margin:0;}#yiv5006578300 #yiv5006578300ygrp-mkp .yiv5006578300ad a {color:#0000ff;text-decoration:none;}#yiv5006578300 #yiv5006578300ygrp-sponsor #yiv5006578300ygrp-lc {font-family:Arial;}#yiv5006578300 #yiv5006578300ygrp-sponsor #yiv5006578300ygrp-lc #yiv5006578300hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5006578300 #yiv5006578300ygrp-sponsor #yiv5006578300ygrp-lc .yiv5006578300ad {margin-bottom:10px;padding:0 0;}#yiv5006578300 #yiv5006578300actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5006578300 #yiv5006578300activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5006578300 #yiv5006578300activity span {font-weight:700;}#yiv5006578300 #yiv5006578300activity span:first-child {text-transform:uppercase;}#yiv5006578300 #yiv5006578300activity span a {color:#5085b6;text-decoration:none;}#yiv5006578300 #yiv5006578300activity span span {color:#ff7900;}#yiv5006578300 #yiv5006578300activity span .yiv5006578300underline {text-decoration:underline;}#yiv5006578300 .yiv5006578300attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv5006578300 .yiv5006578300attach div a {text-decoration:none;}#yiv5006578300 .yiv5006578300attach img {border:none;padding-right:5px;}#yiv5006578300 .yiv5006578300attach label {display:block;margin-bottom:5px;}#yiv5006578300 .yiv5006578300attach label a {text-decoration:none;}#yiv5006578300 blockquote {margin:0 0 0 4px;}#yiv5006578300 .yiv5006578300bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv5006578300 .yiv5006578300bold a {text-decoration:none;}#yiv5006578300 dd.yiv5006578300last p a {font-family:Verdana;font-weight:700;}#yiv5006578300 dd.yiv5006578300last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5006578300 dd.yiv5006578300last p span.yiv5006578300yshortcuts {margin-right:0;}#yiv5006578300 div.yiv5006578300attach-table div div a {text-decoration:none;}#yiv5006578300 div.yiv5006578300attach-table {width:400px;}#yiv5006578300 div.yiv5006578300file-title a, #yiv5006578300 div.yiv5006578300file-title a:active, #yiv5006578300 div.yiv5006578300file-title a:hover, #yiv5006578300 div.yiv5006578300file-title a:visited {text-decoration:none;}#yiv5006578300 div.yiv5006578300photo-title a, #yiv5006578300 div.yiv5006578300photo-title a:active, #yiv5006578300 div.yiv5006578300photo-title a:hover, #yiv5006578300 div.yiv5006578300photo-title a:visited {text-decoration:none;}#yiv5006578300 div#yiv5006578300ygrp-mlmsg #yiv5006578300ygrp-msg p a span.yiv5006578300yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5006578300 .yiv5006578300green {color:#628c2a;}#yiv5006578300 .yiv5006578300MsoNormal {margin:0 0 0 0;}#yiv5006578300 o {font-size:0;}#yiv5006578300 #yiv5006578300photos div {float:left;width:72px;}#yiv5006578300 #yiv5006578300photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv5006578300 #yiv5006578300photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5006578300 #yiv5006578300reco-category {font-size:77%;}#yiv5006578300 #yiv5006578300reco-desc {font-size:77%;}#yiv5006578300 .yiv5006578300replbq {margin:4px;}#yiv5006578300 #yiv5006578300ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv5006578300 #yiv5006578300ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5006578300 #yiv5006578300ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5006578300 #yiv5006578300ygrp-mlmsg select, #yiv5006578300 input, #yiv5006578300 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv5006578300 #yiv5006578300ygrp-mlmsg pre, #yiv5006578300 code {font:115% monospace;}#yiv5006578300 #yiv5006578300ygrp-mlmsg * {line-height:1.22em;}#yiv5006578300 #yiv5006578300ygrp-mlmsg #yiv5006578300logo {padding-bottom:10px;}#yiv5006578300 #yiv5006578300ygrp-msg p a {font-family:Verdana;}#yiv5006578300 #yiv5006578300ygrp-msg p#yiv5006578300attach-count span {color:#1E66AE;font-weight:700;}#yiv5006578300 #yiv5006578300ygrp-reco #yiv5006578300reco-head {color:#ff7900;font-weight:700;}#yiv5006578300 #yiv5006578300ygrp-reco {margin-bottom:20px;padding:0px;}#yiv5006578300 #yiv5006578300ygrp-sponsor #yiv5006578300ov li a {font-size:130%;text-decoration:none;}#yiv5006578300 #yiv5006578300ygrp-sponsor #yiv5006578300ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv5006578300 #yiv5006578300ygrp-sponsor #yiv5006578300ov ul {margin:0;padding:0 0 0 8px;}#yiv5006578300 #yiv5006578300ygrp-text {font-family:Georgia;}#yiv5006578300 #yiv5006578300ygrp-text p {margin:0 0 1em 0;}#yiv5006578300 #yiv5006578300ygrp-text tt {font-size:120%;}#yiv5006578300 #yiv5006578300ygrp-vital ul li:last-child {border-right:none !important;}#yiv5006578300

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

4 Remove duplikat sesuai tanggal

Mon Feb 9, 2015 3:41 am (PST) . Posted by:

"Rudi Anto" rudi.excel

Dear suhu belajar Excel,

Wah dah lama ga nanya nih, cuman ngikuti di nabble.belajarexcel,
hari ini saya punya sedikit kesulitan mengenai kasus report yang ingin saya tampilkan
datanya, dimana data tidak boleh ganda/duplikat ketika saya tampilkan sesuai tanggal.
mungkin contoh attachment bisa sedikit memberikan permasalahan yang saya hadapi.
Sebelumnya saya ucapkan banyak terima kasih,karena milis ini sangat membantu pekerjaan saya.

Salam,
Rudi Anto

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 17

• Privacy • Unsubscribe • Terms of Use

EXCEL FEED

Senin, 09 Februari 2015

[belajar-excel] Digest Number 3294

5 Messages

Messages

1a

Re: pakai rumus apa ya? help (mods : lookup tengok kiri) [1 Attachme

Mon Feb 9, 2015 2:36 am (PST) . Posted by:

"Dede"

2a

Re: Ambil Header dari data

Mon Feb 9, 2015 2:37 am (PST) . Posted by:

"Dede"

3a

Bls: [belajar-excel] Rumus untuk menyebutkan nama dalam excel

Mon Feb 9, 2015 2:37 am (PST) . Posted by:

"Paulus Taripar" paulustaripar@rocketmail.com

3b

Bls: [belajar-excel] Rumus untuk menyebutkan nama dalam excel [1 Att

Mon Feb 9, 2015 3:44 am (PST) . Posted by:

"Paulus Taripar" paulustaripar@rocketmail.com

4

Remove duplikat sesuai tanggal

Mon Feb 9, 2015 3:41 am (PST) . Posted by:

"Rudi Anto" rudi.excel

Tidak ada komentar:

Posting Komentar

Followers

Blog Archive

About Me