[belajar-excel] Menampilkan ID data yeng belum diinput (dengan data validation)

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

[belajar-excel] Menampilkan ID data yeng belum diinput (dengan data validation)

Eira_ariE
Selamat Pagi Rekan2
Mohon bantuannyabagaiamana cara menampilkan ID data yang belum diinput (dengan data validation) ..file kasus terlampir.
terima kasih
ari

=?UTF-8?b?dGFueWEgLSBtZW5hbXBpbGthbiBJRCBkYXRhIHlhbmcgYmVsdW0gZGlpbnB1dC54bHN4?= (16K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Menampilkan ID data yeng belum diinput (dengan data validation)

Bagus-2
Dear Ari;

Apakah spt file terlampir.


Wassalam
   Bagus


Pada tanggal Sel, 25 Feb 2020 pukul 09.50 Eira I Arie
[hidden email] [belajar-excel] <[hidden email]>
menulis:

>
>
> Selamat Pagi Rekan2
>
> Mohon bantuannya
> bagaiamana cara menampilkan ID data yang belum diinput (dengan data
> validation) ..
> file kasus terlampir.
>
> terima kasih
>
> *ari*
>
>
>

Bugs - menampilkan ID data yang belum diinput.xlsx (19K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Menampilkan ID data yeng belum diinput (dengan data validation)

Eira_ariE

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 [hidden email] [belajar-excel] <[hidden email]> wrote:  
 
    

Dear Ari;
Apakah spt file terlampir.

Wassalam
   Bagus


Pada tanggal Sel, 25 Feb 2020 pukul 09.50 Eira I Arie cheivory_bridge@yahoo..com [belajar-excel] <[hidden email]> 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  
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Menampilkan ID data yeng belum diinput (dengan data validation)

Bagus-2
Dear Ari;

tetapi jumlah isian data validation masih menampilkan semua 14 baris record
...

14 baris record karena ini: +ROW($1:$14)
Coba ganti rumus +ROW($1:$14) sesuai keinginan.


Wassalam
   Bagus


Pada tanggal Kam, 27 Feb 2020 pukul 09.27 Eira I Arie
[hidden email] [belajar-excel] <[hidden email]>
menulis:

>
>
>
> 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
> [hidden email] [belajar-excel] <[hidden email]>
> wrote:
>
>
>
>
> Dear Ari;
>
> Apakah spt file terlampir.
>
>
> Wassalam
>    Bagus
>
>
> Pada tanggal Sel, 25 Feb 2020 pukul 09.50 Eira I Arie
> [hidden email] [belajar-excel] <[hidden email]>
> menulis:
>
>
>
> Selamat Pagi Rekan2
>
> Mohon bantuannya
> bagaiamana cara menampilkan ID data yang belum diinput (dengan data
> validation) ..
> file kasus terlampir.
>
> terima kasih
>
> *ari*
>
>
>