[belajar-excel] Digest Number 3230

Milis Belajar Microsoft Excel Group

3 Messages

Digest #3230

1a

input ppn masukan by "odong nando"

1b

Re: input ppn masukan [1 Attachment] by "hendrik karnadi" hendrikkarnadi

2

Fungsi small dengan sebagian referensi by "Rahasus Pae" rattip25

Messages

1a

input ppn masukan

Wed Dec 17, 2014 10:12 pm (PST) . Posted by:

"odong nando"

dearall,
saya ingin menanyakan tentang bagai
mana penyelesaian untuk penginputan no faktur pajak maka akan otomatis akan keluar
no npwp.

untuk lebih jelas nya tolong lihat lampiran

thx,

odong

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

1b

Re: input ppn masukan [1 Attachment]

Thu Dec 18, 2014 2:17 am (PST) . Posted by:

"hendrik karnadi" hendrikkarnadi

Hai Odong,Sila lihat jawaban terlampir.
Salam,HK
From: "odong nando odongnando@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
To: "belajar-excel@yahoogroups.com" <belajar-excel@yahoogroups.com>
Sent: Thursday, 18 December 2014, 13:10
Subject: [belajar-excel] input ppn masukan [1 Attachment]

 
dearall, saya ingin menanyakan tentang bagaimana penyelesaian untuk penginputan no faktur pajak maka akan otomatis akan keluarno npwp.
untuk lebih jelas nya tolong lihat lampiran

 thx,

odong #yiv7189353196 #yiv7189353196 -- #yiv7189353196ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7189353196 #yiv7189353196ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7189353196 #yiv7189353196ygrp-mkp #yiv7189353196hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7189353196 #yiv7189353196ygrp-mkp #yiv7189353196ads {margin-bottom:10px;}#yiv7189353196 #yiv7189353196ygrp-mkp .yiv7189353196ad {padding:0 0;}#yiv7189353196 #yiv7189353196ygrp-mkp .yiv7189353196ad p {margin:0;}#yiv7189353196 #yiv7189353196ygrp-mkp .yiv7189353196ad a {color:#0000ff;text-decoration:none;}#yiv7189353196 #yiv7189353196ygrp-sponsor #yiv7189353196ygrp-lc {font-family:Arial;}#yiv7189353196 #yiv7189353196ygrp-sponsor #yiv7189353196ygrp-lc #yiv7189353196hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7189353196 #yiv7189353196ygrp-sponsor #yiv7189353196ygrp-lc .yiv7189353196ad {margin-bottom:10px;padding:0 0;}#yiv7189353196 #yiv7189353196actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7189353196 #yiv7189353196activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7189353196 #yiv7189353196activity span {font-weight:700;}#yiv7189353196 #yiv7189353196activity span:first-child {text-transform:uppercase;}#yiv7189353196 #yiv7189353196activity span a {color:#5085b6;text-decoration:none;}#yiv7189353196 #yiv7189353196activity span span {color:#ff7900;}#yiv7189353196 #yiv7189353196activity span .yiv7189353196underline {text-decoration:underline;}#yiv7189353196 .yiv7189353196attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7189353196 .yiv7189353196attach div a {text-decoration:none;}#yiv7189353196 .yiv7189353196attach img {border:none;padding-right:5px;}#yiv7189353196 .yiv7189353196attach label {display:block;margin-bottom:5px;}#yiv7189353196 .yiv7189353196attach label a {text-decoration:none;}#yiv7189353196 blockquote {margin:0 0 0 4px;}#yiv7189353196 .yiv7189353196bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7189353196 .yiv7189353196bold a {text-decoration:none;}#yiv7189353196 dd.yiv7189353196last p a {font-family:Verdana;font-weight:700;}#yiv7189353196 dd.yiv7189353196last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7189353196 dd.yiv7189353196last p span.yiv7189353196yshortcuts {margin-right:0;}#yiv7189353196 div.yiv7189353196attach-table div div a {text-decoration:none;}#yiv7189353196 div.yiv7189353196attach-table {width:400px;}#yiv7189353196 div.yiv7189353196file-title a, #yiv7189353196 div.yiv7189353196file-title a:active, #yiv7189353196 div.yiv7189353196file-title a:hover, #yiv7189353196 div.yiv7189353196file-title a:visited {text-decoration:none;}#yiv7189353196 div.yiv7189353196photo-title a, #yiv7189353196 div.yiv7189353196photo-title a:active, #yiv7189353196 div.yiv7189353196photo-title a:hover, #yiv7189353196 div.yiv7189353196photo-title a:visited {text-decoration:none;}#yiv7189353196 div#yiv7189353196ygrp-mlmsg #yiv7189353196ygrp-msg p a span.yiv7189353196yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7189353196 .yiv7189353196green {color:#628c2a;}#yiv7189353196 .yiv7189353196MsoNormal {margin:0 0 0 0;}#yiv7189353196 o {font-size:0;}#yiv7189353196 #yiv7189353196photos div {float:left;width:72px;}#yiv7189353196 #yiv7189353196photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv7189353196 #yiv7189353196photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7189353196 #yiv7189353196reco-category {font-size:77%;}#yiv7189353196 #yiv7189353196reco-desc {font-size:77%;}#yiv7189353196 .yiv7189353196replbq {margin:4px;}#yiv7189353196 #yiv7189353196ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv7189353196 #yiv7189353196ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7189353196 #yiv7189353196ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7189353196 #yiv7189353196ygrp-mlmsg select, #yiv7189353196 input, #yiv7189353196 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv7189353196 #yiv7189353196ygrp-mlmsg pre, #yiv7189353196 code {font:115% monospace;}#yiv7189353196 #yiv7189353196ygrp-mlmsg * {line-height:1.22em;}#yiv7189353196 #yiv7189353196ygrp-mlmsg #yiv7189353196logo {padding-bottom:10px;}#yiv7189353196 #yiv7189353196ygrp-msg p a {font-family:Verdana;}#yiv7189353196 #yiv7189353196ygrp-msg p#yiv7189353196attach-count span {color:#1E66AE;font-weight:700;}#yiv7189353196 #yiv7189353196ygrp-reco #yiv7189353196reco-head {color:#ff7900;font-weight:700;}#yiv7189353196 #yiv7189353196ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7189353196 #yiv7189353196ygrp-sponsor #yiv7189353196ov li a {font-size:130%;text-decoration:none;}#yiv7189353196 #yiv7189353196ygrp-sponsor #yiv7189353196ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7189353196 #yiv7189353196ygrp-sponsor #yiv7189353196ov ul {margin:0;padding:0 0 0 8px;}#yiv7189353196 #yiv7189353196ygrp-text {font-family:Georgia;}#yiv7189353196 #yiv7189353196ygrp-text p {margin:0 0 1em 0;}#yiv7189353196 #yiv7189353196ygrp-text tt {font-size:120%;}#yiv7189353196 #yiv7189353196ygrp-vital ul li:last-child {border-right:none !important;}#yiv7189353196

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

2

Fungsi small dengan sebagian referensi

Thu Dec 18, 2014 1:30 am (PST) . Posted by:

"Rahasus Pae" rattip25

Dear Be-exceler,

Bagaimana formula small bisa berjalan dengan sebagian reference karena
dengan formula
{=SMALL(IF($M$6=data!$K$2:$K$20,ROW(data!$K$2:$K$20)-ROW(data!$K$1)),ROW()-ROW(A$8))}
tidak
akan ada hasil yang diperoleh.

Misalnya saya mengisikan ref2 cuma dengan YAS-17321931 (ref2 completenya
adalah 126-01972633/YAS-17321931), maka di colom A akan #NUM! daong
munculnya.

Bagaimana cara meformulasikan fungsi small dengan lookup sebagian supaya
diperoleh hasil.

Mohon pencerahan.

Salam,
Rahas

Reply to sender . Reply to group . Reply via Web Post . All Messages (1) . Top ^

============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com

posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com

berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages

melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/

menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com

keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------

Visit Your Group

• New Members 4

• Privacy • Unsubscribe • Terms of Use