Hai Haris,File terlampir menggunakan UDF (User Defined Function) modifikasi
dari UDF mbak Siti, dengan tambahan 2 kolom bantu berupa formula untuk
mengambil nilai awal dan akhir.Jangan lupa aktifkan macronya atau "tempelkan"
UDF nya sebagai "Add-ins".
Salam,HK
From: "ris ha [email protected] [belajar-excel]"
<[email protected]>
To: "[email protected]" <[email protected]>
Sent: Thursday, 12 March 2015, 8:39
Subject: Re: Bls: [belajar-excel] Cara menghitung character
Terima kasih atas solusinya para master semua. sebenarnya kasus saya adalah
menterjemahkan data seperti ini
Data Hasil
2 s/d 4 2,3,45 s/d 9 5,6,7,8,911 s/d 15
11,12,13,14,15
1 & 2 1,210 & 11 10,11100 s/d 102 100,101,102
karena keterbatasan ilmu dan waktu saya, sehingga saya tidak ambil pusing,
langsung diterjemahkan sendiri.
Nah kira2, bagaimana formulanya untuk memecahkan data tersebut ya?
Sekali lagi terima kasih
SalamHaris
On Wednesday, March 11, 2015 12:42 PM, "Toby kenzo [email protected]
[belajar-excel]" <[email protected]> wrote:
Dear mas Haris, coba pake formula : =LEN(A2)-LEN(SUBSTITUTE(A2,",",""))
TerimaKasih.
Pada Rabu, 11 Maret 2015 10:14, "ris ha [email protected]
[belajar-excel]" <[email protected]> menulis:
Assalamu'alaikum para suhu excel yg baik hati
Bagaimana caranya menghitung karakter "," (koma) pada kasus spt dibawah.
| Data | Jumlah |
| 1,2 | 1 |
| 1,2,3 | 2 |
| 4,10,18 | 2 |
| 5,9,10,15 | 3 |
Terima kasih
SalamHaris
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
#yiv4195993706 #yiv4195993706 -- #yiv4195993706ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4195993706
#yiv4195993706ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4195993706
#yiv4195993706ygrp-mkp #yiv4195993706hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv4195993706 #yiv4195993706ygrp-mkp #yiv4195993706ads
{margin-bottom:10px;}#yiv4195993706 #yiv4195993706ygrp-mkp .yiv4195993706ad
{padding:0 0;}#yiv4195993706 #yiv4195993706ygrp-mkp .yiv4195993706ad p
{margin:0;}#yiv4195993706 #yiv4195993706ygrp-mkp .yiv4195993706ad a
{color:#0000ff;text-decoration:none;}#yiv4195993706 #yiv4195993706ygrp-sponsor
#yiv4195993706ygrp-lc {font-family:Arial;}#yiv4195993706
#yiv4195993706ygrp-sponsor #yiv4195993706ygrp-lc #yiv4195993706hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4195993706
#yiv4195993706ygrp-sponsor #yiv4195993706ygrp-lc .yiv4195993706ad
{margin-bottom:10px;padding:0 0;}#yiv4195993706 #yiv4195993706actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4195993706
#yiv4195993706activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4195993706
#yiv4195993706activity span {font-weight:700;}#yiv4195993706
#yiv4195993706activity span:first-child
{text-transform:uppercase;}#yiv4195993706 #yiv4195993706activity span a
{color:#5085b6;text-decoration:none;}#yiv4195993706 #yiv4195993706activity span
span {color:#ff7900;}#yiv4195993706 #yiv4195993706activity span
.yiv4195993706underline {text-decoration:underline;}#yiv4195993706
.yiv4195993706attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv4195993706 .yiv4195993706attach div a
{text-decoration:none;}#yiv4195993706 .yiv4195993706attach img
{border:none;padding-right:5px;}#yiv4195993706 .yiv4195993706attach label
{display:block;margin-bottom:5px;}#yiv4195993706 .yiv4195993706attach label a
{text-decoration:none;}#yiv4195993706 blockquote {margin:0 0 0
4px;}#yiv4195993706 .yiv4195993706bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv4195993706
.yiv4195993706bold a {text-decoration:none;}#yiv4195993706 dd.yiv4195993706last
p a {font-family:Verdana;font-weight:700;}#yiv4195993706 dd.yiv4195993706last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4195993706
dd.yiv4195993706last p span.yiv4195993706yshortcuts
{margin-right:0;}#yiv4195993706 div.yiv4195993706attach-table div div a
{text-decoration:none;}#yiv4195993706 div.yiv4195993706attach-table
{width:400px;}#yiv4195993706 div.yiv4195993706file-title a, #yiv4195993706
div.yiv4195993706file-title a:active, #yiv4195993706
div.yiv4195993706file-title a:hover, #yiv4195993706 div.yiv4195993706file-title
a:visited {text-decoration:none;}#yiv4195993706 div.yiv4195993706photo-title a,
#yiv4195993706 div.yiv4195993706photo-title a:active, #yiv4195993706
div.yiv4195993706photo-title a:hover, #yiv4195993706
div.yiv4195993706photo-title a:visited {text-decoration:none;}#yiv4195993706
div#yiv4195993706ygrp-mlmsg #yiv4195993706ygrp-msg p a
span.yiv4195993706yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4195993706
.yiv4195993706green {color:#628c2a;}#yiv4195993706 .yiv4195993706MsoNormal
{margin:0 0 0 0;}#yiv4195993706 o {font-size:0;}#yiv4195993706
#yiv4195993706photos div {float:left;width:72px;}#yiv4195993706
#yiv4195993706photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv4195993706
#yiv4195993706photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4195993706
#yiv4195993706reco-category {font-size:77%;}#yiv4195993706
#yiv4195993706reco-desc {font-size:77%;}#yiv4195993706 .yiv4195993706replbq
{margin:4px;}#yiv4195993706 #yiv4195993706ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv4195993706 #yiv4195993706ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4195993706
#yiv4195993706ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4195993706
#yiv4195993706ygrp-mlmsg select, #yiv4195993706 input, #yiv4195993706 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv4195993706
#yiv4195993706ygrp-mlmsg pre, #yiv4195993706 code {font:115%
monospace;}#yiv4195993706 #yiv4195993706ygrp-mlmsg *
{line-height:1.22em;}#yiv4195993706 #yiv4195993706ygrp-mlmsg #yiv4195993706logo
{padding-bottom:10px;}#yiv4195993706 #yiv4195993706ygrp-msg p a
{font-family:Verdana;}#yiv4195993706 #yiv4195993706ygrp-msg
p#yiv4195993706attach-count span {color:#1E66AE;font-weight:700;}#yiv4195993706
#yiv4195993706ygrp-reco #yiv4195993706reco-head
{color:#ff7900;font-weight:700;}#yiv4195993706 #yiv4195993706ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv4195993706 #yiv4195993706ygrp-sponsor
#yiv4195993706ov li a {font-size:130%;text-decoration:none;}#yiv4195993706
#yiv4195993706ygrp-sponsor #yiv4195993706ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv4195993706
#yiv4195993706ygrp-sponsor #yiv4195993706ov ul {margin:0;padding:0 0 0
8px;}#yiv4195993706 #yiv4195993706ygrp-text
{font-family:Georgia;}#yiv4195993706 #yiv4195993706ygrp-text p {margin:0 0 1em
0;}#yiv4195993706 #yiv4195993706ygrp-text tt {font-size:120%;}#yiv4195993706
#yiv4195993706ygrp-vital ul li:last-child {border-right:none
!important;}#yiv4195993706
UDF_Serial.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12
