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 samsudinort...@yahoo.com
[belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Assalamu'alaikum
Master Excel,
Mohon bantuan dan pencerahan untuk masalah code status.
Sebelumnya saya mengucapkan terima kasih atas pencerahannya.
Wassalam
Samsudin #yiv8141900414 #yiv8141900414 -- #yiv8141900414ygrp-mkp {border:1px
solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8141900414
#yiv8141900414ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8141900414
#yiv8141900414ygrp-mkp #yiv8141900414hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv8141900414 #yiv8141900414ygrp-mkp #yiv8141900414ads
{margin-bottom:10px;}#yiv8141900414 #yiv8141900414ygrp-mkp .yiv8141900414ad
{padding:0 0;}#yiv8141900414 #yiv8141900414ygrp-mkp .yiv8141900414ad p
{margin:0;}#yiv8141900414 #yiv8141900414ygrp-mkp .yiv8141900414ad a
{color:#0000ff;text-decoration:none;}#yiv8141900414 #yiv8141900414ygrp-sponsor
#yiv8141900414ygrp-lc {font-family:Arial;}#yiv8141900414
#yiv8141900414ygrp-sponsor #yiv8141900414ygrp-lc #yiv8141900414hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8141900414
#yiv8141900414ygrp-sponsor #yiv8141900414ygrp-lc .yiv8141900414ad
{margin-bottom:10px;padding:0 0;}#yiv8141900414 #yiv8141900414actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8141900414
#yiv8141900414activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8141900414
#yiv8141900414activity span {font-weight:700;}#yiv8141900414
#yiv8141900414activity span:first-child
{text-transform:uppercase;}#yiv8141900414 #yiv8141900414activity span a
{color:#5085b6;text-decoration:none;}#yiv8141900414 #yiv8141900414activity span
span {color:#ff7900;}#yiv8141900414 #yiv8141900414activity span
.yiv8141900414underline {text-decoration:underline;}#yiv8141900414
.yiv8141900414attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv8141900414 .yiv8141900414attach div a
{text-decoration:none;}#yiv8141900414 .yiv8141900414attach img
{border:none;padding-right:5px;}#yiv8141900414 .yiv8141900414attach label
{display:block;margin-bottom:5px;}#yiv8141900414 .yiv8141900414attach label a
{text-decoration:none;}#yiv8141900414 blockquote {margin:0 0 0
4px;}#yiv8141900414 .yiv8141900414bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv8141900414
.yiv8141900414bold a {text-decoration:none;}#yiv8141900414 dd.yiv8141900414last
p a {font-family:Verdana;font-weight:700;}#yiv8141900414 dd.yiv8141900414last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8141900414
dd.yiv8141900414last p span.yiv8141900414yshortcuts
{margin-right:0;}#yiv8141900414 div.yiv8141900414attach-table div div a
{text-decoration:none;}#yiv8141900414 div.yiv8141900414attach-table
{width:400px;}#yiv8141900414 div.yiv8141900414file-title a, #yiv8141900414
div.yiv8141900414file-title a:active, #yiv8141900414
div.yiv8141900414file-title a:hover, #yiv8141900414 div.yiv8141900414file-title
a:visited {text-decoration:none;}#yiv8141900414 div.yiv8141900414photo-title a,
#yiv8141900414 div.yiv8141900414photo-title a:active, #yiv8141900414
div.yiv8141900414photo-title a:hover, #yiv8141900414
div.yiv8141900414photo-title a:visited {text-decoration:none;}#yiv8141900414
div#yiv8141900414ygrp-mlmsg #yiv8141900414ygrp-msg p a
span.yiv8141900414yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8141900414
.yiv8141900414green {color:#628c2a;}#yiv8141900414 .yiv8141900414MsoNormal
{margin:0 0 0 0;}#yiv8141900414 o {font-size:0;}#yiv8141900414
#yiv8141900414photos div {float:left;width:72px;}#yiv8141900414
#yiv8141900414photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv8141900414
#yiv8141900414photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8141900414
#yiv8141900414reco-category {font-size:77%;}#yiv8141900414
#yiv8141900414reco-desc {font-size:77%;}#yiv8141900414 .yiv8141900414replbq
{margin:4px;}#yiv8141900414 #yiv8141900414ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv8141900414 #yiv8141900414ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8141900414
#yiv8141900414ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8141900414
#yiv8141900414ygrp-mlmsg select, #yiv8141900414 input, #yiv8141900414 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv8141900414
#yiv8141900414ygrp-mlmsg pre, #yiv8141900414 code {font:115%
monospace;}#yiv8141900414 #yiv8141900414ygrp-mlmsg *
{line-height:1.22em;}#yiv8141900414 #yiv8141900414ygrp-mlmsg #yiv8141900414logo
{padding-bottom:10px;}#yiv8141900414 #yiv8141900414ygrp-msg p a
{font-family:Verdana;}#yiv8141900414 #yiv8141900414ygrp-msg
p#yiv8141900414attach-count span {color:#1E66AE;font-weight:700;}#yiv8141900414
#yiv8141900414ygrp-reco #yiv8141900414reco-head
{color:#ff7900;font-weight:700;}#yiv8141900414 #yiv8141900414ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv8141900414 #yiv8141900414ygrp-sponsor
#yiv8141900414ov li a {font-size:130%;text-decoration:none;}#yiv8141900414
#yiv8141900414ygrp-sponsor #yiv8141900414ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv8141900414
#yiv8141900414ygrp-sponsor #yiv8141900414ov ul {margin:0;padding:0 0 0
8px;}#yiv8141900414 #yiv8141900414ygrp-text
{font-family:Georgia;}#yiv8141900414 #yiv8141900414ygrp-text p {margin:0 0 1em
0;}#yiv8141900414 #yiv8141900414ygrp-text tt {font-size:120%;}#yiv8141900414
#yiv8141900414ygrp-vital ul li:last-child {border-right:none
!important;}#yiv8141900414
Copy of Code Status.xlsb
Description: application/vnd.ms-excel.sheet.binary.macroenabled.12
