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
#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
zodiak-1.xls
Description: MS-Excel spreadsheet
