mohon dibantu ya mas.,thx'
Pada Senin, 9 Februari 2015 17:37, "Paulus Taripar
[email protected] [belajar-excel]" <[email protected]>
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 [email protected]
[belajar-excel]" <[email protected]> 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 [email protected]
[belajar-excel] <[email protected]>:
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
