[belajar-excel] Formula atau VB untuk proses data

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

[belajar-excel] Formula atau VB untuk proses data

Bayu Prasaja
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

Data.rar (16K) Download Attachment
Kid
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Formula atau VB untuk proses data

Kid
Administrator
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 wb
Kid






On Sun, Jul 28, 2019 at 4:32 PM Bayu Prasaja [hidden email]
[belajar-excel] <[hidden email]> 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
> <https://go.onelink.me/107872968?pid=InProduct&c=Global_Internal_YGrowth_AndroidEmailSig__AndroidUsers&af_wl=ym&af_sub1=Internal&af_sub2=Global_YGrowth&af_sub3=EmailSignature>
>
>
>

re-Data.xlsx (24K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Formula atau VB untuk proses data

Bayu Prasaja
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' [hidden email] [belajar-excel]<[hidden email]> 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 [hidden email] [belajar-excel] <[hidden email]> 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