Assalamualaikum wr.wb
Oiya yaa bisa juga seperti itu yaa. Knapa pakai lookup yaa. Hehe.haturnuhun om
kid.. smoga sehat dan berkah deh buat beexceller khususnya om kid.terima
kasih.Hehee
Wassalamu'alaikum wr.wb
Dikirim dari Yahoo Mail di Android
Pada Min, 31 Des 2017 pada 12:09, 'Mr. Kid' mr.nm...@gmail.com
[belajar-excel]<belajar-excel@yahoogroups.com> menulis:
Wa'alaikumussalam wr wb
Hai Fahmi,
misal hasil di kolom H, record mulai baris 2 Excel
=IF(LEN(C2)=0,SUM(C$1:C1)-SUM(H$1:H1),0)
Wassalamu'alaikum wr wb
Kid
2017-12-31 7:01 GMT+07:00 Fahmi Syaifullah fahmisyaifulla...@yahoo.com
[belajar-excel] <belajar-excel@yahoogroups.com>:
assalamu'alaikum wr.wb
selamat pagi agan2 Beexceller.selamat liburan lagi untuk agan2. hehe
mau merepotkan lagi om om maaf.mau tanya penetuan cell kosong . gini :cell ada
cell tanggal keterangan debet kredit dan saldosaya ingin di kolom kredit berisi
nilai atau penumlahan yang adadi kolom cell debet.
maaf beexceler dilihat saja file lampirannya. soalnya sulit di kata2 . saya
sudah membuat rumus lookup tapi kalau dipikir2 tidak efisien dan membutuhkan
banyak look up data ada banyak kalau tidak efisien seperti itu kinerja excel
akan semakin lemot.
mohon bantuannya beexceler.maaf merepotkan beexceller ..
wassalamu'alaikum wr.wb
#yiv2353004683 #yiv2353004683 -- #yiv2353004683ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2353004683
#yiv2353004683ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2353004683
#yiv2353004683ygrp-mkp #yiv2353004683hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv2353004683 #yiv2353004683ygrp-mkp #yiv2353004683ads
{margin-bottom:10px;}#yiv2353004683 #yiv2353004683ygrp-mkp .yiv2353004683ad
{padding:0 0;}#yiv2353004683 #yiv2353004683ygrp-mkp .yiv2353004683ad p
{margin:0;}#yiv2353004683 #yiv2353004683ygrp-mkp .yiv2353004683ad a
{color:#0000ff;text-decoration:none;}#yiv2353004683 #yiv2353004683ygrp-sponsor
#yiv2353004683ygrp-lc {font-family:Arial;}#yiv2353004683
#yiv2353004683ygrp-sponsor #yiv2353004683ygrp-lc #yiv2353004683hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2353004683
#yiv2353004683ygrp-sponsor #yiv2353004683ygrp-lc .yiv2353004683ad
{margin-bottom:10px;padding:0 0;}#yiv2353004683 #yiv2353004683actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2353004683
#yiv2353004683activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2353004683
#yiv2353004683activity span {font-weight:700;}#yiv2353004683
#yiv2353004683activity span:first-child
{text-transform:uppercase;}#yiv2353004683 #yiv2353004683activity span a
{color:#5085b6;text-decoration:none;}#yiv2353004683 #yiv2353004683activity span
span {color:#ff7900;}#yiv2353004683 #yiv2353004683activity span
.yiv2353004683underline {text-decoration:underline;}#yiv2353004683
.yiv2353004683attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv2353004683 .yiv2353004683attach div a
{text-decoration:none;}#yiv2353004683 .yiv2353004683attach img
{border:none;padding-right:5px;}#yiv2353004683 .yiv2353004683attach label
{display:block;margin-bottom:5px;}#yiv2353004683 .yiv2353004683attach label a
{text-decoration:none;}#yiv2353004683 blockquote {margin:0 0 0
4px;}#yiv2353004683 .yiv2353004683bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv2353004683
.yiv2353004683bold a {text-decoration:none;}#yiv2353004683 dd.yiv2353004683last
p a {font-family:Verdana;font-weight:700;}#yiv2353004683 dd.yiv2353004683last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2353004683
dd.yiv2353004683last p span.yiv2353004683yshortcuts
{margin-right:0;}#yiv2353004683 div.yiv2353004683attach-table div div a
{text-decoration:none;}#yiv2353004683 div.yiv2353004683attach-table
{width:400px;}#yiv2353004683 div.yiv2353004683file-title a, #yiv2353004683
div.yiv2353004683file-title a:active, #yiv2353004683
div.yiv2353004683file-title a:hover, #yiv2353004683 div.yiv2353004683file-title
a:visited {text-decoration:none;}#yiv2353004683 div.yiv2353004683photo-title a,
#yiv2353004683 div.yiv2353004683photo-title a:active, #yiv2353004683
div.yiv2353004683photo-title a:hover, #yiv2353004683
div.yiv2353004683photo-title a:visited {text-decoration:none;}#yiv2353004683
div#yiv2353004683ygrp-mlmsg #yiv2353004683ygrp-msg p a
span.yiv2353004683yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2353004683
.yiv2353004683green {color:#628c2a;}#yiv2353004683 .yiv2353004683MsoNormal
{margin:0 0 0 0;}#yiv2353004683 o {font-size:0;}#yiv2353004683
#yiv2353004683photos div {float:left;width:72px;}#yiv2353004683
#yiv2353004683photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv2353004683
#yiv2353004683photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2353004683
#yiv2353004683reco-category {font-size:77%;}#yiv2353004683
#yiv2353004683reco-desc {font-size:77%;}#yiv2353004683 .yiv2353004683replbq
{margin:4px;}#yiv2353004683 #yiv2353004683ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv2353004683 #yiv2353004683ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2353004683
#yiv2353004683ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2353004683
#yiv2353004683ygrp-mlmsg select, #yiv2353004683 input, #yiv2353004683 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv2353004683
#yiv2353004683ygrp-mlmsg pre, #yiv2353004683 code {font:115%
monospace;}#yiv2353004683 #yiv2353004683ygrp-mlmsg *
{line-height:1.22em;}#yiv2353004683 #yiv2353004683ygrp-mlmsg #yiv2353004683logo
{padding-bottom:10px;}#yiv2353004683 #yiv2353004683ygrp-msg p a
{font-family:Verdana;}#yiv2353004683 #yiv2353004683ygrp-msg
p#yiv2353004683attach-count span {color:#1E66AE;font-weight:700;}#yiv2353004683
#yiv2353004683ygrp-reco #yiv2353004683reco-head
{color:#ff7900;font-weight:700;}#yiv2353004683 #yiv2353004683ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv2353004683 #yiv2353004683ygrp-sponsor
#yiv2353004683ov li a {font-size:130%;text-decoration:none;}#yiv2353004683
#yiv2353004683ygrp-sponsor #yiv2353004683ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv2353004683
#yiv2353004683ygrp-sponsor #yiv2353004683ov ul {margin:0;padding:0 0 0
8px;}#yiv2353004683 #yiv2353004683ygrp-text
{font-family:Georgia;}#yiv2353004683 #yiv2353004683ygrp-text p {margin:0 0 1em
0;}#yiv2353004683 #yiv2353004683ygrp-text tt {font-size:120%;}#yiv2353004683
#yiv2353004683ygrp-vital ul li:last-child {border-right:none
!important;}#yiv2353004683
