Dear Pak Susilo, Mohon maaf pak saya kurang memahami karena pengetahuan saya belum sampai kesitu. apakah ada contoh lain yang bisa saya bandingkan untuk pengambilan2 Row terkait? karena saya coba membuat sendiri dengan data yang sudah dicontohkan diatas namun hasilnya tidak terspesifikasi untuk "Belum Lunas", berikut hasil saya mencoba. dan mohon diperbaiki untuk penulisannya (Fill Warna Orange di Sheet 'Total Pengeluaran dan Pemasukan') TerimakasihFiky Alannuari
Pada Rabu, 9 November 2016 10:05, "Susilo - [email protected]
[belajar-excel]" <[email protected]> menulis:
Dear Fikri alan
Untuk mencari nama "BELUM LUNAS" saya menggunakan Index Match dengan
ArrayRumusnya saya kondisikan untuk 1000 baris, jika ingin ditambahkan silakan
dimodifikasi sendiriSilakan merujuk pada attachment file berikut
Terima kasihSusilo
Pada 8 November 2016 20.47, Fiky Alannuari [email protected]
[belajar-excel] <[email protected]> menulis:
Dear Para Pembimbing,
Saya Fiky Alannuari, sekarang lagi dalam masa penasaran dengan berbagai macam
rumus di Excel, namun saya mencoba tutorial dari google dengan masalah saya ini
tapi saya tidak menemukan solusinya.
Mungkin bisa saya mendapatkan arahan untuk masalah ini?Terlampir data Excel
saya, semoga saya mendapatkan ilmu dan para pembimbing mendapatkan pahala
lebih. Amin
Terimakasih sebelumnya,Regards,
Fiky Alannuari
#yiv0033575892 -- #yiv0033575892ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0033575892
#yiv0033575892ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0033575892
#yiv0033575892ygrp-mkp #yiv0033575892hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv0033575892 #yiv0033575892ygrp-mkp #yiv0033575892ads
{margin-bottom:10px;}#yiv0033575892 #yiv0033575892ygrp-mkp .yiv0033575892ad
{padding:0 0;}#yiv0033575892 #yiv0033575892ygrp-mkp .yiv0033575892ad p
{margin:0;}#yiv0033575892 #yiv0033575892ygrp-mkp .yiv0033575892ad a
{color:#0000ff;text-decoration:none;}#yiv0033575892 #yiv0033575892ygrp-sponsor
#yiv0033575892ygrp-lc {font-family:Arial;}#yiv0033575892
#yiv0033575892ygrp-sponsor #yiv0033575892ygrp-lc #yiv0033575892hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0033575892
#yiv0033575892ygrp-sponsor #yiv0033575892ygrp-lc .yiv0033575892ad
{margin-bottom:10px;padding:0 0;}#yiv0033575892 #yiv0033575892actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0033575892
#yiv0033575892activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0033575892
#yiv0033575892activity span {font-weight:700;}#yiv0033575892
#yiv0033575892activity span:first-child
{text-transform:uppercase;}#yiv0033575892 #yiv0033575892activity span a
{color:#5085b6;text-decoration:none;}#yiv0033575892 #yiv0033575892activity span
span {color:#ff7900;}#yiv0033575892 #yiv0033575892activity span
.yiv0033575892underline {text-decoration:underline;}#yiv0033575892
.yiv0033575892attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv0033575892 .yiv0033575892attach div a
{text-decoration:none;}#yiv0033575892 .yiv0033575892attach img
{border:none;padding-right:5px;}#yiv0033575892 .yiv0033575892attach label
{display:block;margin-bottom:5px;}#yiv0033575892 .yiv0033575892attach label a
{text-decoration:none;}#yiv0033575892 blockquote {margin:0 0 0
4px;}#yiv0033575892 .yiv0033575892bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv0033575892
.yiv0033575892bold a {text-decoration:none;}#yiv0033575892 dd.yiv0033575892last
p a {font-family:Verdana;font-weight:700;}#yiv0033575892 dd.yiv0033575892last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0033575892
dd.yiv0033575892last p span.yiv0033575892yshortcuts
{margin-right:0;}#yiv0033575892 div.yiv0033575892attach-table div div a
{text-decoration:none;}#yiv0033575892 div.yiv0033575892attach-table
{width:400px;}#yiv0033575892 div.yiv0033575892file-title a, #yiv0033575892
div.yiv0033575892file-title a:active, #yiv0033575892
div.yiv0033575892file-title a:hover, #yiv0033575892 div.yiv0033575892file-title
a:visited {text-decoration:none;}#yiv0033575892 div.yiv0033575892photo-title a,
#yiv0033575892 div.yiv0033575892photo-title a:active, #yiv0033575892
div.yiv0033575892photo-title a:hover, #yiv0033575892
div.yiv0033575892photo-title a:visited {text-decoration:none;}#yiv0033575892
div#yiv0033575892ygrp-mlmsg #yiv0033575892ygrp-msg p a
span.yiv0033575892yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0033575892
.yiv0033575892green {color:#628c2a;}#yiv0033575892 .yiv0033575892MsoNormal
{margin:0 0 0 0;}#yiv0033575892 o {font-size:0;}#yiv0033575892
#yiv0033575892photos div {float:left;width:72px;}#yiv0033575892
#yiv0033575892photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv0033575892
#yiv0033575892photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0033575892
#yiv0033575892reco-category {font-size:77%;}#yiv0033575892
#yiv0033575892reco-desc {font-size:77%;}#yiv0033575892 .yiv0033575892replbq
{margin:4px;}#yiv0033575892 #yiv0033575892ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv0033575892 #yiv0033575892ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0033575892
#yiv0033575892ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0033575892
#yiv0033575892ygrp-mlmsg select, #yiv0033575892 input, #yiv0033575892 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv0033575892
#yiv0033575892ygrp-mlmsg pre, #yiv0033575892 code {font:115%
monospace;}#yiv0033575892 #yiv0033575892ygrp-mlmsg *
{line-height:1.22em;}#yiv0033575892 #yiv0033575892ygrp-mlmsg #yiv0033575892logo
{padding-bottom:10px;}#yiv0033575892 #yiv0033575892ygrp-msg p a
{font-family:Verdana;}#yiv0033575892 #yiv0033575892ygrp-msg
p#yiv0033575892attach-count span {color:#1E66AE;font-weight:700;}#yiv0033575892
#yiv0033575892ygrp-reco #yiv0033575892reco-head
{color:#ff7900;font-weight:700;}#yiv0033575892 #yiv0033575892ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv0033575892 #yiv0033575892ygrp-sponsor
#yiv0033575892ov li a {font-size:130%;text-decoration:none;}#yiv0033575892
#yiv0033575892ygrp-sponsor #yiv0033575892ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv0033575892
#yiv0033575892ygrp-sponsor #yiv0033575892ov ul {margin:0;padding:0 0 0
8px;}#yiv0033575892 #yiv0033575892ygrp-text
{font-family:Georgia;}#yiv0033575892 #yiv0033575892ygrp-text p {margin:0 0 1em
0;}#yiv0033575892 #yiv0033575892ygrp-text tt {font-size:120%;}#yiv0033575892
#yiv0033575892ygrp-vital ul li:last-child {border-right:none
!important;}#yiv0033575892
Pembukuan Penjualan Barang.xlsx
Description: MS-Excel 2007 spreadsheet
