Maaf om kid Maksudnya gmna yaaa om kid. Maklum newbie. Hehe
Dikirim dari Yahoo Mail di Android
Pada Rab, 19 Apr 2017 pada 22:00 PM, 'Mr. Kid' mr.nm...@gmail.com
[belajar-excel]<belajar-excel@yahoogroups.com> menulis:
Kalau data dikumpulkan dalam 1 sheet lalu dibuat output sheet 1,2,3 dst sampai
buku besar gimana?Jadi pengennya kantor tetap terpenuhi bukan?
Sent from my smart enough phone
On Apr 19, 2017, at 21:42, Fahmi Syaifullah fahmisyaifulla...@yahoo.com
[belajar-excel] <belajar-excel@yahoogroups.com> wrote:
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
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>
#yiv7915011119 #yiv7915011119 -- #yiv7915011119ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7915011119
#yiv7915011119ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7915011119
#yiv7915011119ygrp-mkp #yiv7915011119hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv7915011119 #yiv7915011119ygrp-mkp #yiv7915011119ads
{margin-bottom:10px;}#yiv7915011119 #yiv7915011119ygrp-mkp .yiv7915011119ad
{padding:0 0;}#yiv7915011119 #yiv7915011119ygrp-mkp .yiv7915011119ad p
{margin:0;}#yiv7915011119 #yiv7915011119ygrp-mkp .yiv7915011119ad a
{color:#0000ff;text-decoration:none;}#yiv7915011119 #yiv7915011119ygrp-sponsor
#yiv7915011119ygrp-lc {font-family:Arial;}#yiv7915011119
#yiv7915011119ygrp-sponsor #yiv7915011119ygrp-lc #yiv7915011119hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7915011119
#yiv7915011119ygrp-sponsor #yiv7915011119ygrp-lc .yiv7915011119ad
{margin-bottom:10px;padding:0 0;}#yiv7915011119 #yiv7915011119actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7915011119
#yiv7915011119activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7915011119
#yiv7915011119activity span {font-weight:700;}#yiv7915011119
#yiv7915011119activity span:first-child
{text-transform:uppercase;}#yiv7915011119 #yiv7915011119activity span a
{color:#5085b6;text-decoration:none;}#yiv7915011119 #yiv7915011119activity span
span {color:#ff7900;}#yiv7915011119 #yiv7915011119activity span
.yiv7915011119underline {text-decoration:underline;}#yiv7915011119
.yiv7915011119attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv7915011119 .yiv7915011119attach div a
{text-decoration:none;}#yiv7915011119 .yiv7915011119attach img
{border:none;padding-right:5px;}#yiv7915011119 .yiv7915011119attach label
{display:block;margin-bottom:5px;}#yiv7915011119 .yiv7915011119attach label a
{text-decoration:none;}#yiv7915011119 blockquote {margin:0 0 0
4px;}#yiv7915011119 .yiv7915011119bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7915011119
.yiv7915011119bold a {text-decoration:none;}#yiv7915011119 dd.yiv7915011119last
p a {font-family:Verdana;font-weight:700;}#yiv7915011119 dd.yiv7915011119last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7915011119
dd.yiv7915011119last p span.yiv7915011119yshortcuts
{margin-right:0;}#yiv7915011119 div.yiv7915011119attach-table div div a
{text-decoration:none;}#yiv7915011119 div.yiv7915011119attach-table
{width:400px;}#yiv7915011119 div.yiv7915011119file-title a, #yiv7915011119
div.yiv7915011119file-title a:active, #yiv7915011119
div.yiv7915011119file-title a:hover, #yiv7915011119 div.yiv7915011119file-title
a:visited {text-decoration:none;}#yiv7915011119 div.yiv7915011119photo-title a,
#yiv7915011119 div.yiv7915011119photo-title a:active, #yiv7915011119
div.yiv7915011119photo-title a:hover, #yiv7915011119
div.yiv7915011119photo-title a:visited {text-decoration:none;}#yiv7915011119
div#yiv7915011119ygrp-mlmsg #yiv7915011119ygrp-msg p a
span.yiv7915011119yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7915011119
.yiv7915011119green {color:#628c2a;}#yiv7915011119 .yiv7915011119MsoNormal
{margin:0 0 0 0;}#yiv7915011119 o {font-size:0;}#yiv7915011119
#yiv7915011119photos div {float:left;width:72px;}#yiv7915011119
#yiv7915011119photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv7915011119
#yiv7915011119photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7915011119
#yiv7915011119reco-category {font-size:77%;}#yiv7915011119
#yiv7915011119reco-desc {font-size:77%;}#yiv7915011119 .yiv7915011119replbq
{margin:4px;}#yiv7915011119 #yiv7915011119ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv7915011119 #yiv7915011119ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7915011119
#yiv7915011119ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7915011119
#yiv7915011119ygrp-mlmsg select, #yiv7915011119 input, #yiv7915011119 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv7915011119
#yiv7915011119ygrp-mlmsg pre, #yiv7915011119 code {font:115%
monospace;}#yiv7915011119 #yiv7915011119ygrp-mlmsg *
{line-height:1.22em;}#yiv7915011119 #yiv7915011119ygrp-mlmsg #yiv7915011119logo
{padding-bottom:10px;}#yiv7915011119 #yiv7915011119ygrp-msg p a
{font-family:Verdana;}#yiv7915011119 #yiv7915011119ygrp-msg
p#yiv7915011119attach-count span {color:#1E66AE;font-weight:700;}#yiv7915011119
#yiv7915011119ygrp-reco #yiv7915011119reco-head
{color:#ff7900;font-weight:700;}#yiv7915011119 #yiv7915011119ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv7915011119 #yiv7915011119ygrp-sponsor
#yiv7915011119ov li a {font-size:130%;text-decoration:none;}#yiv7915011119
#yiv7915011119ygrp-sponsor #yiv7915011119ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv7915011119
#yiv7915011119ygrp-sponsor #yiv7915011119ov ul {margin:0;padding:0 0 0
8px;}#yiv7915011119 #yiv7915011119ygrp-text
{font-family:Georgia;}#yiv7915011119 #yiv7915011119ygrp-text p {margin:0 0 1em
0;}#yiv7915011119 #yiv7915011119ygrp-text tt {font-size:120%;}#yiv7915011119
#yiv7915011119ygrp-vital ul li:last-child {border-right:none
!important;}#yiv7915011119
