[belajar-excel] Menentukan data yang sudah terpakai [1 Attachment]

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

[belajar-excel] Menentukan data yang sudah terpakai [1 Attachment]

Milis Belajar Excel mailing list
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 (15K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Menentukan data yang sudah terpakai

Milis Belajar Excel mailing list
Wa'alaikumussalam wr wb

Coba pakai countif atau countifs atau array formula match.

Wassalamu'alaikum wr wb
Kid
Sent from my smart enough phone

> On May 23, 2017, at 16:57, HAIRUL ALAM [hidden email] [belajar-excel] <[hidden email]> wrote:
>
> Assalamualaikum
> Para 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" juga dengan kriteria sheet  DATA Cell "B" & "D" dan sheet INPUT Cell "B" & "D" pula.
>
> Terlampir data excelnya
> Terimakasih Banyak
> Wassalamualaikum Wr. Wb.
>
> <Menentukan data yang sudah terpakai.xlsx>
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Menentukan data yang sudah terpakai

Milis Belajar Excel mailing list
In reply to this post by Milis Belajar Excel mailing list

السَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ
Semangat pagi,.

Sepertinya kalau Samping kanan nya bukan NA berarti OK, kalo NA berarti Not Yet.


وَالسَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ

Warm Regards,

On 23/05/2017 16:57, HAIRUL ALAM [hidden email] [belajar-excel] wrote:

> Assalamualaikum
> Para Master Excel
>
> Bagaimanaagar 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" juga dengan kriteria sheet  
> DATA Cell "B" & "D" dan sheet INPUT Cell "B" & "D" pula.
>
> Terlampir data excelnya
> Terimakasih Banyak
> Wassalamualaikum Wr. Wb.
>

Reply | Threaded
Open this post in threaded view
|

Bls: [belajar-excel] Menentukan data yang sudah terpakai

Milis Belajar Excel mailing list
In reply to this post by Milis Belajar Excel mailing list
Assalamualaikum Wr. Wb.Para Master
Terimakasih banyak Pencerahannya
Wassalamualaikum Wr. Wb.Hairul Alam


    Pada Selasa, 23 Mei 2017 19:24, "'Mr. Kid' [hidden email] [belajar-excel]" <[hidden email]> 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 [hidden email] [belajar-excel] <[hidden email]> 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