Assalamualaikum Wr. Wb.Para Master
Terimakasih banyak Pencerahannya
Wassalamualaikum Wr. Wb.Hairul Alam
Pada Selasa, 23 Mei 2017 19:24, "'Mr. Kid' mr.nm...@gmail.com
[belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Wa'alaikumussalam wr wb
Coba pakai countif atau countifs atau array formula match.
Wassalamu'alaikum wr wbKid
Sent from my smart enough phone
On May 23, 2017, at 16:57, HAIRUL ALAM ha_m...@yahoo.co.id [belajar-excel]
<belajar-excel@yahoogroups.com> wrote:
AssalamualaikumPara Master Excel
Bagaimana agar pada sheet DATA cell "G" (INSTALL) dapat secara otomatis
menghasilkan nilai (OK) dan(NOT YET) bila data pada Cell "B" sudah terpakai
pada sheet INPUT cell "B" jugadengan kriteria sheet DATA Cell"B" & "D" dan
sheet INPUT Cell "B" &"D" pula.
Terlampir data excelnyaTerimakasih BanyakWassalamualaikum Wr. Wb.
<Menentukan data yang sudah terpakai.xlsx>
#yiv2886830206 #yiv2886830206 -- #yiv2886830206ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2886830206
#yiv2886830206ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2886830206
#yiv2886830206ygrp-mkp #yiv2886830206hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv2886830206 #yiv2886830206ygrp-mkp #yiv2886830206ads
{margin-bottom:10px;}#yiv2886830206 #yiv2886830206ygrp-mkp .yiv2886830206ad
{padding:0 0;}#yiv2886830206 #yiv2886830206ygrp-mkp .yiv2886830206ad p
{margin:0;}#yiv2886830206 #yiv2886830206ygrp-mkp .yiv2886830206ad a
{color:#0000ff;text-decoration:none;}#yiv2886830206 #yiv2886830206ygrp-sponsor
#yiv2886830206ygrp-lc {font-family:Arial;}#yiv2886830206
#yiv2886830206ygrp-sponsor #yiv2886830206ygrp-lc #yiv2886830206hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2886830206
#yiv2886830206ygrp-sponsor #yiv2886830206ygrp-lc .yiv2886830206ad
{margin-bottom:10px;padding:0 0;}#yiv2886830206 #yiv2886830206actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2886830206
#yiv2886830206activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2886830206
#yiv2886830206activity span {font-weight:700;}#yiv2886830206
#yiv2886830206activity span:first-child
{text-transform:uppercase;}#yiv2886830206 #yiv2886830206activity span a
{color:#5085b6;text-decoration:none;}#yiv2886830206 #yiv2886830206activity span
span {color:#ff7900;}#yiv2886830206 #yiv2886830206activity span
.yiv2886830206underline {text-decoration:underline;}#yiv2886830206
.yiv2886830206attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv2886830206 .yiv2886830206attach div a
{text-decoration:none;}#yiv2886830206 .yiv2886830206attach img
{border:none;padding-right:5px;}#yiv2886830206 .yiv2886830206attach label
{display:block;margin-bottom:5px;}#yiv2886830206 .yiv2886830206attach label a
{text-decoration:none;}#yiv2886830206 blockquote {margin:0 0 0
4px;}#yiv2886830206 .yiv2886830206bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv2886830206
.yiv2886830206bold a {text-decoration:none;}#yiv2886830206 dd.yiv2886830206last
p a {font-family:Verdana;font-weight:700;}#yiv2886830206 dd.yiv2886830206last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2886830206
dd.yiv2886830206last p span.yiv2886830206yshortcuts
{margin-right:0;}#yiv2886830206 div.yiv2886830206attach-table div div a
{text-decoration:none;}#yiv2886830206 div.yiv2886830206attach-table
{width:400px;}#yiv2886830206 div.yiv2886830206file-title a, #yiv2886830206
div.yiv2886830206file-title a:active, #yiv2886830206
div.yiv2886830206file-title a:hover, #yiv2886830206 div.yiv2886830206file-title
a:visited {text-decoration:none;}#yiv2886830206 div.yiv2886830206photo-title a,
#yiv2886830206 div.yiv2886830206photo-title a:active, #yiv2886830206
div.yiv2886830206photo-title a:hover, #yiv2886830206
div.yiv2886830206photo-title a:visited {text-decoration:none;}#yiv2886830206
div#yiv2886830206ygrp-mlmsg #yiv2886830206ygrp-msg p a
span.yiv2886830206yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2886830206
.yiv2886830206green {color:#628c2a;}#yiv2886830206 .yiv2886830206MsoNormal
{margin:0 0 0 0;}#yiv2886830206 o {font-size:0;}#yiv2886830206
#yiv2886830206photos div {float:left;width:72px;}#yiv2886830206
#yiv2886830206photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv2886830206
#yiv2886830206photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2886830206
#yiv2886830206reco-category {font-size:77%;}#yiv2886830206
#yiv2886830206reco-desc {font-size:77%;}#yiv2886830206 .yiv2886830206replbq
{margin:4px;}#yiv2886830206 #yiv2886830206ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv2886830206 #yiv2886830206ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2886830206
#yiv2886830206ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2886830206
#yiv2886830206ygrp-mlmsg select, #yiv2886830206 input, #yiv2886830206 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv2886830206
#yiv2886830206ygrp-mlmsg pre, #yiv2886830206 code {font:115%
monospace;}#yiv2886830206 #yiv2886830206ygrp-mlmsg *
{line-height:1.22em;}#yiv2886830206 #yiv2886830206ygrp-mlmsg #yiv2886830206logo
{padding-bottom:10px;}#yiv2886830206 #yiv2886830206ygrp-msg p a
{font-family:Verdana;}#yiv2886830206 #yiv2886830206ygrp-msg
p#yiv2886830206attach-count span {color:#1E66AE;font-weight:700;}#yiv2886830206
#yiv2886830206ygrp-reco #yiv2886830206reco-head
{color:#ff7900;font-weight:700;}#yiv2886830206 #yiv2886830206ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv2886830206 #yiv2886830206ygrp-sponsor
#yiv2886830206ov li a {font-size:130%;text-decoration:none;}#yiv2886830206
#yiv2886830206ygrp-sponsor #yiv2886830206ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv2886830206
#yiv2886830206ygrp-sponsor #yiv2886830206ov ul {margin:0;padding:0 0 0
8px;}#yiv2886830206 #yiv2886830206ygrp-text
{font-family:Georgia;}#yiv2886830206 #yiv2886830206ygrp-text p {margin:0 0 1em
0;}#yiv2886830206 #yiv2886830206ygrp-text tt {font-size:120%;}#yiv2886830206
#yiv2886830206ygrp-vital ul li:last-child {border-right:none
!important;}#yiv2886830206
