yoo dodi,
coba data validationnya yg isi di cell yang akan di input NIP, masih pakai
countif namun kriterianya B7 dan operator trap nya " < > 1 " tanpa tanda petik
yang artinya tidak sama dengan 1 ( satu ) . br,
odong nando
Pada Rabu, 2 Desember 2015 10:49, "Dody Irawan [email protected]
[belajar-excel]" <[email protected]> menulis:
Assalamualaikum wr. wb.
Mohon bantuan kepada semua master excel.
bagaimana cara menghindari dobel input (misalnya NIP) pada form yang sudah saya
buat ini.
terimakasih.
Semoga ilmunya semakin bermanfaat....
Wassalamualaikum wr. wb. #yiv6326397018 #yiv6326397018 --
#yiv6326397018ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}#yiv6326397018 #yiv6326397018ygrp-mkp hr {border:1px solid
#d8d8d8;}#yiv6326397018 #yiv6326397018ygrp-mkp #yiv6326397018hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv6326397018 #yiv6326397018ygrp-mkp #yiv6326397018ads
{margin-bottom:10px;}#yiv6326397018 #yiv6326397018ygrp-mkp .yiv6326397018ad
{padding:0 0;}#yiv6326397018 #yiv6326397018ygrp-mkp .yiv6326397018ad p
{margin:0;}#yiv6326397018 #yiv6326397018ygrp-mkp .yiv6326397018ad a
{color:#0000ff;text-decoration:none;}#yiv6326397018 #yiv6326397018ygrp-sponsor
#yiv6326397018ygrp-lc {font-family:Arial;}#yiv6326397018
#yiv6326397018ygrp-sponsor #yiv6326397018ygrp-lc #yiv6326397018hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6326397018
#yiv6326397018ygrp-sponsor #yiv6326397018ygrp-lc .yiv6326397018ad
{margin-bottom:10px;padding:0 0;}#yiv6326397018 #yiv6326397018actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6326397018
#yiv6326397018activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6326397018
#yiv6326397018activity span {font-weight:700;}#yiv6326397018
#yiv6326397018activity span:first-child
{text-transform:uppercase;}#yiv6326397018 #yiv6326397018activity span a
{color:#5085b6;text-decoration:none;}#yiv6326397018 #yiv6326397018activity span
span {color:#ff7900;}#yiv6326397018 #yiv6326397018activity span
.yiv6326397018underline {text-decoration:underline;}#yiv6326397018
.yiv6326397018attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv6326397018 .yiv6326397018attach div a
{text-decoration:none;}#yiv6326397018 .yiv6326397018attach img
{border:none;padding-right:5px;}#yiv6326397018 .yiv6326397018attach label
{display:block;margin-bottom:5px;}#yiv6326397018 .yiv6326397018attach label a
{text-decoration:none;}#yiv6326397018 blockquote {margin:0 0 0
4px;}#yiv6326397018 .yiv6326397018bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv6326397018
.yiv6326397018bold a {text-decoration:none;}#yiv6326397018 dd.yiv6326397018last
p a {font-family:Verdana;font-weight:700;}#yiv6326397018 dd.yiv6326397018last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6326397018
dd.yiv6326397018last p span.yiv6326397018yshortcuts
{margin-right:0;}#yiv6326397018 div.yiv6326397018attach-table div div a
{text-decoration:none;}#yiv6326397018 div.yiv6326397018attach-table
{width:400px;}#yiv6326397018 div.yiv6326397018file-title a, #yiv6326397018
div.yiv6326397018file-title a:active, #yiv6326397018
div.yiv6326397018file-title a:hover, #yiv6326397018 div.yiv6326397018file-title
a:visited {text-decoration:none;}#yiv6326397018 div.yiv6326397018photo-title a,
#yiv6326397018 div.yiv6326397018photo-title a:active, #yiv6326397018
div.yiv6326397018photo-title a:hover, #yiv6326397018
div.yiv6326397018photo-title a:visited {text-decoration:none;}#yiv6326397018
div#yiv6326397018ygrp-mlmsg #yiv6326397018ygrp-msg p a
span.yiv6326397018yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6326397018
.yiv6326397018green {color:#628c2a;}#yiv6326397018 .yiv6326397018MsoNormal
{margin:0 0 0 0;}#yiv6326397018 o {font-size:0;}#yiv6326397018
#yiv6326397018photos div {float:left;width:72px;}#yiv6326397018
#yiv6326397018photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv6326397018
#yiv6326397018photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6326397018
#yiv6326397018reco-category {font-size:77%;}#yiv6326397018
#yiv6326397018reco-desc {font-size:77%;}#yiv6326397018 .yiv6326397018replbq
{margin:4px;}#yiv6326397018 #yiv6326397018ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv6326397018 #yiv6326397018ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6326397018
#yiv6326397018ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6326397018
#yiv6326397018ygrp-mlmsg select, #yiv6326397018 input, #yiv6326397018 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv6326397018
#yiv6326397018ygrp-mlmsg pre, #yiv6326397018 code {font:115%
monospace;}#yiv6326397018 #yiv6326397018ygrp-mlmsg *
{line-height:1.22em;}#yiv6326397018 #yiv6326397018ygrp-mlmsg #yiv6326397018logo
{padding-bottom:10px;}#yiv6326397018 #yiv6326397018ygrp-msg p a
{font-family:Verdana;}#yiv6326397018 #yiv6326397018ygrp-msg
p#yiv6326397018attach-count span {color:#1E66AE;font-weight:700;}#yiv6326397018
#yiv6326397018ygrp-reco #yiv6326397018reco-head
{color:#ff7900;font-weight:700;}#yiv6326397018 #yiv6326397018ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv6326397018 #yiv6326397018ygrp-sponsor
#yiv6326397018ov li a {font-size:130%;text-decoration:none;}#yiv6326397018
#yiv6326397018ygrp-sponsor #yiv6326397018ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv6326397018
#yiv6326397018ygrp-sponsor #yiv6326397018ov ul {margin:0;padding:0 0 0
8px;}#yiv6326397018 #yiv6326397018ygrp-text
{font-family:Georgia;}#yiv6326397018 #yiv6326397018ygrp-text p {margin:0 0 1em
0;}#yiv6326397018 #yiv6326397018ygrp-text tt {font-size:120%;}#yiv6326397018
#yiv6326397018ygrp-vital ul li:last-child {border-right:none
!important;}#yiv6326397018
