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 tobyke...@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> 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 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 #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