dua bagian formula, formula pada kolom SO1, berbeda dengan formula pada SO lainny, beda dikit sih dari punya pak guru, moga bisa jadi bahan belajar... :) br,
odong nando
Pada Selasa, 23 Februari 2016 14:10, "Nang Agus [email protected]
[belajar-excel]" <[email protected]> menulis:
2016-02-23 13:46 GMT+07:00 'Subroto, Matzen' [email protected]
[belajar-excel] <[email protected]>:
Dear Master Semoga Allah memberkahi semuanya Saya mendapati kendala untuk
memecah order secara Auto dengan menggunakan formula, mohon pencerahannye dari
para master Terima kasih atas perhatian dan kerjasamanya, dan saya mohon maaf
apabila ada kata-kata yang kurang berkenan Terima Kasih Matzen
#yiv3326918289 #yiv3326918289 -- #yiv3326918289ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3326918289
#yiv3326918289ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3326918289
#yiv3326918289ygrp-mkp #yiv3326918289hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv3326918289 #yiv3326918289ygrp-mkp #yiv3326918289ads
{margin-bottom:10px;}#yiv3326918289 #yiv3326918289ygrp-mkp .yiv3326918289ad
{padding:0 0;}#yiv3326918289 #yiv3326918289ygrp-mkp .yiv3326918289ad p
{margin:0;}#yiv3326918289 #yiv3326918289ygrp-mkp .yiv3326918289ad a
{color:#0000ff;text-decoration:none;}#yiv3326918289 #yiv3326918289ygrp-sponsor
#yiv3326918289ygrp-lc {font-family:Arial;}#yiv3326918289
#yiv3326918289ygrp-sponsor #yiv3326918289ygrp-lc #yiv3326918289hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3326918289
#yiv3326918289ygrp-sponsor #yiv3326918289ygrp-lc .yiv3326918289ad
{margin-bottom:10px;padding:0 0;}#yiv3326918289 #yiv3326918289actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3326918289
#yiv3326918289activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3326918289
#yiv3326918289activity span {font-weight:700;}#yiv3326918289
#yiv3326918289activity span:first-child
{text-transform:uppercase;}#yiv3326918289 #yiv3326918289activity span a
{color:#5085b6;text-decoration:none;}#yiv3326918289 #yiv3326918289activity span
span {color:#ff7900;}#yiv3326918289 #yiv3326918289activity span
.yiv3326918289underline {text-decoration:underline;}#yiv3326918289
.yiv3326918289attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv3326918289 .yiv3326918289attach div a
{text-decoration:none;}#yiv3326918289 .yiv3326918289attach img
{border:none;padding-right:5px;}#yiv3326918289 .yiv3326918289attach label
{display:block;margin-bottom:5px;}#yiv3326918289 .yiv3326918289attach label a
{text-decoration:none;}#yiv3326918289 blockquote {margin:0 0 0
4px;}#yiv3326918289 .yiv3326918289bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv3326918289
.yiv3326918289bold a {text-decoration:none;}#yiv3326918289 dd.yiv3326918289last
p a {font-family:Verdana;font-weight:700;}#yiv3326918289 dd.yiv3326918289last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3326918289
dd.yiv3326918289last p span.yiv3326918289yshortcuts
{margin-right:0;}#yiv3326918289 div.yiv3326918289attach-table div div a
{text-decoration:none;}#yiv3326918289 div.yiv3326918289attach-table
{width:400px;}#yiv3326918289 div.yiv3326918289file-title a, #yiv3326918289
div.yiv3326918289file-title a:active, #yiv3326918289
div.yiv3326918289file-title a:hover, #yiv3326918289 div.yiv3326918289file-title
a:visited {text-decoration:none;}#yiv3326918289 div.yiv3326918289photo-title a,
#yiv3326918289 div.yiv3326918289photo-title a:active, #yiv3326918289
div.yiv3326918289photo-title a:hover, #yiv3326918289
div.yiv3326918289photo-title a:visited {text-decoration:none;}#yiv3326918289
div#yiv3326918289ygrp-mlmsg #yiv3326918289ygrp-msg p a
span.yiv3326918289yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3326918289
.yiv3326918289green {color:#628c2a;}#yiv3326918289 .yiv3326918289MsoNormal
{margin:0 0 0 0;}#yiv3326918289 o {font-size:0;}#yiv3326918289
#yiv3326918289photos div {float:left;width:72px;}#yiv3326918289
#yiv3326918289photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv3326918289
#yiv3326918289photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3326918289
#yiv3326918289reco-category {font-size:77%;}#yiv3326918289
#yiv3326918289reco-desc {font-size:77%;}#yiv3326918289 .yiv3326918289replbq
{margin:4px;}#yiv3326918289 #yiv3326918289ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv3326918289 #yiv3326918289ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3326918289
#yiv3326918289ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3326918289
#yiv3326918289ygrp-mlmsg select, #yiv3326918289 input, #yiv3326918289 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv3326918289
#yiv3326918289ygrp-mlmsg pre, #yiv3326918289 code {font:115%
monospace;}#yiv3326918289 #yiv3326918289ygrp-mlmsg *
{line-height:1.22em;}#yiv3326918289 #yiv3326918289ygrp-mlmsg #yiv3326918289logo
{padding-bottom:10px;}#yiv3326918289 #yiv3326918289ygrp-msg p a
{font-family:Verdana;}#yiv3326918289 #yiv3326918289ygrp-msg
p#yiv3326918289attach-count span {color:#1E66AE;font-weight:700;}#yiv3326918289
#yiv3326918289ygrp-reco #yiv3326918289reco-head
{color:#ff7900;font-weight:700;}#yiv3326918289 #yiv3326918289ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv3326918289 #yiv3326918289ygrp-sponsor
#yiv3326918289ov li a {font-size:130%;text-decoration:none;}#yiv3326918289
#yiv3326918289ygrp-sponsor #yiv3326918289ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv3326918289
#yiv3326918289ygrp-sponsor #yiv3326918289ov ul {margin:0;padding:0 0 0
8px;}#yiv3326918289 #yiv3326918289ygrp-text
{font-family:Georgia;}#yiv3326918289 #yiv3326918289ygrp-text p {margin:0 0 1em
0;}#yiv3326918289 #yiv3326918289ygrp-text tt {font-size:120%;}#yiv3326918289
#yiv3326918289ygrp-vital ul li:last-child {border-right:none
!important;}#yiv3326918289
SO_ON.xlsx
Description: MS-Excel 2007 spreadsheet
