terima kasih kembali.
mungkin sebaiknya permasalahan yang diajukan disertai dengan lampiran
file(attachment) dan hasil yang diinginkan secara manual , dengan begitu saya
bisa memahami lebih sempurna . dan bisa memberikan solusi dengan senang hati
kalau memang saya mampu. oke saya tunggu casenya.
wassalam
Ghozi Alkatiri Pada Selasa, 10 April 2018 09.29.36 GMT+7, Pak Cik Lukman
pakcikluk...@gmail.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:
terima kasih banyak pak Ghozi atas Sharing Ilmunya....
namun a. jika di ada terdapat beberapa PO double number .. apakah masih tetap
menggunakan formula SMALL ?? atau dirubah dlm bentuk formula lain?b. dan
bagiamana agar di koloum G kita mendapatkan nomor/text berdasarkan SHORT /
berurutan ?
sekali lagi, terima kasih atas sharing Ilmunya semoga semakin bermanfaat untuk
bpk dan master2 excel lainnya
salam, #yiv1104022898 #yiv1104022898 -- #yiv1104022898ygrp-mkp {border:1px
solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1104022898
#yiv1104022898ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1104022898
#yiv1104022898ygrp-mkp #yiv1104022898hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv1104022898 #yiv1104022898ygrp-mkp #yiv1104022898ads
{margin-bottom:10px;}#yiv1104022898 #yiv1104022898ygrp-mkp .yiv1104022898ad
{padding:0 0;}#yiv1104022898 #yiv1104022898ygrp-mkp .yiv1104022898ad p
{margin:0;}#yiv1104022898 #yiv1104022898ygrp-mkp .yiv1104022898ad a
{color:#0000ff;text-decoration:none;}#yiv1104022898 #yiv1104022898ygrp-sponsor
#yiv1104022898ygrp-lc {font-family:Arial;}#yiv1104022898
#yiv1104022898ygrp-sponsor #yiv1104022898ygrp-lc #yiv1104022898hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1104022898
#yiv1104022898ygrp-sponsor #yiv1104022898ygrp-lc .yiv1104022898ad
{margin-bottom:10px;padding:0 0;}#yiv1104022898 #yiv1104022898actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1104022898
#yiv1104022898activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1104022898
#yiv1104022898activity span {font-weight:700;}#yiv1104022898
#yiv1104022898activity span:first-child
{text-transform:uppercase;}#yiv1104022898 #yiv1104022898activity span a
{color:#5085b6;text-decoration:none;}#yiv1104022898 #yiv1104022898activity span
span {color:#ff7900;}#yiv1104022898 #yiv1104022898activity span
.yiv1104022898underline {text-decoration:underline;}#yiv1104022898
.yiv1104022898attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv1104022898 ..yiv1104022898attach div a
{text-decoration:none;}#yiv1104022898 .yiv1104022898attach img
{border:none;padding-right:5px;}#yiv1104022898 .yiv1104022898attach label
{display:block;margin-bottom:5px;}#yiv1104022898 .yiv1104022898attach label a
{text-decoration:none;}#yiv1104022898 blockquote {margin:0 0 0
4px;}#yiv1104022898 .yiv1104022898bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv1104022898
.yiv1104022898bold a {text-decoration:none;}#yiv1104022898 dd.yiv1104022898last
p a {font-family:Verdana;font-weight:700;}#yiv1104022898 dd.yiv1104022898last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1104022898
dd.yiv1104022898last p span.yiv1104022898yshortcuts
{margin-right:0;}#yiv1104022898 div.yiv1104022898attach-table div div a
{text-decoration:none;}#yiv1104022898 div.yiv1104022898attach-table
{width:400px;}#yiv1104022898 div.yiv1104022898file-title a, #yiv1104022898
div.yiv1104022898file-title a:active, #yiv1104022898
div.yiv1104022898file-title a:hover, #yiv1104022898 div.yiv1104022898file-title
a:visited {text-decoration:none;}#yiv1104022898 div.yiv1104022898photo-title a,
#yiv1104022898 div.yiv1104022898photo-title a:active, #yiv1104022898
div.yiv1104022898photo-title a:hover, #yiv1104022898
div.yiv1104022898photo-title a:visited {text-decoration:none;}#yiv1104022898
div#yiv1104022898ygrp-mlmsg #yiv1104022898ygrp-msg p a
span.yiv1104022898yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1104022898
.yiv1104022898green {color:#628c2a;}#yiv1104022898 .yiv1104022898MsoNormal
{margin:0 0 0 0;}#yiv1104022898 o {font-size:0;}#yiv1104022898
#yiv1104022898photos div {float:left;width:72px;}#yiv1104022898
#yiv1104022898photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv1104022898
#yiv1104022898photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1104022898
#yiv1104022898reco-category {font-size:77%;}#yiv1104022898
#yiv1104022898reco-desc {font-size:77%;}#yiv1104022898 .yiv1104022898replbq
{margin:4px;}#yiv1104022898 #yiv1104022898ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv1104022898 #yiv1104022898ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1104022898
#yiv1104022898ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1104022898
#yiv1104022898ygrp-mlmsg select, #yiv1104022898 input, #yiv1104022898 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv1104022898
#yiv1104022898ygrp-mlmsg pre, #yiv1104022898 code {font:115%
monospace;}#yiv1104022898 #yiv1104022898ygrp-mlmsg *
{line-height:1.22em;}#yiv1104022898 #yiv1104022898ygrp-mlmsg #yiv1104022898logo
{padding-bottom:10px;}#yiv1104022898 #yiv1104022898ygrp-msg p a
{font-family:Verdana;}#yiv1104022898 #yiv1104022898ygrp-msg
p#yiv1104022898attach-count span {color:#1E66AE;font-weight:700;}#yiv1104022898
#yiv1104022898ygrp-reco #yiv1104022898reco-head
{color:#ff7900;font-weight:700;}#yiv1104022898 #yiv1104022898ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv1104022898 #yiv1104022898ygrp-sponsor
#yiv1104022898ov li a {font-size:130%;text-decoration:none;}#yiv1104022898
#yiv1104022898ygrp-sponsor #yiv1104022898ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv1104022898
#yiv1104022898ygrp-sponsor #yiv1104022898ov ul {margin:0;padding:0 0 0
8px;}#yiv1104022898 #yiv1104022898ygrp-text
{font-family:Georgia;}#yiv1104022898 #yiv1104022898ygrp-text p {margin:0 0 1em
0;}#yiv1104022898 #yiv1104022898ygrp-text tt {font-size:120%;}#yiv1104022898
#yiv1104022898ygrp-vital ul li:last-child {border-right:none
!important;}#yiv1104022898
