[belajar-excel] menghitung remark sesuai kriteria [1 Attachment]

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

[belajar-excel] menghitung remark sesuai kriteria [1 Attachment]

indria pie
salam excel
mohon bantuan master-master excel, untuk persoalan kami (terlampir)
terima kasih sebelumnya
salam,pie

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

RE: [belajar-excel] menghitung remark sesuai kriteria [6 Attachments]

M.Ade Alfarid
Coba pelajari file dari Mr.kid terlampir



ade



*From:* [hidden email] [mailto:[hidden email]]

*Sent:* Wednesday, January 23, 2019 3:41 PM
*To:* [hidden email]
*Subject:* [belajar-excel] menghitung remark sesuai kriteria [1 Attachment]





salam excel



mohon bantuan master-master excel, untuk persoalan kami (terlampir)



terima kasih sebelumnya



salam,

pie



image001.jpg (578 bytes) Download Attachment
image002.jpg (492 bytes) Download Attachment
image003.jpg (454 bytes) Download Attachment
003-array_formula.xlsx (29K) Download Attachment
004-lookup_kiri_kanan.xlsx (23K) Download Attachment
005-unique_sort_list_count_formula.xlsx (33K) Download Attachment
009-rank.xlsx (47K) Download Attachment
010-distribusi.xlsx (13K) Download Attachment
011-IF_dengan_lookup.xlsx (17K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] menghitung remark sesuai kriteria

indria pie
 terima kasih Pak Ade untuk respon cepatnya
saya akan coba pelajari dulu
salam,pie    Pada Rabu, 23 Januari 2019 15.52.20 WIB, 'M.Ade Alfarid' [hidden email] [belajar-excel] <[hidden email]> menulis:  
 
    


Coba pelajari file dari Mr.kid terlampir

 

ade

 

From: [hidden email] [mailto:[hidden email]]
Sent: Wednesday, January 23, 2019 3:41 PM
To: [hidden email]
Subject: [belajar-excel] menghitung remark sesuai kriteria [1 Attachment]

 

 

salam excel

 

mohon bantuan master-master excel, untuk persoalan kami (terlampir)

 

terima kasih sebelumnya

 

salam,

pie


  #yiv9858275851 #yiv9858275851 -- #yiv9858275851ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9858275851 #yiv9858275851ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9858275851 #yiv9858275851ygrp-mkp #yiv9858275851hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv9858275851 #yiv9858275851ygrp-mkp #yiv9858275851ads {margin-bottom:10px;}#yiv9858275851 #yiv9858275851ygrp-mkp .yiv9858275851ad {padding:0 0;}#yiv9858275851 #yiv9858275851ygrp-mkp .yiv9858275851ad p {margin:0;}#yiv9858275851 #yiv9858275851ygrp-mkp .yiv9858275851ad a {color:#0000ff;text-decoration:none;}#yiv9858275851 #yiv9858275851ygrp-sponsor #yiv9858275851ygrp-lc {font-family:Arial;}#yiv9858275851 #yiv9858275851ygrp-sponsor #yiv9858275851ygrp-lc #yiv9858275851hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9858275851 #yiv9858275851ygrp-sponsor #yiv9858275851ygrp-lc .yiv9858275851ad {margin-bottom:10px;padding:0 0;}#yiv9858275851 #yiv9858275851actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9858275851 #yiv9858275851activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9858275851 #yiv9858275851activity span {font-weight:700;}#yiv9858275851 #yiv9858275851activity span:first-child {text-transform:uppercase;}#yiv9858275851 #yiv9858275851activity span a {color:#5085b6;text-decoration:none;}#yiv9858275851 #yiv9858275851activity span span {color:#ff7900;}#yiv9858275851 #yiv9858275851activity span .yiv9858275851underline {text-decoration:underline;}#yiv9858275851 .yiv9858275851attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv9858275851 .yiv9858275851attach div a {text-decoration:none;}#yiv9858275851 .yiv9858275851attach img {border:none;padding-right:5px;}#yiv9858275851 .yiv9858275851attach label {display:block;margin-bottom:5px;}#yiv9858275851 .yiv9858275851attach label a {text-decoration:none;}#yiv9858275851 blockquote {margin:0 0 0 4px;}#yiv9858275851 .yiv9858275851bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv9858275851 .yiv9858275851bold a {text-decoration:none;}#yiv9858275851 dd.yiv9858275851last p a {font-family:Verdana;font-weight:700;}#yiv9858275851 dd.yiv9858275851last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9858275851 dd.yiv9858275851last p span.yiv9858275851yshortcuts {margin-right:0;}#yiv9858275851 div.yiv9858275851attach-table div div a {text-decoration:none;}#yiv9858275851 div.yiv9858275851attach-table {width:400px;}#yiv9858275851 div.yiv9858275851file-title a, #yiv9858275851 div.yiv9858275851file-title a:active, #yiv9858275851 div.yiv9858275851file-title a:hover, #yiv9858275851 div.yiv9858275851file-title a:visited {text-decoration:none;}#yiv9858275851 div.yiv9858275851photo-title a, #yiv9858275851 div.yiv9858275851photo-title a:active, #yiv9858275851 div.yiv9858275851photo-title a:hover, #yiv9858275851 div.yiv9858275851photo-title a:visited {text-decoration:none;}#yiv9858275851 div#yiv9858275851ygrp-mlmsg #yiv9858275851ygrp-msg p a span.yiv9858275851yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9858275851 .yiv9858275851green {color:#628c2a;}#yiv9858275851 .yiv9858275851MsoNormal {margin:0 0 0 0;}#yiv9858275851 o {font-size:0;}#yiv9858275851 #yiv9858275851photos div {float:left;width:72px;}#yiv9858275851 #yiv9858275851photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv9858275851 #yiv9858275851photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9858275851 #yiv9858275851reco-category {font-size:77%;}#yiv9858275851 #yiv9858275851reco-desc {font-size:77%;}#yiv9858275851 .yiv9858275851replbq {margin:4px;}#yiv9858275851 #yiv9858275851ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv9858275851 #yiv9858275851ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9858275851 #yiv9858275851ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9858275851 #yiv9858275851ygrp-mlmsg select, #yiv9858275851 input, #yiv9858275851 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv9858275851 #yiv9858275851ygrp-mlmsg pre, #yiv9858275851 code {font:115% monospace;}#yiv9858275851 #yiv9858275851ygrp-mlmsg * {line-height:1.22em;}#yiv9858275851 #yiv9858275851ygrp-mlmsg #yiv9858275851logo {padding-bottom:10px;}#yiv9858275851 #yiv9858275851ygrp-msg p a {font-family:Verdana;}#yiv9858275851 #yiv9858275851ygrp-msg p#yiv9858275851attach-count span {color:#1E66AE;font-weight:700;}#yiv9858275851 #yiv9858275851ygrp-reco #yiv9858275851reco-head {color:#ff7900;font-weight:700;}#yiv9858275851 #yiv9858275851ygrp-reco {margin-bottom:20px;padding:0px;}#yiv9858275851 #yiv9858275851ygrp-sponsor #yiv9858275851ov li a {font-size:130%;text-decoration:none;}#yiv9858275851 #yiv9858275851ygrp-sponsor #yiv9858275851ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv9858275851 #yiv9858275851ygrp-sponsor #yiv9858275851ov ul {margin:0;padding:0 0 0 8px;}#yiv9858275851 #yiv9858275851ygrp-text {font-family:Georgia;}#yiv9858275851 #yiv9858275851ygrp-text p {margin:0 0 1em 0;}#yiv9858275851 #yiv9858275851ygrp-text tt {font-size:120%;}#yiv9858275851 #yiv9858275851ygrp-vital ul li:last-child {border-right:none !important;}#yiv9858275851  
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] menghitung remark sesuai kriteria [1 Attachment]

Ghery Yen-2
In reply to this post by indria pie
السَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ
Semangat pagi,.
Pertanyaan :

Mohon bantuan master excel, bagaimana menghitung jumlah data di J2,
jika kolom kolom I adalah tanggal yang dimaksud, kolom J1 adalah MP
maka kolom J2 akan terisi 4

Begitu selanjutnya untuk BP, WH, S, IDL


*Sepertinya ada yang kurang deh mba, mungkin lupa dituliskalau Remark
nya tidak Blank gitu ya ?!* Berikut tanggapannya ...


terima kasih sebelumnya



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


On Wed, 23 Jan 2019 at 15:42, indria pie [hidden email]
[belajar-excel] <[hidden email]> wrote:

>
>
> salam excel
>
> mohon bantuan master-master excel, untuk persoalan kami (terlampir)
>
> terima kasih sebelumnya
>
> salam,
> pie
>
>
>

REMARK 19 TEST - Edited Heri.xlsx (17K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] menghitung remark sesuai kriteria

indria pie
 Waalaikumsalam Pak Hery
terima kasih koreksinya, betul jika kolom remark tidak blank heeee
arti simbol "<"&">"" itu apa ya?ko petik paling belakang ada 2
mohon dijelaskan bahasa manusianya, biar ngga gagal paham
terima kasih
wassalamualaikum
pie
    Pada Kamis, 24 Januari 2019 09.49.06 WIB, Ghery Yen [hidden email] [belajar-excel] <[hidden email]> menulis:  
 
    


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

Pertanyaan :

Mohon bantuan master excel, bagaimana menghitung jumlah data di J2,
jika kolom kolom I adalah tanggal yang dimaksud, kolom J1 adalah MP maka kolom J2 akan terisi 4

Begitu selanjutnya untuk BP, WH, S, IDL

Sepertinya ada yang kurang deh mba, mungkin lupa ditulis
kalau Remark nya tidak Blank gitu ya ?! Berikut tanggapannya ...


terima kasih sebelumnya



وَالسَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ
On Wed, 23 Jan 2019 at 15:42, indria pie [hidden email] [belajar-excel] <[hidden email]> wrote:

    

salam excel
mohon bantuan master-master excel, untuk persoalan kami (terlampir)
terima kasih sebelumnya
salam,pie

   
  #yiv4937556255 #yiv4937556255 -- #yiv4937556255ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4937556255 #yiv4937556255ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4937556255 #yiv4937556255ygrp-mkp #yiv4937556255hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv4937556255 #yiv4937556255ygrp-mkp #yiv4937556255ads {margin-bottom:10px;}#yiv4937556255 #yiv4937556255ygrp-mkp .yiv4937556255ad {padding:0 0;}#yiv4937556255 #yiv4937556255ygrp-mkp .yiv4937556255ad p {margin:0;}#yiv4937556255 #yiv4937556255ygrp-mkp .yiv4937556255ad a {color:#0000ff;text-decoration:none;}#yiv4937556255 #yiv4937556255ygrp-sponsor #yiv4937556255ygrp-lc {font-family:Arial;}#yiv4937556255 #yiv4937556255ygrp-sponsor #yiv4937556255ygrp-lc #yiv4937556255hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4937556255 #yiv4937556255ygrp-sponsor #yiv4937556255ygrp-lc .yiv4937556255ad {margin-bottom:10px;padding:0 0;}#yiv4937556255 #yiv4937556255actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4937556255 #yiv4937556255activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4937556255 #yiv4937556255activity span {font-weight:700;}#yiv4937556255 #yiv4937556255activity span:first-child {text-transform:uppercase;}#yiv4937556255 #yiv4937556255activity span a {color:#5085b6;text-decoration:none;}#yiv4937556255 #yiv4937556255activity span span {color:#ff7900;}#yiv4937556255 #yiv4937556255activity span .yiv4937556255underline {text-decoration:underline;}#yiv4937556255 .yiv4937556255attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv4937556255 .yiv4937556255attach div a {text-decoration:none;}#yiv4937556255 .yiv4937556255attach img {border:none;padding-right:5px;}#yiv4937556255 .yiv4937556255attach label {display:block;margin-bottom:5px;}#yiv4937556255 .yiv4937556255attach label a {text-decoration:none;}#yiv4937556255 blockquote {margin:0 0 0 4px;}#yiv4937556255 .yiv4937556255bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv4937556255 .yiv4937556255bold a {text-decoration:none;}#yiv4937556255 dd.yiv4937556255last p a {font-family:Verdana;font-weight:700;}#yiv4937556255 dd.yiv4937556255last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4937556255 dd.yiv4937556255last p span.yiv4937556255yshortcuts {margin-right:0;}#yiv4937556255 div.yiv4937556255attach-table div div a {text-decoration:none;}#yiv4937556255 div.yiv4937556255attach-table {width:400px;}#yiv4937556255 div.yiv4937556255file-title a, #yiv4937556255 div.yiv4937556255file-title a:active, #yiv4937556255 div.yiv4937556255file-title a:hover, #yiv4937556255 div.yiv4937556255file-title a:visited {text-decoration:none;}#yiv4937556255 div.yiv4937556255photo-title a, #yiv4937556255 div.yiv4937556255photo-title a:active, #yiv4937556255 div.yiv4937556255photo-title a:hover, #yiv4937556255 div.yiv4937556255photo-title a:visited {text-decoration:none;}#yiv4937556255 div#yiv4937556255ygrp-mlmsg #yiv4937556255ygrp-msg p a span.yiv4937556255yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4937556255 .yiv4937556255green {color:#628c2a;}#yiv4937556255 .yiv4937556255MsoNormal {margin:0 0 0 0;}#yiv4937556255 o {font-size:0;}#yiv4937556255 #yiv4937556255photos div {float:left;width:72px;}#yiv4937556255 #yiv4937556255photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv4937556255 #yiv4937556255photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4937556255 #yiv4937556255reco-category {font-size:77%;}#yiv4937556255 #yiv4937556255reco-desc {font-size:77%;}#yiv4937556255 .yiv4937556255replbq {margin:4px;}#yiv4937556255 #yiv4937556255ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv4937556255 #yiv4937556255ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4937556255 #yiv4937556255ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4937556255 #yiv4937556255ygrp-mlmsg select, #yiv4937556255 input, #yiv4937556255 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv4937556255 #yiv4937556255ygrp-mlmsg pre, #yiv4937556255 code {font:115% monospace;}#yiv4937556255 #yiv4937556255ygrp-mlmsg * {line-height:1.22em;}#yiv4937556255 #yiv4937556255ygrp-mlmsg #yiv4937556255logo {padding-bottom:10px;}#yiv4937556255 #yiv4937556255ygrp-msg p a {font-family:Verdana;}#yiv4937556255 #yiv4937556255ygrp-msg p#yiv4937556255attach-count span {color:#1E66AE;font-weight:700;}#yiv4937556255 #yiv4937556255ygrp-reco #yiv4937556255reco-head {color:#ff7900;font-weight:700;}#yiv4937556255 #yiv4937556255ygrp-reco {margin-bottom:20px;padding:0px;}#yiv4937556255 #yiv4937556255ygrp-sponsor #yiv4937556255ov li a {font-size:130%;text-decoration:none;}#yiv4937556255 #yiv4937556255ygrp-sponsor #yiv4937556255ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv4937556255 #yiv4937556255ygrp-sponsor #yiv4937556255ov ul {margin:0;padding:0 0 0 8px;}#yiv4937556255 #yiv4937556255ygrp-text {font-family:Georgia;}#yiv4937556255 #yiv4937556255ygrp-text p {margin:0 0 1em 0;}#yiv4937556255 #yiv4937556255ygrp-text tt {font-size:120%;}#yiv4937556255 #yiv4937556255ygrp-vital ul li:last-child {border-right:none !important;}#yiv4937556255