Yth. Bagas
Terima kasih atas solusinya ..
satu lagi pertanyaan :rumus tersebut saya tambahi iferror untuk menghilangkan
error jika data kosong (juga saya set excel table) ..tetapi jumlah isian data
validation masih menampilkan semua 14 baris record ..saya sudah mencoba membuat
name range dinamis pakai offset (utk sumber bagi data validation) tetapi item
yang kosong masih ikut di data validationnya ..
bagaimana kira2 solusinya ?
terima kasih
On Thursday, February 27, 2020, 07:46:57 AM GMT+7, Bagus
bagus4...@gmail.com [belajar-excel] <belajar-excel@yahoogroups.com> wrote:
Dear Ari;
Apakah spt file terlampir.
Wassalam
Bagus
Pada tanggal Sel, 25 Feb 2020 pukul 09.50 Eira I Arie
cheivory_bri...@yahoo..com [belajar-excel] <belajar-excel@yahoogroups.com>
menulis:
Selamat Pagi Rekan2
Mohon bantuannyabagaiamana cara menampilkan ID data yang belum diinput (dengan
data validation) ..file kasus terlampir.
terima kasih
ari
#yiv2118191358 #yiv2118191358 -- #yiv2118191358ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2118191358
#yiv2118191358ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2118191358
#yiv2118191358ygrp-mkp #yiv2118191358hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv2118191358 #yiv2118191358ygrp-mkp #yiv2118191358ads
{margin-bottom:10px;}#yiv2118191358 #yiv2118191358ygrp-mkp .yiv2118191358ad
{padding:0 0;}#yiv2118191358 #yiv2118191358ygrp-mkp .yiv2118191358ad p
{margin:0;}#yiv2118191358 #yiv2118191358ygrp-mkp .yiv2118191358ad a
{color:#0000ff;text-decoration:none;}#yiv2118191358 #yiv2118191358ygrp-sponsor
#yiv2118191358ygrp-lc {font-family:Arial;}#yiv2118191358
#yiv2118191358ygrp-sponsor #yiv2118191358ygrp-lc #yiv2118191358hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2118191358
#yiv2118191358ygrp-sponsor #yiv2118191358ygrp-lc .yiv2118191358ad
{margin-bottom:10px;padding:0 0;}#yiv2118191358 #yiv2118191358actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2118191358
#yiv2118191358activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2118191358
#yiv2118191358activity span {font-weight:700;}#yiv2118191358
#yiv2118191358activity span:first-child
{text-transform:uppercase;}#yiv2118191358 #yiv2118191358activity span a
{color:#5085b6;text-decoration:none;}#yiv2118191358 #yiv2118191358activity span
span {color:#ff7900;}#yiv2118191358 #yiv2118191358activity span
.yiv2118191358underline {text-decoration:underline;}#yiv2118191358
.yiv2118191358attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv2118191358 .yiv2118191358attach div a
{text-decoration:none;}#yiv2118191358 .yiv2118191358attach img
{border:none;padding-right:5px;}#yiv2118191358 .yiv2118191358attach label
{display:block;margin-bottom:5px;}#yiv2118191358 .yiv2118191358attach label a
{text-decoration:none;}#yiv2118191358 blockquote {margin:0 0 0
4px;}#yiv2118191358 .yiv2118191358bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv2118191358
.yiv2118191358bold a {text-decoration:none;}#yiv2118191358 dd.yiv2118191358last
p a {font-family:Verdana;font-weight:700;}#yiv2118191358 dd.yiv2118191358last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2118191358
dd.yiv2118191358last p span.yiv2118191358yshortcuts
{margin-right:0;}#yiv2118191358 div.yiv2118191358attach-table div div a
{text-decoration:none;}#yiv2118191358 div.yiv2118191358attach-table
{width:400px;}#yiv2118191358 div.yiv2118191358file-title a, #yiv2118191358
div.yiv2118191358file-title a:active, #yiv2118191358
div.yiv2118191358file-title a:hover, #yiv2118191358 div.yiv2118191358file-title
a:visited {text-decoration:none;}#yiv2118191358 div.yiv2118191358photo-title a,
#yiv2118191358 div.yiv2118191358photo-title a:active, #yiv2118191358
div.yiv2118191358photo-title a:hover, #yiv2118191358
div.yiv2118191358photo-title a:visited {text-decoration:none;}#yiv2118191358
div#yiv2118191358ygrp-mlmsg #yiv2118191358ygrp-msg p a
span.yiv2118191358yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2118191358
.yiv2118191358green {color:#628c2a;}#yiv2118191358 .yiv2118191358MsoNormal
{margin:0 0 0 0;}#yiv2118191358 o {font-size:0;}#yiv2118191358
#yiv2118191358photos div {float:left;width:72px;}#yiv2118191358
#yiv2118191358photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv2118191358
#yiv2118191358photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2118191358
#yiv2118191358reco-category {font-size:77%;}#yiv2118191358
#yiv2118191358reco-desc {font-size:77%;}#yiv2118191358 .yiv2118191358replbq
{margin:4px;}#yiv2118191358 #yiv2118191358ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv2118191358 #yiv2118191358ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2118191358
#yiv2118191358ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2118191358
#yiv2118191358ygrp-mlmsg select, #yiv2118191358 input, #yiv2118191358 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv2118191358
#yiv2118191358ygrp-mlmsg pre, #yiv2118191358 code {font:115%
monospace;}#yiv2118191358 #yiv2118191358ygrp-mlmsg *
{line-height:1.22em;}#yiv2118191358 #yiv2118191358ygrp-mlmsg #yiv2118191358logo
{padding-bottom:10px;}#yiv2118191358 #yiv2118191358ygrp-msg p a
{font-family:Verdana;}#yiv2118191358 #yiv2118191358ygrp-msg
p#yiv2118191358attach-count span {color:#1E66AE;font-weight:700;}#yiv2118191358
#yiv2118191358ygrp-reco #yiv2118191358reco-head
{color:#ff7900;font-weight:700;}#yiv2118191358 #yiv2118191358ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv2118191358 #yiv2118191358ygrp-sponsor
#yiv2118191358ov li a {font-size:130%;text-decoration:none;}#yiv2118191358
#yiv2118191358ygrp-sponsor #yiv2118191358ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv2118191358
#yiv2118191358ygrp-sponsor #yiv2118191358ov ul {margin:0;padding:0 0 0
8px;}#yiv2118191358 #yiv2118191358ygrp-text
{font-family:Georgia;}#yiv2118191358 #yiv2118191358ygrp-text p {margin:0 0 1em
0;}#yiv2118191358 #yiv2118191358ygrp-text tt {font-size:120%;}#yiv2118191358
#yiv2118191358ygrp-vital ul li:last-child {border-right:none
!important;}#yiv2118191358
