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 tobyke...@yahoo.co.id
[belajar-excel]" <belajar-excel@yahoogroups.com> wrote:
Dear mas Haris, coba pake formula : =LEN(A2)-LEN(SUBSTITUTE(A2,",",""))
TerimaKasih.
Pada Rabu, 11 Maret 2015 10:14, "ris ha har1sn.ex...@yahoo.com
[belajar-excel]" <belajar-excel@yahoogroups.com> 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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
#yiv9995802651 #yiv9995802651 -- #yiv9995802651ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9995802651
#yiv9995802651ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9995802651
#yiv9995802651ygrp-mkp #yiv9995802651hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv9995802651 #yiv9995802651ygrp-mkp #yiv9995802651ads
{margin-bottom:10px;}#yiv9995802651 #yiv9995802651ygrp-mkp .yiv9995802651ad
{padding:0 0;}#yiv9995802651 #yiv9995802651ygrp-mkp .yiv9995802651ad p
{margin:0;}#yiv9995802651 #yiv9995802651ygrp-mkp .yiv9995802651ad a
{color:#0000ff;text-decoration:none;}#yiv9995802651 #yiv9995802651ygrp-sponsor
#yiv9995802651ygrp-lc {font-family:Arial;}#yiv9995802651
#yiv9995802651ygrp-sponsor #yiv9995802651ygrp-lc #yiv9995802651hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9995802651
#yiv9995802651ygrp-sponsor #yiv9995802651ygrp-lc .yiv9995802651ad
{margin-bottom:10px;padding:0 0;}#yiv9995802651 #yiv9995802651actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9995802651
#yiv9995802651activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9995802651
#yiv9995802651activity span {font-weight:700;}#yiv9995802651
#yiv9995802651activity span:first-child
{text-transform:uppercase;}#yiv9995802651 #yiv9995802651activity span a
{color:#5085b6;text-decoration:none;}#yiv9995802651 #yiv9995802651activity span
span {color:#ff7900;}#yiv9995802651 #yiv9995802651activity span
.yiv9995802651underline {text-decoration:underline;}#yiv9995802651
.yiv9995802651attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv9995802651 .yiv9995802651attach div a
{text-decoration:none;}#yiv9995802651 .yiv9995802651attach img
{border:none;padding-right:5px;}#yiv9995802651 .yiv9995802651attach label
{display:block;margin-bottom:5px;}#yiv9995802651 .yiv9995802651attach label a
{text-decoration:none;}#yiv9995802651 blockquote {margin:0 0 0
4px;}#yiv9995802651 .yiv9995802651bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv9995802651
.yiv9995802651bold a {text-decoration:none;}#yiv9995802651 dd.yiv9995802651last
p a {font-family:Verdana;font-weight:700;}#yiv9995802651 dd.yiv9995802651last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9995802651
dd.yiv9995802651last p span.yiv9995802651yshortcuts
{margin-right:0;}#yiv9995802651 div.yiv9995802651attach-table div div a
{text-decoration:none;}#yiv9995802651 div.yiv9995802651attach-table
{width:400px;}#yiv9995802651 div.yiv9995802651file-title a, #yiv9995802651
div.yiv9995802651file-title a:active, #yiv9995802651
div.yiv9995802651file-title a:hover, #yiv9995802651 div.yiv9995802651file-title
a:visited {text-decoration:none;}#yiv9995802651 div.yiv9995802651photo-title a,
#yiv9995802651 div.yiv9995802651photo-title a:active, #yiv9995802651
div.yiv9995802651photo-title a:hover, #yiv9995802651
div.yiv9995802651photo-title a:visited {text-decoration:none;}#yiv9995802651
div#yiv9995802651ygrp-mlmsg #yiv9995802651ygrp-msg p a
span.yiv9995802651yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9995802651
.yiv9995802651green {color:#628c2a;}#yiv9995802651 .yiv9995802651MsoNormal
{margin:0 0 0 0;}#yiv9995802651 o {font-size:0;}#yiv9995802651
#yiv9995802651photos div {float:left;width:72px;}#yiv9995802651
#yiv9995802651photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv9995802651
#yiv9995802651photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9995802651
#yiv9995802651reco-category {font-size:77%;}#yiv9995802651
#yiv9995802651reco-desc {font-size:77%;}#yiv9995802651 .yiv9995802651replbq
{margin:4px;}#yiv9995802651 #yiv9995802651ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv9995802651 #yiv9995802651ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9995802651
#yiv9995802651ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9995802651
#yiv9995802651ygrp-mlmsg select, #yiv9995802651 input, #yiv9995802651 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv9995802651
#yiv9995802651ygrp-mlmsg pre, #yiv9995802651 code {font:115%
monospace;}#yiv9995802651 #yiv9995802651ygrp-mlmsg *
{line-height:1.22em;}#yiv9995802651 #yiv9995802651ygrp-mlmsg #yiv9995802651logo
{padding-bottom:10px;}#yiv9995802651 #yiv9995802651ygrp-msg p a
{font-family:Verdana;}#yiv9995802651 #yiv9995802651ygrp-msg
p#yiv9995802651attach-count span {color:#1E66AE;font-weight:700;}#yiv9995802651
#yiv9995802651ygrp-reco #yiv9995802651reco-head
{color:#ff7900;font-weight:700;}#yiv9995802651 #yiv9995802651ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv9995802651 #yiv9995802651ygrp-sponsor
#yiv9995802651ov li a {font-size:130%;text-decoration:none;}#yiv9995802651
#yiv9995802651ygrp-sponsor #yiv9995802651ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv9995802651
#yiv9995802651ygrp-sponsor #yiv9995802651ov ul {margin:0;padding:0 0 0
8px;}#yiv9995802651 #yiv9995802651ygrp-text
{font-family:Georgia;}#yiv9995802651 #yiv9995802651ygrp-text p {margin:0 0 1em
0;}#yiv9995802651 #yiv9995802651ygrp-text tt {font-size:120%;}#yiv9995802651
#yiv9995802651ygrp-vital ul li:last-child {border-right:none
!important;}#yiv9995802651
