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 milisas...@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
