[belajar-excel] Digest Number 4313

Milis Belajar Microsoft Excel Group

2 Messages

Digest #4313

1a

Bls: [belajar-excel] rumus nomor urut yang loncat-loncat [1 Attachme by "odong nando"

2

Template penjualan konsinyasi by "Harry Acenk Rafke" harry_acenkxx

Messages

1a

Bls: [belajar-excel] rumus nomor urut yang loncat-loncat [1 Attachme

Sun Oct 1, 2017 7:44 pm (PDT) . Posted by:

"odong nando"

hai hita,
formula COUNTIF bisa dimanfaatkan kok..
=COUNTIF($E$2:E2;E2)
copy formula tersebut sampai bawah.bila compi setempat berregional setting english maka ganti titik koma ";" menjadi koma "," br,

odong nando

Dari: "halak hita halakhita1983@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com>
Kepada: belajar-excel@yahoogroups.com
Dikirim: Senin, 2 Oktober 2017 4:53
Judul: [belajar-excel] rumus nomor urut yang loncat-loncat [1 Attachment]

  Selamat malam para Master Excel

Mohon petunjuk bagaimana supaya data saya dalam lampiran ini tetap bisa berurutan mengacu kepada PO yang sama walaupun baris itemnya loncat-loncat

#yiv0452618343 #yiv0452618343 -- #yiv0452618343ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0452618343 #yiv0452618343ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0452618343 #yiv0452618343ygrp-mkp #yiv0452618343hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0452618343 #yiv0452618343ygrp-mkp #yiv0452618343ads {margin-bottom:10px;}#yiv0452618343 #yiv0452618343ygrp-mkp .yiv0452618343ad {padding:0 0;}#yiv0452618343 #yiv0452618343ygrp-mkp .yiv0452618343ad p {margin:0;}#yiv0452618343 #yiv0452618343ygrp-mkp .yiv0452618343ad a {color:#0000ff;text-decoration:none;}#yiv0452618343 #yiv0452618343ygrp-sponsor #yiv0452618343ygrp-lc {font-family:Arial;}#yiv0452618343 #yiv0452618343ygrp-sponsor #yiv0452618343ygrp-lc #yiv0452618343hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0452618343 #yiv0452618343ygrp-sponsor #yiv0452618343ygrp-lc .yiv0452618343ad {margin-bottom:10px;padding:0 0;}#yiv0452618343 #yiv0452618343actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0452618343 #yiv0452618343activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0452618343 #yiv0452618343activity span {font-weight:700;}#yiv0452618343 #yiv0452618343activity span:first-child {text-transform:uppercase;}#yiv0452618343 #yiv0452618343activity span a {color:#5085b6;text-decoration:none;}#yiv0452618343 #yiv0452618343activity span span {color:#ff7900;}#yiv0452618343 #yiv0452618343activity span .yiv0452618343underline {text-decoration:underline;}#yiv0452618343 .yiv0452618343attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0452618343 .yiv0452618343attach div a {text-decoration:none;}#yiv0452618343 .yiv0452618343attach img {border:none;padding-right:5px;}#yiv0452618343 .yiv0452618343attach label {display:block;margin-bottom:5px;}#yiv0452618343 .yiv0452618343attach label a {text-decoration:none;}#yiv0452618343 blockquote {margin:0 0 0 4px;}#yiv0452618343 .yiv0452618343bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0452618343 .yiv0452618343bold a {text-decoration:none;}#yiv0452618343 dd.yiv0452618343last p a {font-family:Verdana;font-weight:700;}#yiv0452618343 dd.yiv0452618343last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0452618343 dd.yiv0452618343last p span.yiv0452618343yshortcuts {margin-right:0;}#yiv0452618343 div.yiv0452618343attach-table div div a {text-decoration:none;}#yiv0452618343 div.yiv0452618343attach-table {width:400px;}#yiv0452618343 div.yiv0452618343file-title a, #yiv0452618343 div.yiv0452618343file-title a:active, #yiv0452618343 div.yiv0452618343file-title a:hover, #yiv0452618343 div.yiv0452618343file-title a:visited {text-decoration:none;}#yiv0452618343 div.yiv0452618343photo-title a, #yiv0452618343 div.yiv0452618343photo-title a:active, #yiv0452618343 div.yiv0452618343photo-title a:hover, #yiv0452618343 div.yiv0452618343photo-title a:visited {text-decoration:none;}#yiv0452618343 div#yiv0452618343ygrp-mlmsg #yiv0452618343ygrp-msg p a span.yiv0452618343yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0452618343 .yiv0452618343green {color:#628c2a;}#yiv0452618343 .yiv0452618343MsoNormal {margin:0 0 0 0;}#yiv0452618343 o {font-size:0;}#yiv0452618343 #yiv0452618343photos div {float:left;width:72px;}#yiv0452618343 #yiv0452618343photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv0452618343 #yiv0452618343photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0452618343 #yiv0452618343reco-category {font-size:77%;}#yiv0452618343 #yiv0452618343reco-desc {font-size:77%;}#yiv0452618343 .yiv0452618343replbq {margin:4px;}#yiv0452618343 #yiv0452618343ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0452618343 #yiv0452618343ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0452618343 #yiv0452618343ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0452618343 #yiv0452618343ygrp-mlmsg select, #yiv0452618343 input, #yiv0452618343 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0452618343 #yiv0452618343ygrp-mlmsg pre, #yiv0452618343 code {font:115% monospace;}#yiv0452618343 #yiv0452618343ygrp-mlmsg * {line-height:1.22em;}#yiv0452618343 #yiv0452618343ygrp-mlmsg #yiv0452618343logo {padding-bottom:10px;}#yiv0452618343 #yiv0452618343ygrp-msg p a {font-family:Verdana;}#yiv0452618343 #yiv0452618343ygrp-msg p#yiv0452618343attach-count span {color:#1E66AE;font-weight:700;}#yiv0452618343 #yiv0452618343ygrp-reco #yiv0452618343reco-head {color:#ff7900;font-weight:700;}#yiv0452618343 #yiv0452618343ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0452618343 #yiv0452618343ygrp-sponsor #yiv0452618343ov li a {font-size:130%;text-decoration:none;}#yiv0452618343 #yiv0452618343ygrp-sponsor #yiv0452618343ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0452618343 #yiv0452618343ygrp-sponsor #yiv0452618343ov ul {margin:0;padding:0 0 0 8px;}#yiv0452618343 #yiv0452618343ygrp-text {font-family:Georgia;}#yiv0452618343 #yiv0452618343ygrp-text p {margin:0 0 1em 0;}#yiv0452618343 #yiv0452618343ygrp-text tt {font-size:120%;}#yiv0452618343 #yiv0452618343ygrp-vital ul li:last-child {border-right:none !important;}#yiv0452618343

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

2

Template penjualan konsinyasi

Sun Oct 1, 2017 9:56 pm (PDT) . Posted by:

"Harry Acenk Rafke" harry_acenkxx

Dear Excel Expert,
Mohon info apakah ada yang pernah atau punya template MS. Excel untuk penggunakan sistem penjualan konsinyasi?Apapun bentuknya apabila ada dan bisa dishare, saya mau dong, butuh banget, udh beberapa kali bikin tapi ttp belum bisa efesien rasanya.
Terima Kasih.
Harry Dharma Rafke

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

• Privacy • Unsubscribe • Terms of Use