Jazakallahu Khaitan Mr. Kid, maaf baru di bales, soalnya saya pelajari dlu satu2 formulanya hehe
Sent from Yahoo Mail on Android On Mon, 29 Jul 2019 at 10:49, 'Mr. Kid' [email protected] [belajar-excel]<[email protected]> wrote: Wa'alaikumussalam wr wb Pakai kolom bantu ya, supaya beban komputasi tidak berat.Kalau sudah pakai xl2019 yang punya fungsi MinIFs dan MaxIFs, formula bisa lebih sederhana. Wassalamu'alaikum wr wbKid On Sun, Jul 28, 2019 at 4:32 PM Bayu Prasaja [email protected] [belajar-excel] <[email protected]> wrote: Assalamu'alaikum para master, mohon maaf nih mau ngerepotin, saya mempunyai permasalahan untuk membuat prosesing data, solusinya bisa berbentuk formula atau VB, dikarenakan saya masih baru belajar, alangkah lebih baik penjelasan nya saya sertskan di attatchment, Terima kasih sebelumnya Sent from Yahoo Mail on Android #yiv7960404466 #yiv7960404466 -- #yiv7960404466ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7960404466 #yiv7960404466ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7960404466 #yiv7960404466ygrp-mkp #yiv7960404466hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7960404466 #yiv7960404466ygrp-mkp #yiv7960404466ads {margin-bottom:10px;}#yiv7960404466 #yiv7960404466ygrp-mkp .yiv7960404466ad {padding:0 0;}#yiv7960404466 #yiv7960404466ygrp-mkp .yiv7960404466ad p {margin:0;}#yiv7960404466 #yiv7960404466ygrp-mkp .yiv7960404466ad a {color:#0000ff;text-decoration:none;}#yiv7960404466 #yiv7960404466ygrp-sponsor #yiv7960404466ygrp-lc {font-family:Arial;}#yiv7960404466 #yiv7960404466ygrp-sponsor #yiv7960404466ygrp-lc #yiv7960404466hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7960404466 #yiv7960404466ygrp-sponsor #yiv7960404466ygrp-lc .yiv7960404466ad {margin-bottom:10px;padding:0 0;}#yiv7960404466 #yiv7960404466actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7960404466 #yiv7960404466activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7960404466 #yiv7960404466activity span {font-weight:700;}#yiv7960404466 #yiv7960404466activity span:first-child {text-transform:uppercase;}#yiv7960404466 #yiv7960404466activity span a {color:#5085b6;text-decoration:none;}#yiv7960404466 #yiv7960404466activity span span {color:#ff7900;}#yiv7960404466 #yiv7960404466activity span .yiv7960404466underline {text-decoration:underline;}#yiv7960404466 .yiv7960404466attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7960404466 .yiv7960404466attach div a {text-decoration:none;}#yiv7960404466 .yiv7960404466attach img {border:none;padding-right:5px;}#yiv7960404466 .yiv7960404466attach label {display:block;margin-bottom:5px;}#yiv7960404466 .yiv7960404466attach label a {text-decoration:none;}#yiv7960404466 blockquote {margin:0 0 0 4px;}#yiv7960404466 .yiv7960404466bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7960404466 .yiv7960404466bold a {text-decoration:none;}#yiv7960404466 dd.yiv7960404466last p a {font-family:Verdana;font-weight:700;}#yiv7960404466 dd.yiv7960404466last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7960404466 dd.yiv7960404466last p span.yiv7960404466yshortcuts {margin-right:0;}#yiv7960404466 div.yiv7960404466attach-table div div a {text-decoration:none;}#yiv7960404466 div.yiv7960404466attach-table {width:400px;}#yiv7960404466 div.yiv7960404466file-title a, #yiv7960404466 div.yiv7960404466file-title a:active, #yiv7960404466 div.yiv7960404466file-title a:hover, #yiv7960404466 div.yiv7960404466file-title a:visited {text-decoration:none;}#yiv7960404466 div.yiv7960404466photo-title a, #yiv7960404466 div.yiv7960404466photo-title a:active, #yiv7960404466 div.yiv7960404466photo-title a:hover, #yiv7960404466 div.yiv7960404466photo-title a:visited {text-decoration:none;}#yiv7960404466 div#yiv7960404466ygrp-mlmsg #yiv7960404466ygrp-msg p a span.yiv7960404466yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7960404466 .yiv7960404466green {color:#628c2a;}#yiv7960404466 .yiv7960404466MsoNormal {margin:0 0 0 0;}#yiv7960404466 o {font-size:0;}#yiv7960404466 #yiv7960404466photos div {float:left;width:72px;}#yiv7960404466 #yiv7960404466photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv7960404466 #yiv7960404466photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7960404466 #yiv7960404466reco-category {font-size:77%;}#yiv7960404466 #yiv7960404466reco-desc {font-size:77%;}#yiv7960404466 .yiv7960404466replbq {margin:4px;}#yiv7960404466 #yiv7960404466ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv7960404466 #yiv7960404466ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7960404466 #yiv7960404466ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7960404466 #yiv7960404466ygrp-mlmsg select, #yiv7960404466 input, #yiv7960404466 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv7960404466 #yiv7960404466ygrp-mlmsg pre, #yiv7960404466 code {font:115% monospace;}#yiv7960404466 #yiv7960404466ygrp-mlmsg * {line-height:1.22em;}#yiv7960404466 #yiv7960404466ygrp-mlmsg #yiv7960404466logo {padding-bottom:10px;}#yiv7960404466 #yiv7960404466ygrp-msg p a {font-family:Verdana;}#yiv7960404466 #yiv7960404466ygrp-msg p#yiv7960404466attach-count span {color:#1E66AE;font-weight:700;}#yiv7960404466 #yiv7960404466ygrp-reco #yiv7960404466reco-head {color:#ff7900;font-weight:700;}#yiv7960404466 #yiv7960404466ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7960404466 #yiv7960404466ygrp-sponsor #yiv7960404466ov li a {font-size:130%;text-decoration:none;}#yiv7960404466 #yiv7960404466ygrp-sponsor #yiv7960404466ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7960404466 #yiv7960404466ygrp-sponsor #yiv7960404466ov ul {margin:0;padding:0 0 0 8px;}#yiv7960404466 #yiv7960404466ygrp-text {font-family:Georgia;}#yiv7960404466 #yiv7960404466ygrp-text p {margin:0 0 1em 0;}#yiv7960404466 #yiv7960404466ygrp-text tt {font-size:120%;}#yiv7960404466 #yiv7960404466ygrp-vital ul li:last-child {border-right:none !important;}#yiv7960404466
