Terima kasih solusinya bang Mr. Kid bisa memberi pencerahan
Tapi maaf jika data anggotanya lumayan banyak, menggunakan List Box kayaknya
cukup merepotkan juga ya.Kalau dengan cara input Nama & Kelompokkemudian
mencari Nama & Kelompok dengan cara ( rumus ) yg lain ada gak ya ?
Terima kasih
Kusnadi
Pada Rabu, 10 Januari 2018 18:59, "'Mr. Kid' mr.nm...@gmail.com
[belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Hai Kusnadi,
File terlampir sekadar usaha untuk menggunakan formula yang sederhana saja.
Hanya IFError dan Index, tanpa ada yang lainnya (tak ada Match, vLookUp,
Offset, Indirect atau apalah)
Regards,
Kid
2018-01-10 17:20 GMT+07:00 Kusnadi Bin zain kbinz...@yahoo.co.id
[belajar-excel] <belajar-excel@yahoogroups.com>:
yth pakar2 Excell
bagaimana caranya mencari, ada dibaris keberapakah data Nama & data Kelompok
yang sesuaidengan 2 kriteria ini ( Nama & Kelompok ) ... lihat lampiran saja deh
terimakasih bantuannya
wassalam
kusnadi
#yiv1756348189 #yiv1756348189 -- #yiv1756348189ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1756348189
#yiv1756348189ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1756348189
#yiv1756348189ygrp-mkp #yiv1756348189hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv1756348189 #yiv1756348189ygrp-mkp #yiv1756348189ads
{margin-bottom:10px;}#yiv1756348189 #yiv1756348189ygrp-mkp .yiv1756348189ad
{padding:0 0;}#yiv1756348189 #yiv1756348189ygrp-mkp .yiv1756348189ad p
{margin:0;}#yiv1756348189 #yiv1756348189ygrp-mkp .yiv1756348189ad a
{color:#0000ff;text-decoration:none;}#yiv1756348189 #yiv1756348189ygrp-sponsor
#yiv1756348189ygrp-lc {font-family:Arial;}#yiv1756348189
#yiv1756348189ygrp-sponsor #yiv1756348189ygrp-lc #yiv1756348189hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1756348189
#yiv1756348189ygrp-sponsor #yiv1756348189ygrp-lc .yiv1756348189ad
{margin-bottom:10px;padding:0 0;}#yiv1756348189 #yiv1756348189actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1756348189
#yiv1756348189activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1756348189
#yiv1756348189activity span {font-weight:700;}#yiv1756348189
#yiv1756348189activity span:first-child
{text-transform:uppercase;}#yiv1756348189 #yiv1756348189activity span a
{color:#5085b6;text-decoration:none;}#yiv1756348189 #yiv1756348189activity span
span {color:#ff7900;}#yiv1756348189 #yiv1756348189activity span
.yiv1756348189underline {text-decoration:underline;}#yiv1756348189
.yiv1756348189attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv1756348189 .yiv1756348189attach div a
{text-decoration:none;}#yiv1756348189 .yiv1756348189attach img
{border:none;padding-right:5px;}#yiv1756348189 ...yiv1756348189attach label
{display:block;margin-bottom:5px;}#yiv1756348189 .yiv1756348189attach label a
{text-decoration:none;}#yiv1756348189 blockquote {margin:0 0 0
4px;}#yiv1756348189 .yiv1756348189bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv1756348189
.yiv1756348189bold a {text-decoration:none;}#yiv1756348189 dd.yiv1756348189last
p a {font-family:Verdana;font-weight:700;}#yiv1756348189 dd.yiv1756348189last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1756348189
dd.yiv1756348189last p span.yiv1756348189yshortcuts
{margin-right:0;}#yiv1756348189 div.yiv1756348189attach-table div div a
{text-decoration:none;}#yiv1756348189 div.yiv1756348189attach-table
{width:400px;}#yiv1756348189 div.yiv1756348189file-title a, #yiv1756348189
div.yiv1756348189file-title a:active, #yiv1756348189
div.yiv1756348189file-title a:hover, #yiv1756348189 div.yiv1756348189file-title
a:visited {text-decoration:none;}#yiv1756348189 div.yiv1756348189photo-title a,
#yiv1756348189 div.yiv1756348189photo-title a:active, #yiv1756348189
div.yiv1756348189photo-title a:hover, #yiv1756348189
div.yiv1756348189photo-title a:visited {text-decoration:none;}#yiv1756348189
div#yiv1756348189ygrp-mlmsg #yiv1756348189ygrp-msg p a
span.yiv1756348189yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1756348189
.yiv1756348189green {color:#628c2a;}#yiv1756348189 .yiv1756348189MsoNormal
{margin:0 0 0 0;}#yiv1756348189 o {font-size:0;}#yiv1756348189
#yiv1756348189photos div {float:left;width:72px;}#yiv1756348189
#yiv1756348189photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv1756348189
#yiv1756348189photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1756348189
#yiv1756348189reco-category {font-size:77%;}#yiv1756348189
#yiv1756348189reco-desc {font-size:77%;}#yiv1756348189 .yiv1756348189replbq
{margin:4px;}#yiv1756348189 #yiv1756348189ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv1756348189 #yiv1756348189ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1756348189
#yiv1756348189ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1756348189
#yiv1756348189ygrp-mlmsg select, #yiv1756348189 input, #yiv1756348189 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv1756348189
#yiv1756348189ygrp-mlmsg pre, #yiv1756348189 code {font:115%
monospace;}#yiv1756348189 #yiv1756348189ygrp-mlmsg *
{line-height:1.22em;}#yiv1756348189 #yiv1756348189ygrp-mlmsg #yiv1756348189logo
{padding-bottom:10px;}#yiv1756348189 #yiv1756348189ygrp-msg p a
{font-family:Verdana;}#yiv1756348189 #yiv1756348189ygrp-msg
p#yiv1756348189attach-count span {color:#1E66AE;font-weight:700;}#yiv1756348189
#yiv1756348189ygrp-reco #yiv1756348189reco-head
{color:#ff7900;font-weight:700;}#yiv1756348189 #yiv1756348189ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv1756348189 #yiv1756348189ygrp-sponsor
#yiv1756348189ov li a {font-size:130%;text-decoration:none;}#yiv1756348189
#yiv1756348189ygrp-sponsor #yiv1756348189ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv1756348189
#yiv1756348189ygrp-sponsor #yiv1756348189ov ul {margin:0;padding:0 0 0
8px;}#yiv1756348189 #yiv1756348189ygrp-text
{font-family:Georgia;}#yiv1756348189 #yiv1756348189ygrp-text p {margin:0 0 1em
0;}#yiv1756348189 #yiv1756348189ygrp-text tt {font-size:120%;}#yiv1756348189
#yiv1756348189ygrp-vital ul li:last-child {border-right:none
!important;}#yiv1756348189
