Terima kasih Mas Susilo atas jawabannya, sangat bermanfaat.
Pada Jumat, 26 Februari 2016 10:04, "Susilo - [email protected]
[belajar-excel]" <[email protected]> menulis:
Dear Arif
Berikut saya mencoba untuk memberikan solusi1. Untuk nama yang lulus saya
menggunakan Index small if dengan array2. Untuk nomer urut saya menggunakan
index match tanpa array
Rumus berikut untuk 500 baris input, jika data input lebih, maka jumlah
kolomnya bisa disesuaikan
Terima kasihSusilo
2016-02-25 16:09 GMT+07:00 hendrik karnadi [email protected]
[belajar-excel] <[email protected]>:
Hai Arif,Jwb terlampir, tapi formatnya ga persis sama.
Salam,HK
From: "Arif Wijaya [email protected] [belajar-excel]"
<[email protected]>
To: [email protected]
Sent: Thursday, 25 February 2016, 12:32
Subject: [belajar-excel] mengambil data sesuai kriteria di kolom lain [1
Attachment]
Assalamu'alaikumKalau ingin mengambil data yang hanya sesuai kriteria
seperti pada lampiran, formulanya bagamaina?Terima kasih
#yiv1769012852 #yiv1769012852 -- #yiv1769012852ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1769012852
#yiv1769012852ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1769012852
#yiv1769012852ygrp-mkp #yiv1769012852hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv1769012852 #yiv1769012852ygrp-mkp #yiv1769012852ads
{margin-bottom:10px;}#yiv1769012852 #yiv1769012852ygrp-mkp .yiv1769012852ad
{padding:0 0;}#yiv1769012852 #yiv1769012852ygrp-mkp .yiv1769012852ad p
{margin:0;}#yiv1769012852 #yiv1769012852ygrp-mkp .yiv1769012852ad a
{color:#0000ff;text-decoration:none;}#yiv1769012852 #yiv1769012852ygrp-sponsor
#yiv1769012852ygrp-lc {font-family:Arial;}#yiv1769012852
#yiv1769012852ygrp-sponsor #yiv1769012852ygrp-lc #yiv1769012852hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1769012852
#yiv1769012852ygrp-sponsor #yiv1769012852ygrp-lc .yiv1769012852ad
{margin-bottom:10px;padding:0 0;}#yiv1769012852 #yiv1769012852actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1769012852
#yiv1769012852activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1769012852
#yiv1769012852activity span {font-weight:700;}#yiv1769012852
#yiv1769012852activity span:first-child
{text-transform:uppercase;}#yiv1769012852 #yiv1769012852activity span a
{color:#5085b6;text-decoration:none;}#yiv1769012852 #yiv1769012852activity span
span {color:#ff7900;}#yiv1769012852 #yiv1769012852activity span
.yiv1769012852underline {text-decoration:underline;}#yiv1769012852
.yiv1769012852attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv1769012852 .yiv1769012852attach div a
{text-decoration:none;}#yiv1769012852 .yiv1769012852attach img
{border:none;padding-right:5px;}#yiv1769012852 .yiv1769012852attach label
{display:block;margin-bottom:5px;}#yiv1769012852 .yiv1769012852attach label a
{text-decoration:none;}#yiv1769012852 blockquote {margin:0 0 0
4px;}#yiv1769012852 .yiv1769012852bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv1769012852
.yiv1769012852bold a {text-decoration:none;}#yiv1769012852 dd.yiv1769012852last
p a {font-family:Verdana;font-weight:700;}#yiv1769012852 dd.yiv1769012852last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1769012852
dd.yiv1769012852last p span.yiv1769012852yshortcuts
{margin-right:0;}#yiv1769012852 div.yiv1769012852attach-table div div a
{text-decoration:none;}#yiv1769012852 div.yiv1769012852attach-table
{width:400px;}#yiv1769012852 div.yiv1769012852file-title a, #yiv1769012852
div.yiv1769012852file-title a:active, #yiv1769012852
div.yiv1769012852file-title a:hover, #yiv1769012852 div.yiv1769012852file-title
a:visited {text-decoration:none;}#yiv1769012852 div.yiv1769012852photo-title a,
#yiv1769012852 div.yiv1769012852photo-title a:active, #yiv1769012852
div.yiv1769012852photo-title a:hover, #yiv1769012852
div.yiv1769012852photo-title a:visited {text-decoration:none;}#yiv1769012852
div#yiv1769012852ygrp-mlmsg #yiv1769012852ygrp-msg p a
span.yiv1769012852yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1769012852
.yiv1769012852green {color:#628c2a;}#yiv1769012852 .yiv1769012852MsoNormal
{margin:0 0 0 0;}#yiv1769012852 o {font-size:0;}#yiv1769012852
#yiv1769012852photos div {float:left;width:72px;}#yiv1769012852
#yiv1769012852photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv1769012852
#yiv1769012852photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1769012852
#yiv1769012852reco-category {font-size:77%;}#yiv1769012852
#yiv1769012852reco-desc {font-size:77%;}#yiv1769012852 .yiv1769012852replbq
{margin:4px;}#yiv1769012852 #yiv1769012852ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv1769012852 #yiv1769012852ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1769012852
#yiv1769012852ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1769012852
#yiv1769012852ygrp-mlmsg select, #yiv1769012852 input, #yiv1769012852 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv1769012852
#yiv1769012852ygrp-mlmsg pre, #yiv1769012852 code {font:115%
monospace;}#yiv1769012852 #yiv1769012852ygrp-mlmsg *
{line-height:1.22em;}#yiv1769012852 #yiv1769012852ygrp-mlmsg #yiv1769012852logo
{padding-bottom:10px;}#yiv1769012852 #yiv1769012852ygrp-msg p a
{font-family:Verdana;}#yiv1769012852 #yiv1769012852ygrp-msg
p#yiv1769012852attach-count span {color:#1E66AE;font-weight:700;}#yiv1769012852
#yiv1769012852ygrp-reco #yiv1769012852reco-head
{color:#ff7900;font-weight:700;}#yiv1769012852 #yiv1769012852ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv1769012852 #yiv1769012852ygrp-sponsor
#yiv1769012852ov li a {font-size:130%;text-decoration:none;}#yiv1769012852
#yiv1769012852ygrp-sponsor #yiv1769012852ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv1769012852
#yiv1769012852ygrp-sponsor #yiv1769012852ov ul {margin:0;padding:0 0 0
8px;}#yiv1769012852 #yiv1769012852ygrp-text
{font-family:Georgia;}#yiv1769012852 #yiv1769012852ygrp-text p {margin:0 0 1em
0;}#yiv1769012852 #yiv1769012852ygrp-text tt {font-size:120%;}#yiv1769012852
#yiv1769012852ygrp-vital ul li:last-child {border-right:none
!important;}#yiv1769012852
