[belajar-excel] Digest Number 3774

Milis Belajar Microsoft Excel Group

2 Messages

Digest #3774

1

formula untuk mencari nilai yang nilai lookupnya tidak ada by "odong nando"

2a

Bls: [belajar-excel] mengambil data sesuai kriteria di kolom lain [1 by "Arif Wijaya" arifw1979

Messages

1

formula untuk mencari nilai yang nilai lookupnya tidak ada

Fri Feb 26, 2016 2:43 am (PST) . Posted by:

"odong nando"

dear all,
lg bingung mencari nilai lookup sebuah tanggal yang tidak ada di data,
saya punya sederetan tanggal dan nilai, setiap tanggal tidak selalu ada saat dicari, bagaimana caranya agar nilai tanggal sebelumnya dari nilai yang dicari menjadi hasil pencarian dari nilai tanggal yang tidak ada.
br,

odong nando

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

2a

Bls: [belajar-excel] mengambil data sesuai kriteria di kolom lain [1

Fri Feb 26, 2016 6:57 am (PST) . Posted by:

"Arif Wijaya" arifw1979

Terima kasih Mas Susilo atas jawabannya, sangat bermanfaat.

Pada Jumat, 26 Februari 2016 10:04, "Susilo - susilo.ib@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com> 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 hendrikkarnadi@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com>:

  Hai Arif,Jwb terlampir, tapi formatnya ga persis sama.
Salam,HK

From: "Arif Wijaya arifw1979@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
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

Reply to sender . Reply to group . Reply via Web Post . All Messages (5) . 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 6

• Privacy • Unsubscribe • Terms of Use