Wa'alaikumsalam wr.wb master kid
itu tanggal yg disesuaikan sama bulan om kid. Jadi setiap bulan beda workbook.
Pengennya sih 1 sheet cuman kantor mntanya persheet jadi harus muter otak
lagi.ini saja proses calculatingnya lemot sekali karna sum dgn if bererot om
kid..Mohon bantuannya om kid.
Terima kasihWassalamu'alaikumwr.wbfahmi
Dikirim dari Yahoo Mail di Android
Pada Rab, 19 Apr 2017 pada 21:22 PM, 'Mr. Kid' mr.nm...@gmail.com
[belajar-excel]<belajar-excel@yahoogroups.com> menulis:
Wa'alaikumussalam wr wbHai Fahmi,
Sheet 1,2,3 itu apa ya?Kenapa sheet 1,2,3 tersebut tidak dijadikan 1 sheet,
misal bernama sheet data?
Wassalamu'alaikum wr wbKid
Sent from my smart enough phone
On Apr 19, 2017, at 20:42, Fahmi Syaifullah fahmisyaifulla...@yahoo.com
[belajar-excel] <belajar-excel@yahoogroups.com> wrote:
assalamu'alaikum wr.wb
be'exceller
saya membuat rumus if yang ada di sheet buku besar, sepertinya tidak effisien
dengan penggunaan if karna kalau sheetnya ada 31 (sesuai bulan) maka akan bikin
31 if yang merujuk ke keseluruhan sheetnya dan harus manual juga be'exceller.
dan untuk kolom keterangannya (sheet buku besar) jika disalah satu sheet tidak
ditemukan adanya kesamaan maka ""(nulstring) tapi saya ingin nulstringnya itu
di skip. rumus yang saya buat tidak di skip jadi hasilnya bgini => 1,,3,4,,6
(kalau sheetnya itu pertanggal)lebih jelas file saya lampirkanatas perhatian
be'exceller
terima kasihwassalamu'alaikum wr.wbfahmi
<sheet rujukan.xlsx>
#yiv0130871089 #yiv0130871089 -- #yiv0130871089ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0130871089
#yiv0130871089ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0130871089
#yiv0130871089ygrp-mkp #yiv0130871089hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv0130871089 #yiv0130871089ygrp-mkp #yiv0130871089ads
{margin-bottom:10px;}#yiv0130871089 #yiv0130871089ygrp-mkp .yiv0130871089ad
{padding:0 0;}#yiv0130871089 #yiv0130871089ygrp-mkp .yiv0130871089ad p
{margin:0;}#yiv0130871089 #yiv0130871089ygrp-mkp .yiv0130871089ad a
{color:#0000ff;text-decoration:none;}#yiv0130871089 #yiv0130871089ygrp-sponsor
#yiv0130871089ygrp-lc {font-family:Arial;}#yiv0130871089
#yiv0130871089ygrp-sponsor #yiv0130871089ygrp-lc #yiv0130871089hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0130871089
#yiv0130871089ygrp-sponsor #yiv0130871089ygrp-lc .yiv0130871089ad
{margin-bottom:10px;padding:0 0;}#yiv0130871089 #yiv0130871089actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0130871089
#yiv0130871089activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0130871089
#yiv0130871089activity span {font-weight:700;}#yiv0130871089
#yiv0130871089activity span:first-child
{text-transform:uppercase;}#yiv0130871089 #yiv0130871089activity span a
{color:#5085b6;text-decoration:none;}#yiv0130871089 #yiv0130871089activity span
span {color:#ff7900;}#yiv0130871089 #yiv0130871089activity span
.yiv0130871089underline {text-decoration:underline;}#yiv0130871089
.yiv0130871089attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv0130871089 .yiv0130871089attach div a
{text-decoration:none;}#yiv0130871089 .yiv0130871089attach img
{border:none;padding-right:5px;}#yiv0130871089 .yiv0130871089attach label
{display:block;margin-bottom:5px;}#yiv0130871089 .yiv0130871089attach label a
{text-decoration:none;}#yiv0130871089 blockquote {margin:0 0 0
4px;}#yiv0130871089 .yiv0130871089bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv0130871089
.yiv0130871089bold a {text-decoration:none;}#yiv0130871089 dd.yiv0130871089last
p a {font-family:Verdana;font-weight:700;}#yiv0130871089 dd.yiv0130871089last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0130871089
dd.yiv0130871089last p span.yiv0130871089yshortcuts
{margin-right:0;}#yiv0130871089 div.yiv0130871089attach-table div div a
{text-decoration:none;}#yiv0130871089 div.yiv0130871089attach-table
{width:400px;}#yiv0130871089 div.yiv0130871089file-title a, #yiv0130871089
div.yiv0130871089file-title a:active, #yiv0130871089
div.yiv0130871089file-title a:hover, #yiv0130871089 div.yiv0130871089file-title
a:visited {text-decoration:none;}#yiv0130871089 div.yiv0130871089photo-title a,
#yiv0130871089 div.yiv0130871089photo-title a:active, #yiv0130871089
div.yiv0130871089photo-title a:hover, #yiv0130871089
div.yiv0130871089photo-title a:visited {text-decoration:none;}#yiv0130871089
div#yiv0130871089ygrp-mlmsg #yiv0130871089ygrp-msg p a
span.yiv0130871089yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0130871089
.yiv0130871089green {color:#628c2a;}#yiv0130871089 .yiv0130871089MsoNormal
{margin:0 0 0 0;}#yiv0130871089 o {font-size:0;}#yiv0130871089
#yiv0130871089photos div {float:left;width:72px;}#yiv0130871089
#yiv0130871089photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv0130871089
#yiv0130871089photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0130871089
#yiv0130871089reco-category {font-size:77%;}#yiv0130871089
#yiv0130871089reco-desc {font-size:77%;}#yiv0130871089 .yiv0130871089replbq
{margin:4px;}#yiv0130871089 #yiv0130871089ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv0130871089 #yiv0130871089ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0130871089
#yiv0130871089ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0130871089
#yiv0130871089ygrp-mlmsg select, #yiv0130871089 input, #yiv0130871089 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv0130871089
#yiv0130871089ygrp-mlmsg pre, #yiv0130871089 code {font:115%
monospace;}#yiv0130871089 #yiv0130871089ygrp-mlmsg *
{line-height:1.22em;}#yiv0130871089 #yiv0130871089ygrp-mlmsg #yiv0130871089logo
{padding-bottom:10px;}#yiv0130871089 #yiv0130871089ygrp-msg p a
{font-family:Verdana;}#yiv0130871089 #yiv0130871089ygrp-msg
p#yiv0130871089attach-count span {color:#1E66AE;font-weight:700;}#yiv0130871089
#yiv0130871089ygrp-reco #yiv0130871089reco-head
{color:#ff7900;font-weight:700;}#yiv0130871089 #yiv0130871089ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv0130871089 #yiv0130871089ygrp-sponsor
#yiv0130871089ov li a {font-size:130%;text-decoration:none;}#yiv0130871089
#yiv0130871089ygrp-sponsor #yiv0130871089ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv0130871089
#yiv0130871089ygrp-sponsor #yiv0130871089ov ul {margin:0;padding:0 0 0
8px;}#yiv0130871089 #yiv0130871089ygrp-text
{font-family:Georgia;}#yiv0130871089 #yiv0130871089ygrp-text p {margin:0 0 1em
0;}#yiv0130871089 #yiv0130871089ygrp-text tt {font-size:120%;}#yiv0130871089
#yiv0130871089ygrp-vital ul li:last-child {border-right:none
!important;}#yiv0130871089
