Sabtu, 27 Februari 2016

[belajar-excel] Digest Number 3774

2 Messages

Digest #3774

Messages

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

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

============================================================
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
---------------------------------------------------------------------

Tidak ada komentar:

Poskan Komentar