Dear Mas Agus, Terima kasih atas responnya.Mohon maaf, tabel yang saya kirimkan salah.Seharusnya No Notanya adalah 181924104.Berikut saya kirimkan kembali.
REgardsketut
On Sunday, 3 March 2019, 5:52:26 pm GMT+8, Agus nanga...@gmail.com
[belajar-excel] <belajar-excel@yahoogroups.com> wrote:
Dear Ketut, Sambil menunggu penjelasan yang lebih lengkap, file terlampir dapat
digunakan untuk pertimbangan Regard NangAgus
On 3/2/2019 10:41, ketut budiasa yudix_ke...@yahoo.com [belajar-excel] wrote:
Dear All,
Minta bantuan untuk menentukan no nota yang sudah dipergunakan. Kita
menggunakan No yang sudah ada no Serinya Tiap Bundle Nota, terdapat 2000 Nota (
berserta no Serinya ) Masing-masing bundle Nota ada kodenya. Setiap hari
penggunakan Nota tidak tentu. Jadi masalah pada saat ada pergantian Bundel Nota
di Pertengahan Hari. Sehingga NO Seri di Nota Berikutnya tidak bisa otomatis.
Mungkin bisa dibantu seprti dalam table berikut
Regards Ketut
#yiv1742439196 #yiv1742439196 -- #yiv1742439196ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1742439196
#yiv1742439196ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1742439196
#yiv1742439196ygrp-mkp #yiv1742439196hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv1742439196 #yiv1742439196ygrp-mkp #yiv1742439196ads
{margin-bottom:10px;}#yiv1742439196 #yiv1742439196ygrp-mkp .yiv1742439196ad
{padding:0 0;}#yiv1742439196 #yiv1742439196ygrp-mkp .yiv1742439196ad p
{margin:0;}#yiv1742439196 #yiv1742439196ygrp-mkp .yiv1742439196ad a
{color:#0000ff;text-decoration:none;}#yiv1742439196 #yiv1742439196ygrp-sponsor
#yiv1742439196ygrp-lc {font-family:Arial;}#yiv1742439196
#yiv1742439196ygrp-sponsor #yiv1742439196ygrp-lc #yiv1742439196hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1742439196
#yiv1742439196ygrp-sponsor #yiv1742439196ygrp-lc .yiv1742439196ad
{margin-bottom:10px;padding:0 0;}#yiv1742439196 #yiv1742439196actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1742439196
#yiv1742439196activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1742439196
#yiv1742439196activity span {font-weight:700;}#yiv1742439196
#yiv1742439196activity span:first-child
{text-transform:uppercase;}#yiv1742439196 #yiv1742439196activity span a
{color:#5085b6;text-decoration:none;}#yiv1742439196 #yiv1742439196activity span
span {color:#ff7900;}#yiv1742439196 #yiv1742439196activity span
.yiv1742439196underline {text-decoration:underline;}#yiv1742439196
.yiv1742439196attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv1742439196 .yiv1742439196attach div a
{text-decoration:none;}#yiv1742439196 .yiv1742439196attach img
{border:none;padding-right:5px;}#yiv1742439196 .yiv1742439196attach label
{display:block;margin-bottom:5px;}#yiv1742439196 .yiv1742439196attach label a
{text-decoration:none;}#yiv1742439196 blockquote {margin:0 0 0
4px;}#yiv1742439196 .yiv1742439196bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv1742439196
.yiv1742439196bold a {text-decoration:none;}#yiv1742439196 dd.yiv1742439196last
p a {font-family:Verdana;font-weight:700;}#yiv1742439196 dd.yiv1742439196last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1742439196
dd.yiv1742439196last p span.yiv1742439196yshortcuts
{margin-right:0;}#yiv1742439196 div.yiv1742439196attach-table div div a
{text-decoration:none;}#yiv1742439196 div.yiv1742439196attach-table
{width:400px;}#yiv1742439196 div.yiv1742439196file-title a, #yiv1742439196
div.yiv1742439196file-title a:active, #yiv1742439196
div.yiv1742439196file-title a:hover, #yiv1742439196 div.yiv1742439196file-title
a:visited {text-decoration:none;}#yiv1742439196 div.yiv1742439196photo-title a,
#yiv1742439196 div.yiv1742439196photo-title a:active, #yiv1742439196
div.yiv1742439196photo-title a:hover, #yiv1742439196
div.yiv1742439196photo-title a:visited {text-decoration:none;}#yiv1742439196
div#yiv1742439196ygrp-mlmsg #yiv1742439196ygrp-msg p a
span.yiv1742439196yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1742439196
.yiv1742439196green {color:#628c2a;}#yiv1742439196 .yiv1742439196MsoNormal
{margin:0 0 0 0;}#yiv1742439196 o {font-size:0;}#yiv1742439196
#yiv1742439196photos div {float:left;width:72px;}#yiv1742439196
#yiv1742439196photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv1742439196
#yiv1742439196photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1742439196
#yiv1742439196reco-category {font-size:77%;}#yiv1742439196
#yiv1742439196reco-desc {font-size:77%;}#yiv1742439196 .yiv1742439196replbq
{margin:4px;}#yiv1742439196 #yiv1742439196ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv1742439196 #yiv1742439196ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1742439196
#yiv1742439196ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1742439196
#yiv1742439196ygrp-mlmsg select, #yiv1742439196 input, #yiv1742439196 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv1742439196
#yiv1742439196ygrp-mlmsg pre, #yiv1742439196 code {font:115%
monospace;}#yiv1742439196 #yiv1742439196ygrp-mlmsg *
{line-height:1.22em;}#yiv1742439196 #yiv1742439196ygrp-mlmsg #yiv1742439196logo
{padding-bottom:10px;}#yiv1742439196 #yiv1742439196ygrp-msg p a
{font-family:Verdana;}#yiv1742439196 #yiv1742439196ygrp-msg
p#yiv1742439196attach-count span {color:#1E66AE;font-weight:700;}#yiv1742439196
#yiv1742439196ygrp-reco #yiv1742439196reco-head
{color:#ff7900;font-weight:700;}#yiv1742439196 #yiv1742439196ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv1742439196 #yiv1742439196ygrp-sponsor
#yiv1742439196ov li a {font-size:130%;text-decoration:none;}#yiv1742439196
#yiv1742439196ygrp-sponsor #yiv1742439196ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv1742439196
#yiv1742439196ygrp-sponsor #yiv1742439196ov ul {margin:0;padding:0 0 0
8px;}#yiv1742439196 #yiv1742439196ygrp-text
{font-family:Georgia;}#yiv1742439196 #yiv1742439196ygrp-text p {margin:0 0 1em
0;}#yiv1742439196 #yiv1742439196ygrp-text tt {font-size:120%;}#yiv1742439196
#yiv1742439196ygrp-vital ul li:last-child {border-right:none
!important;}#yiv1742439196
TABEL PENGGUNAAN NOTA.xlsx
Description: MS-Excel 2007 spreadsheet
