Pak Toby,
Terima kasih atas pencerahannya mohon maaf setelah saya file tersebut tidak
bisa/belum khususnya pada tombol start atau delete nya.
WassalamSamsudin
Pada Minggu, 12 Juni 2016 0:09, "Toby kenzo [email protected]
[belajar-excel]" <[email protected]> menulis:
Hai Samsudin,
Berikut saya berikan contohnya.Intinya sama saja, dengan menggunakan VBA maupun
formula Excel, karena contoh yang saya berikan intinya menggunakan formula
Excel tetapi dengan sedikit "Sentuhan" VBA.
Jika kita menggunakan formula Excel, kita akan menambahkan Row sebanyak jumlah
karakter koma (,) sesuai pada cell yang terdapat kata2 (Status)dan untuk
menghitung jumlah status bisa menggunakan formula countif dengan menambahkan
"Wild card" atau tanda * pada nilai rujukannya, misal : =
countif($C$3:$C$33,"*ABS*")
TerimaKasih.
Pada Sabtu, 11 Juni 2016 7:46, "Samsudin Sam [email protected]
[belajar-excel]" <[email protected]> menulis:
Assalamu'alaikum
Master Excel,
Mohon bantuan dan pencerahan untuk masalah code status.
Sebelumnya saya mengucapkan terima kasih atas pencerahannya.
Wassalam
Samsudin
#yiv6170922553 #yiv6170922553 -- #yiv6170922553ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6170922553
#yiv6170922553ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6170922553
#yiv6170922553ygrp-mkp #yiv6170922553hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv6170922553 #yiv6170922553ygrp-mkp #yiv6170922553ads
{margin-bottom:10px;}#yiv6170922553 #yiv6170922553ygrp-mkp .yiv6170922553ad
{padding:0 0;}#yiv6170922553 #yiv6170922553ygrp-mkp .yiv6170922553ad p
{margin:0;}#yiv6170922553 #yiv6170922553ygrp-mkp .yiv6170922553ad a
{color:#0000ff;text-decoration:none;}#yiv6170922553 #yiv6170922553ygrp-sponsor
#yiv6170922553ygrp-lc {font-family:Arial;}#yiv6170922553
#yiv6170922553ygrp-sponsor #yiv6170922553ygrp-lc #yiv6170922553hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6170922553
#yiv6170922553ygrp-sponsor #yiv6170922553ygrp-lc .yiv6170922553ad
{margin-bottom:10px;padding:0 0;}#yiv6170922553 #yiv6170922553actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6170922553
#yiv6170922553activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6170922553
#yiv6170922553activity span {font-weight:700;}#yiv6170922553
#yiv6170922553activity span:first-child
{text-transform:uppercase;}#yiv6170922553 #yiv6170922553activity span a
{color:#5085b6;text-decoration:none;}#yiv6170922553 #yiv6170922553activity span
span {color:#ff7900;}#yiv6170922553 #yiv6170922553activity span
.yiv6170922553underline {text-decoration:underline;}#yiv6170922553
.yiv6170922553attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv6170922553 .yiv6170922553attach div a
{text-decoration:none;}#yiv6170922553 .yiv6170922553attach img
{border:none;padding-right:5px;}#yiv6170922553 .yiv6170922553attach label
{display:block;margin-bottom:5px;}#yiv6170922553 .yiv6170922553attach label a
{text-decoration:none;}#yiv6170922553 blockquote {margin:0 0 0
4px;}#yiv6170922553 .yiv6170922553bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv6170922553
.yiv6170922553bold a {text-decoration:none;}#yiv6170922553 dd.yiv6170922553last
p a {font-family:Verdana;font-weight:700;}#yiv6170922553 dd.yiv6170922553last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6170922553
dd.yiv6170922553last p span.yiv6170922553yshortcuts
{margin-right:0;}#yiv6170922553 div.yiv6170922553attach-table div div a
{text-decoration:none;}#yiv6170922553 div.yiv6170922553attach-table
{width:400px;}#yiv6170922553 div.yiv6170922553file-title a, #yiv6170922553
div.yiv6170922553file-title a:active, #yiv6170922553
div.yiv6170922553file-title a:hover, #yiv6170922553 div.yiv6170922553file-title
a:visited {text-decoration:none;}#yiv6170922553 div.yiv6170922553photo-title a,
#yiv6170922553 div.yiv6170922553photo-title a:active, #yiv6170922553
div.yiv6170922553photo-title a:hover, #yiv6170922553
div.yiv6170922553photo-title a:visited {text-decoration:none;}#yiv6170922553
div#yiv6170922553ygrp-mlmsg #yiv6170922553ygrp-msg p a
span.yiv6170922553yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6170922553
.yiv6170922553green {color:#628c2a;}#yiv6170922553 .yiv6170922553MsoNormal
{margin:0 0 0 0;}#yiv6170922553 o {font-size:0;}#yiv6170922553
#yiv6170922553photos div {float:left;width:72px;}#yiv6170922553
#yiv6170922553photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv6170922553
#yiv6170922553photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6170922553
#yiv6170922553reco-category {font-size:77%;}#yiv6170922553
#yiv6170922553reco-desc {font-size:77%;}#yiv6170922553 .yiv6170922553replbq
{margin:4px;}#yiv6170922553 #yiv6170922553ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv6170922553 #yiv6170922553ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6170922553
#yiv6170922553ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6170922553
#yiv6170922553ygrp-mlmsg select, #yiv6170922553 input, #yiv6170922553 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv6170922553
#yiv6170922553ygrp-mlmsg pre, #yiv6170922553 code {font:115%
monospace;}#yiv6170922553 #yiv6170922553ygrp-mlmsg *
{line-height:1.22em;}#yiv6170922553 #yiv6170922553ygrp-mlmsg #yiv6170922553logo
{padding-bottom:10px;}#yiv6170922553 #yiv6170922553ygrp-msg p a
{font-family:Verdana;}#yiv6170922553 #yiv6170922553ygrp-msg
p#yiv6170922553attach-count span {color:#1E66AE;font-weight:700;}#yiv6170922553
#yiv6170922553ygrp-reco #yiv6170922553reco-head
{color:#ff7900;font-weight:700;}#yiv6170922553 #yiv6170922553ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv6170922553 #yiv6170922553ygrp-sponsor
#yiv6170922553ov li a {font-size:130%;text-decoration:none;}#yiv6170922553
#yiv6170922553ygrp-sponsor #yiv6170922553ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv6170922553
#yiv6170922553ygrp-sponsor #yiv6170922553ov ul {margin:0;padding:0 0 0
8px;}#yiv6170922553 #yiv6170922553ygrp-text
{font-family:Georgia;}#yiv6170922553 #yiv6170922553ygrp-text p {margin:0 0 1em
0;}#yiv6170922553 #yiv6170922553ygrp-text tt {font-size:120%;}#yiv6170922553
#yiv6170922553ygrp-vital ul li:last-child {border-right:none
!important;}#yiv6170922553
