1 Message

Digest #3909

Bls: [belajar-excel] Mencari data lookup dengan multiple criteria [1 by "odong nando"

Message

1a

Bls: [belajar-excel] Mencari data lookup dengan multiple criteria [1

Thu Jul 14, 2016 9:23 pm (PDT) . Posted by:

"odong nando"

coba tolong penggolongannya di perjelas min, mid n max itu dari batas berapa sampai berapa, atau dari batas bawah berapa batas atasnya berapa. br,

odong nando

Dari: "Isti Astro milisastro@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com>
Kepada: "belajar-excel@yahoogroups.com" <belajar-excel@yahoogroups.com>
Dikirim: Kamis, 14 Juli 2016 15:20
Judul: [belajar-excel] Mencari data lookup dengan multiple criteria [1 Attachment]

Dear All BeExceller,
Mohon bantuannya untuk case terlampir, saya ingin mencari hasil value data (range value) dari tabel data dengan dua atau lebih kriteria. Lebih lengkapnya mohon agar dapat dibuka file terlampir.
Terima kasih atas bantuannya.

--
Sent from desktop powered by Internet dimana saja
http://www.pulsagram.com/indexCN116854.htm
#yiv6036751392 #yiv6036751392 -- #yiv6036751392ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6036751392 #yiv6036751392ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6036751392 #yiv6036751392ygrp-mkp #yiv6036751392hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv6036751392 #yiv6036751392ygrp-mkp #yiv6036751392ads {margin-bottom:10px;}#yiv6036751392 #yiv6036751392ygrp-mkp .yiv6036751392ad {padding:0 0;}#yiv6036751392 #yiv6036751392ygrp-mkp .yiv6036751392ad p {margin:0;}#yiv6036751392 #yiv6036751392ygrp-mkp .yiv6036751392ad a {color:#0000ff;text-decoration:none;}#yiv6036751392 #yiv6036751392ygrp-sponsor #yiv6036751392ygrp-lc {font-family:Arial;}#yiv6036751392 #yiv6036751392ygrp-sponsor #yiv6036751392ygrp-lc #yiv6036751392hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6036751392 #yiv6036751392ygrp-sponsor #yiv6036751392ygrp-lc .yiv6036751392ad {margin-bottom:10px;padding:0 0;}#yiv6036751392 #yiv6036751392actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6036751392 #yiv6036751392activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6036751392 #yiv6036751392activity span {font-weight:700;}#yiv6036751392 #yiv6036751392activity span:first-child {text-transform:uppercase;}#yiv6036751392 #yiv6036751392activity span a {color:#5085b6;text-decoration:none;}#yiv6036751392 #yiv6036751392activity span span {color:#ff7900;}#yiv6036751392 #yiv6036751392activity span .yiv6036751392underline {text-decoration:underline;}#yiv6036751392 .yiv6036751392attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv6036751392 .yiv6036751392attach div a {text-decoration:none;}#yiv6036751392 .yiv6036751392attach img {border:none;padding-right:5px;}#yiv6036751392 .yiv6036751392attach label {display:block;margin-bottom:5px;}#yiv6036751392 .yiv6036751392attach label a {text-decoration:none;}#yiv6036751392 blockquote {margin:0 0 0 4px;}#yiv6036751392 .yiv6036751392bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv6036751392 .yiv6036751392bold a {text-decoration:none;}#yiv6036751392 dd.yiv6036751392last p a {font-family:Verdana;font-weight:700;}#yiv6036751392 dd.yiv6036751392last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6036751392 dd.yiv6036751392last p span.yiv6036751392yshortcuts {margin-right:0;}#yiv6036751392 div.yiv6036751392attach-table div div a {text-decoration:none;}#yiv6036751392 div.yiv6036751392attach-table {width:400px;}#yiv6036751392 div.yiv6036751392file-title a, #yiv6036751392 div.yiv6036751392file-title a:active, #yiv6036751392 div.yiv6036751392file-title a:hover, #yiv6036751392 div.yiv6036751392file-title a:visited {text-decoration:none;}#yiv6036751392 div.yiv6036751392photo-title a, #yiv6036751392 div.yiv6036751392photo-title a:active, #yiv6036751392 div.yiv6036751392photo-title a:hover, #yiv6036751392 div.yiv6036751392photo-title a:visited {text-decoration:none;}#yiv6036751392 div#yiv6036751392ygrp-mlmsg #yiv6036751392ygrp-msg p a span.yiv6036751392yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6036751392 .yiv6036751392green {color:#628c2a;}#yiv6036751392 .yiv6036751392MsoNormal {margin:0 0 0 0;}#yiv6036751392 o {font-size:0;}#yiv6036751392 #yiv6036751392photos div {float:left;width:72px;}#yiv6036751392 #yiv6036751392photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv6036751392 #yiv6036751392photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6036751392 #yiv6036751392reco-category {font-size:77%;}#yiv6036751392 #yiv6036751392reco-desc {font-size:77%;}#yiv6036751392 .yiv6036751392replbq {margin:4px;}#yiv6036751392 #yiv6036751392ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv6036751392 #yiv6036751392ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6036751392 #yiv6036751392ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6036751392 #yiv6036751392ygrp-mlmsg select, #yiv6036751392 input, #yiv6036751392 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv6036751392 #yiv6036751392ygrp-mlmsg pre, #yiv6036751392 code {font:115% monospace;}#yiv6036751392 #yiv6036751392ygrp-mlmsg * {line-height:1.22em;}#yiv6036751392 #yiv6036751392ygrp-mlmsg #yiv6036751392logo {padding-bottom:10px;}#yiv6036751392 #yiv6036751392ygrp-msg p a {font-family:Verdana;}#yiv6036751392 #yiv6036751392ygrp-msg p#yiv6036751392attach-count span {color:#1E66AE;font-weight:700;}#yiv6036751392 #yiv6036751392ygrp-reco #yiv6036751392reco-head {color:#ff7900;font-weight:700;}#yiv6036751392 #yiv6036751392ygrp-reco {margin-bottom:20px;padding:0px;}#yiv6036751392 #yiv6036751392ygrp-sponsor #yiv6036751392ov li a {font-size:130%;text-decoration:none;}#yiv6036751392 #yiv6036751392ygrp-sponsor #yiv6036751392ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv6036751392 #yiv6036751392ygrp-sponsor #yiv6036751392ov ul {margin:0;padding:0 0 0 8px;}#yiv6036751392 #yiv6036751392ygrp-text {font-family:Georgia;}#yiv6036751392 #yiv6036751392ygrp-text p {margin:0 0 1em 0;}#yiv6036751392 #yiv6036751392ygrp-text tt {font-size:120%;}#yiv6036751392 #yiv6036751392ygrp-vital ul li:last-child {border-right:none !important;}#yiv6036751392

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