[belajar-excel] Digest Number 4558

Milis Belajar Microsoft Excel Group

10 Messages

Digest #4558

1

Membuat RANK dengan 2 sumber data by "Hendro Supardi" hendro.supardi

2a

rumus loncat by "roy sumarna" rohendi_2000

2b

Re: rumus loncat by "Iman Darusman" idz.iman

2c

Re: rumus loncat by "hendrik karnadi" hendrikkarnadi

2d

Bls: [belajar-excel] rumus loncat by "odong nando"

2e

Re: rumus loncat [1 Attachment] by "ghozi alkatiri" ghozialkatiri

2f

Fw: Re: [belajar-excel] rumus loncat by "roy sumarna" rohendi_2000

2g

Fw: Bls: [belajar-excel] rumus loncat by "roy sumarna" rohendi_2000

2h

Fw: Re: [belajar-excel] rumus loncat by "roy sumarna" rohendi_2000

2i

Fw: Re: [belajar-excel] rumus loncat by "roy sumarna" rohendi_2000

Messages

1

Membuat RANK dengan 2 sumber data

Sun Jul 29, 2018 11:20 pm (PDT) . Posted by:

"Hendro Supardi" hendro.supardi

Master Excel,
Saya mengalami kendala dalam membuat RANK dengan menggunakan 2 (dua) sumber data yang berbeda, misalkan data ada di sheet2 dan sheet3, sedangkan hasil RANK ada di sheet1.
Mohon bantuan para Master Excel.
Terima kasih atas bantuannya.
Salam,
Hendro

Reply to sender . Reply to group . Reply via Web Post . All Messages (1) . Top ^

2a

rumus loncat

Mon Jul 30, 2018 2:24 am (PDT) . Posted by:

"roy sumarna" rohendi_2000

yth. master excel..
saya punya masalah.. yaitu bagaimana rumus mengcopy data
yang loncat loncat.. terlampir..
sebelumnya
saya ucapkan terima kasih

Reply to sender . Reply to group . Reply via Web Post . All Messages (9) . Top ^

2b

Re: rumus loncat

Mon Jul 30, 2018 2:54 am (PDT) . Posted by:

"Iman Darusman" idz.iman

Dear Pak Roy,
saya bantu Jawab ya.sebelumnya di column A hapus dulu tanda "-" jadi hanya ada numberingnya saja.
langkahnya:- blok dari A2:A26- dipanel ada HOME >> FIND & SELECT (gambar teropong)- pilih Go to Special- TIK "BLANK" lalu OK- terlihat area Blank dalam range A2:A26 sudah ter-select- langsung ketik "=" (akan muncul di row A3) dan arahkan ke A2-lalu pencet CTRL + ENTER- Selesai
semoga bermanfaat
salamIman
Pada Senin, 30 Juli 2018 16.24.47 GMT+7, roy sumarna rohendi_2000@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

 

yth. master excel..
saya punya masalah.. yaitu bagaimana rumus mengcopy data
yang loncat loncat.. terlampir..
sebelumnya
saya ucapkan terima kasih
#yiv2097867011 #yiv2097867011 -- #yiv2097867011ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2097867011 #yiv2097867011ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2097867011 #yiv2097867011ygrp-mkp #yiv2097867011hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2097867011 #yiv2097867011ygrp-mkp #yiv2097867011ads {margin-bottom:10px;}#yiv2097867011 #yiv2097867011ygrp-mkp .yiv2097867011ad {padding:0 0;}#yiv2097867011 #yiv2097867011ygrp-mkp .yiv2097867011ad p {margin:0;}#yiv2097867011 #yiv2097867011ygrp-mkp .yiv2097867011ad a {color:#0000ff;text-decoration:none;}#yiv2097867011 #yiv2097867011ygrp-sponsor #yiv2097867011ygrp-lc {font-family:Arial;}#yiv2097867011 #yiv2097867011ygrp-sponsor #yiv2097867011ygrp-lc #yiv2097867011hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2097867011 #yiv2097867011ygrp-sponsor #yiv2097867011ygrp-lc .yiv2097867011ad {margin-bottom:10px;padding:0 0;}#yiv2097867011 #yiv2097867011actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2097867011 #yiv2097867011activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2097867011 #yiv2097867011activity span {font-weight:700;}#yiv2097867011 #yiv2097867011activity span:first-child {text-transform:uppercase;}#yiv2097867011 #yiv2097867011activity span a {color:#5085b6;text-decoration:none;}#yiv2097867011 #yiv2097867011activity span span {color:#ff7900;}#yiv2097867011 #yiv2097867011activity span .yiv2097867011underline {text-decoration:underline;}#yiv2097867011 .yiv2097867011attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2097867011 .yiv2097867011attach div a {text-decoration:none;}#yiv2097867011 .yiv2097867011attach img {border:none;padding-right:5px;}#yiv2097867011 .yiv2097867011attach label {display:block;margin-bottom:5px;}#yiv2097867011 .yiv2097867011attach label a {text-decoration:none;}#yiv2097867011 blockquote {margin:0 0 0 4px;}#yiv2097867011 .yiv2097867011bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2097867011 .yiv2097867011bold a {text-decoration:none;}#yiv2097867011 dd.yiv2097867011last p a {font-family:Verdana;font-weight:700;}#yiv2097867011 dd.yiv2097867011last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2097867011 dd.yiv2097867011last p span.yiv2097867011yshortcuts {margin-right:0;}#yiv2097867011 div.yiv2097867011attach-table div div a {text-decoration:none;}#yiv2097867011 div.yiv2097867011attach-table {width:400px;}#yiv2097867011 div.yiv2097867011file-title a, #yiv2097867011 div.yiv2097867011file-title a:active, #yiv2097867011 div.yiv2097867011file-title a:hover, #yiv2097867011 div.yiv2097867011file-title a:visited {text-decoration:none;}#yiv2097867011 div.yiv2097867011photo-title a, #yiv2097867011 div.yiv2097867011photo-title a:active, #yiv2097867011 div.yiv2097867011photo-title a:hover, #yiv2097867011 div.yiv2097867011photo-title a:visited {text-decoration:none;}#yiv2097867011 div#yiv2097867011ygrp-mlmsg #yiv2097867011ygrp-msg p a span.yiv2097867011yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2097867011 .yiv2097867011green {color:#628c2a;}#yiv2097867011 .yiv2097867011MsoNormal {margin:0 0 0 0;}#yiv2097867011 o {font-size:0;}#yiv2097867011 #yiv2097867011photos div {float:left;width:72px;}#yiv2097867011 #yiv2097867011photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv2097867011 #yiv2097867011photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2097867011 #yiv2097867011reco-category {font-size:77%;}#yiv2097867011 #yiv2097867011reco-desc {font-size:77%;}#yiv2097867011 .yiv2097867011replbq {margin:4px;}#yiv2097867011 #yiv2097867011ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2097867011 #yiv2097867011ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2097867011 #yiv2097867011ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2097867011 #yiv2097867011ygrp-mlmsg select, #yiv2097867011 input, #yiv2097867011 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2097867011 #yiv2097867011ygrp-mlmsg pre, #yiv2097867011 code {font:115% monospace;}#yiv2097867011 #yiv2097867011ygrp-mlmsg * {line-height:1..22em;}#yiv2097867011 #yiv2097867011ygrp-mlmsg #yiv2097867011logo {padding-bottom:10px;}#yiv2097867011 #yiv2097867011ygrp-msg p a {font-family:Verdana;}#yiv2097867011 #yiv2097867011ygrp-msg p#yiv2097867011attach-count span {color:#1E66AE;font-weight:700;}#yiv2097867011 #yiv2097867011ygrp-reco #yiv2097867011reco-head {color:#ff7900;font-weight:700;}#yiv2097867011 #yiv2097867011ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2097867011 #yiv2097867011ygrp-sponsor #yiv2097867011ov li a {font-size:130%;text-decoration:none;}#yiv2097867011 #yiv2097867011ygrp-sponsor #yiv2097867011ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2097867011 #yiv2097867011ygrp-sponsor #yiv2097867011ov ul {margin:0;padding:0 0 0 8px;}#yiv2097867011 #yiv2097867011ygrp-text {font-family:Georgia;}#yiv2097867011 #yiv2097867011ygrp-text p {margin:0 0 1em 0;}#yiv2097867011 #yiv2097867011ygrp-text tt {font-size:120%;}#yiv2097867011 #yiv2097867011ygrp-vital ul li:last-child {border-right:none !important;}#yiv2097867011

Reply to sender . Reply to group . Reply via Web Post . All Messages (9) . Top ^

2c

Re: rumus loncat

Mon Jul 30, 2018 3:04 am (PDT) . Posted by:

"hendrik karnadi" hendrikkarnadi

Coba ketik =IF(OR(A3="'-",A3=""),C2,A3) di sel C3, kemudian copy ke bawah.
Salam,HK

On Monday, 30 July 2018, 4:24:51 PM GMT+7, roy sumarna rohendi_2000@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com> wrote:

 

yth. master excel..
saya punya masalah.. yaitu bagaimana rumus mengcopy data
yang loncat loncat.. terlampir..
sebelumnya
saya ucapkan terima kasih

Reply to sender . Reply to group . Reply via Web Post . All Messages (9) . Top ^

2d

Bls: [belajar-excel] rumus loncat

Mon Jul 30, 2018 3:10 am (PDT) . Posted by:

"odong nando"

modifikasi if if an nya mr HK,
=IF((A3="")+(A3="'-");C2;A3)

bila komputer setempat beregional english ubah titik koma ";" menjadi koma ",". br,

odong nando

Dari: "hendrik karnadi hendrikkarnadi@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
Kepada: "roy sumarna rohendi_2000@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com>
Dikirim: Senin, 30 Juli 2018 17:05
Judul: Re: [belajar-excel] rumus loncat

  Coba ketik =IF(OR(A3="'-",A3=""),C2,A3) di sel C3, kemudian copy ke bawah.
Salam,HK

On Monday, 30 July 2018, 4:24:51 PM GMT+7, roy sumarna rohendi_2000@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com> wrote:

  yth. master excel..
saya punya masalah.. yaitu bagaimana rumus mengcopy data
yang loncat loncat.. terlampir..
sebelumnya
saya ucapkan terima kasih
#yiv3880803063 #yiv3880803063 -- #yiv3880803063ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3880803063 #yiv3880803063ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3880803063 #yiv3880803063ygrp-mkp #yiv3880803063hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3880803063 #yiv3880803063ygrp-mkp #yiv3880803063ads {margin-bottom:10px;}#yiv3880803063 #yiv3880803063ygrp-mkp .yiv3880803063ad {padding:0 0;}#yiv3880803063 #yiv3880803063ygrp-mkp .yiv3880803063ad p {margin:0;}#yiv3880803063 #yiv3880803063ygrp-mkp .yiv3880803063ad a {color:#0000ff;text-decoration:none;}#yiv3880803063 #yiv3880803063ygrp-sponsor #yiv3880803063ygrp-lc {font-family:Arial;}#yiv3880803063 #yiv3880803063ygrp-sponsor #yiv3880803063ygrp-lc #yiv3880803063hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3880803063 #yiv3880803063ygrp-sponsor #yiv3880803063ygrp-lc .yiv3880803063ad {margin-bottom:10px;padding:0 0;}#yiv3880803063 #yiv3880803063actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3880803063 #yiv3880803063activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3880803063 #yiv3880803063activity span {font-weight:700;}#yiv3880803063 #yiv3880803063activity span:first-child {text-transform:uppercase;}#yiv3880803063 #yiv3880803063activity span a {color:#5085b6;text-decoration:none;}#yiv3880803063 #yiv3880803063activity span span {color:#ff7900;}#yiv3880803063 #yiv3880803063activity span .yiv3880803063underline {text-decoration:underline;}#yiv3880803063 .yiv3880803063attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3880803063 .yiv3880803063attach div a {text-decoration:none;}#yiv3880803063 .yiv3880803063attach img {border:none;padding-right:5px;}#yiv3880803063 .yiv3880803063attach label {display:block;margin-bottom:5px;}#yiv3880803063 .yiv3880803063attach label a {text-decoration:none;}#yiv3880803063 blockquote {margin:0 0 0 4px;}#yiv3880803063 .yiv3880803063bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3880803063 .yiv3880803063bold a {text-decoration:none;}#yiv3880803063 dd.yiv3880803063last p a {font-family:Verdana;font-weight:700;}#yiv3880803063 dd.yiv3880803063last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3880803063 dd.yiv3880803063last p span.yiv3880803063yshortcuts {margin-right:0;}#yiv3880803063 div.yiv3880803063attach-table div div a {text-decoration:none;}#yiv3880803063 div.yiv3880803063attach-table {width:400px;}#yiv3880803063 div.yiv3880803063file-title a, #yiv3880803063 div.yiv3880803063file-title a:active, #yiv3880803063 div.yiv3880803063file-title a:hover, #yiv3880803063 div.yiv3880803063file-title a:visited {text-decoration:none;}#yiv3880803063 div.yiv3880803063photo-title a, #yiv3880803063 div.yiv3880803063photo-title a:active, #yiv3880803063 div.yiv3880803063photo-title a:hover, #yiv3880803063 div.yiv3880803063photo-title a:visited {text-decoration:none;}#yiv3880803063 div#yiv3880803063ygrp-mlmsg #yiv3880803063ygrp-msg p a span.yiv3880803063yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3880803063 .yiv3880803063green {color:#628c2a;}#yiv3880803063 .yiv3880803063MsoNormal {margin:0 0 0 0;}#yiv3880803063 o {font-size:0;}#yiv3880803063 #yiv3880803063photos div {float:left;width:72px;}#yiv3880803063 #yiv3880803063photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv3880803063 #yiv3880803063photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3880803063 #yiv3880803063reco-category {font-size:77%;}#yiv3880803063 #yiv3880803063reco-desc {font-size:77%;}#yiv3880803063 .yiv3880803063replbq {margin:4px;}#yiv3880803063 #yiv3880803063ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3880803063 #yiv3880803063ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3880803063 #yiv3880803063ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3880803063 #yiv3880803063ygrp-mlmsg select, #yiv3880803063 input, #yiv3880803063 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3880803063 #yiv3880803063ygrp-mlmsg pre, #yiv3880803063 code {font:115% monospace;}#yiv3880803063 #yiv3880803063ygrp-mlmsg * {line-height:1.22em;}#yiv3880803063 #yiv3880803063ygrp-mlmsg #yiv3880803063logo {padding-bottom:10px;}#yiv3880803063 #yiv3880803063ygrp-msg p a {font-family:Verdana;}#yiv3880803063 #yiv3880803063ygrp-msg p#yiv3880803063attach-count span {color:#1E66AE;font-weight:700;}#yiv3880803063 #yiv3880803063ygrp-reco #yiv3880803063reco-head {color:#ff7900;font-weight:700;}#yiv3880803063 #yiv3880803063ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3880803063 #yiv3880803063ygrp-sponsor #yiv3880803063ov li a {font-size:130%;text-decoration:none;}#yiv3880803063 #yiv3880803063ygrp-sponsor #yiv3880803063ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3880803063 #yiv3880803063ygrp-sponsor #yiv3880803063ov ul {margin:0;padding:0 0 0 8px;}#yiv3880803063 #yiv3880803063ygrp-text {font-family:Georgia;}#yiv3880803063 #yiv3880803063ygrp-text p {margin:0 0 1em 0;}#yiv3880803063 #yiv3880803063ygrp-text tt {font-size:120%;}#yiv3880803063 #yiv3880803063ygrp-vital ul li:last-child {border-right:none !important;}#yiv3880803063

Reply to sender . Reply to group . Reply via Web Post . All Messages (9) . Top ^

2e

Re: rumus loncat [1 Attachment]

Mon Jul 30, 2018 5:53 pm (PDT) . Posted by:

"ghozi alkatiri" ghozialkatiri

tulis di C2=IF(LEN(A2)>3,A2,C1)

copy ke  bawah
Pada Senin, 30 Juli 2018 16.25.07 WIB, roy sumarna rohendi_2000@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

 

yth. master excel..
saya punya masalah.. yaitu bagaimana rumus mengcopy data
yang loncat loncat.. terlampir..
sebelumnya
saya ucapkan terima kasih
#yiv8882902639 #yiv8882902639 -- #yiv8882902639ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8882902639 #yiv8882902639ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8882902639 #yiv8882902639ygrp-mkp #yiv8882902639hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8882902639 #yiv8882902639ygrp-mkp #yiv8882902639ads {margin-bottom:10px;}#yiv8882902639 #yiv8882902639ygrp-mkp .yiv8882902639ad {padding:0 0;}#yiv8882902639 #yiv8882902639ygrp-mkp .yiv8882902639ad p {margin:0;}#yiv8882902639 #yiv8882902639ygrp-mkp .yiv8882902639ad a {color:#0000ff;text-decoration:none;}#yiv8882902639 #yiv8882902639ygrp-sponsor #yiv8882902639ygrp-lc {font-family:Arial;}#yiv8882902639 #yiv8882902639ygrp-sponsor #yiv8882902639ygrp-lc #yiv8882902639hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8882902639 #yiv8882902639ygrp-sponsor #yiv8882902639ygrp-lc .yiv8882902639ad {margin-bottom:10px;padding:0 0;}#yiv8882902639 #yiv8882902639actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8882902639 #yiv8882902639activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8882902639 #yiv8882902639activity span {font-weight:700;}#yiv8882902639 #yiv8882902639activity span:first-child {text-transform:uppercase;}#yiv8882902639 #yiv8882902639activity span a {color:#5085b6;text-decoration:none;}#yiv8882902639 #yiv8882902639activity span span {color:#ff7900;}#yiv8882902639 #yiv8882902639activity span .yiv8882902639underline {text-decoration:underline;}#yiv8882902639 .yiv8882902639attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8882902639 .yiv8882902639attach div a {text-decoration:none;}#yiv8882902639 .yiv8882902639attach img {border:none;padding-right:5px;}#yiv8882902639 .yiv8882902639attach label {display:block;margin-bottom:5px;}#yiv8882902639 .yiv8882902639attach label a {text-decoration:none;}#yiv8882902639 blockquote {margin:0 0 0 4px;}#yiv8882902639 .yiv8882902639bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8882902639 .yiv8882902639bold a {text-decoration:none;}#yiv8882902639 dd.yiv8882902639last p a {font-family:Verdana;font-weight:700;}#yiv8882902639 dd.yiv8882902639last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8882902639 dd.yiv8882902639last p span.yiv8882902639yshortcuts {margin-right:0;}#yiv8882902639 div.yiv8882902639attach-table div div a {text-decoration:none;}#yiv8882902639 div.yiv8882902639attach-table {width:400px;}#yiv8882902639 div.yiv8882902639file-title a, #yiv8882902639 div.yiv8882902639file-title a:active, #yiv8882902639 div.yiv8882902639file-title a:hover, #yiv8882902639 div.yiv8882902639file-title a:visited {text-decoration:none;}#yiv8882902639 div.yiv8882902639photo-title a, #yiv8882902639 div.yiv8882902639photo-title a:active, #yiv8882902639 div.yiv8882902639photo-title a:hover, #yiv8882902639 div.yiv8882902639photo-title a:visited {text-decoration:none;}#yiv8882902639 div#yiv8882902639ygrp-mlmsg #yiv8882902639ygrp-msg p a span.yiv8882902639yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8882902639 .yiv8882902639green {color:#628c2a;}#yiv8882902639 .yiv8882902639MsoNormal {margin:0 0 0 0;}#yiv8882902639 o {font-size:0;}#yiv8882902639 #yiv8882902639photos div {float:left;width:72px;}#yiv8882902639 #yiv8882902639photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv8882902639 #yiv8882902639photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8882902639 #yiv8882902639reco-category {font-size:77%;}#yiv8882902639 #yiv8882902639reco-desc {font-size:77%;}#yiv8882902639 .yiv8882902639replbq {margin:4px;}#yiv8882902639 #yiv8882902639ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8882902639 #yiv8882902639ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8882902639 #yiv8882902639ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8882902639 #yiv8882902639ygrp-mlmsg select, #yiv8882902639 input, #yiv8882902639 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8882902639 #yiv8882902639ygrp-mlmsg pre, #yiv8882902639 code {font:115% monospace;}#yiv8882902639 #yiv8882902639ygrp-mlmsg * {line-height:1..22em;}#yiv8882902639 #yiv8882902639ygrp-mlmsg #yiv8882902639logo {padding-bottom:10px;}#yiv8882902639 #yiv8882902639ygrp-msg p a {font-family:Verdana;}#yiv8882902639 #yiv8882902639ygrp-msg p#yiv8882902639attach-count span {color:#1E66AE;font-weight:700;}#yiv8882902639 #yiv8882902639ygrp-reco #yiv8882902639reco-head {color:#ff7900;font-weight:700;}#yiv8882902639 #yiv8882902639ygrp-reco {margin-bottom:20px;padding:0px;}#yiv8882902639 #yiv8882902639ygrp-sponsor #yiv8882902639ov li a {font-size:130%;text-decoration:none;}#yiv8882902639 #yiv8882902639ygrp-sponsor #yiv8882902639ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv8882902639 #yiv8882902639ygrp-sponsor #yiv8882902639ov ul {margin:0;padding:0 0 0 8px;}#yiv8882902639 #yiv8882902639ygrp-text {font-family:Georgia;}#yiv8882902639 #yiv8882902639ygrp-text p {margin:0 0 1em 0;}#yiv8882902639 #yiv8882902639ygrp-text tt {font-size:120%;}#yiv8882902639 #yiv8882902639ygrp-vital ul li:last-child {border-right:none !important;}#yiv8882902639

Reply to sender . Reply to group . Reply via Web Post . All Messages (9) . Top ^

2f

Fw: Re: [belajar-excel] rumus loncat

Mon Jul 30, 2018 6:49 pm (PDT) . Posted by:

"roy sumarna" rohendi_2000

C1.. merupakan nilai yg diinginkan..

----- Pesan yang Diteruskan ----- Dari: ghozi alkatiri ghozialkatiri@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com>Kepada: roy sumarna rohendi_2000@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com>Terkirim: Selasa, 31 Juli 2018 07.53.29 GMT+7Judul: Re: [belajar-excel] rumus loncat
 

tulis di C2=IF(LEN(A2)>3,A2,C1)

copy ke  bawah
Pada Senin, 30 Juli 2018 16.25.07 WIB, roy sumarna rohendi_2000@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

 

yth. master excel..
saya punya masalah.. yaitu bagaimana rumus mengcopy data
yang loncat loncat.. terlampir...
sebelumnya
saya ucapkan terima kasih

Reply to sender . Reply to group . Reply via Web Post . All Messages (9) . Top ^

2g

Fw: Bls: [belajar-excel] rumus loncat

Mon Jul 30, 2018 6:49 pm (PDT) . Posted by:

"roy sumarna" rohendi_2000

yg diinginkan seperti terlampir.. adapun anak, istri dll ga ada kaitannya. dengan soAL.
masih. atas bantuannya.

roy

----- Pesan yang Diteruskan ----- Dari: odong nando odongnando@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com>Kepada: belajar-excel@yahoogroups.com <belajar-excel@yahoogroups.com>Terkirim: Senin, 30 Juli 2018 17.10.59 GMT+7Judul: Bls: [belajar-excel] rumus loncat
 

modifikasi if if an nya mr HK,
=IF((A3="")+(A3="'-");C2;A3)

bila komputer setempat beregional english ubah titik koma ";" menjadi koma ",". br,

odong nando

Dari: "hendrik karnadi hendrikkarnadi@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
Kepada: "roy sumarna rohendi_2000@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com>
Dikirim: Senin, 30 Juli 2018 17:05
Judul: Re: [belajar-excel] rumus loncat

  Coba ketik =IF(OR(A3="'-",A3=""),C2,A3) di sel C3, kemudian copy ke bawah.
Salam,HK

On Monday, 30 July 2018, 4:24:51 PM GMT+7, roy sumarna rohendi_2000@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com> wrote:

  yth. master excel..
saya punya masalah.. yaitu bagaimana rumus mengcopy data
yang loncat loncat.. terlampir..
sebelumnya
saya ucapkan terima kasih

Reply to sender . Reply to group . Reply via Web Post . All Messages (9) . Top ^

2h

Fw: Re: [belajar-excel] rumus loncat

Mon Jul 30, 2018 7:14 pm (PDT) . Posted by:

"roy sumarna" rohendi_2000

makasih.. dah masuk rumusnya..

----- Pesan yang Diteruskan ----- Dari: hendrik karnadi hendrikkarnadi@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com>Kepada: roy sumarna rohendi_2000@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com>Terkirim: Senin, 30 Juli 2018 17.05.13 GMT+7Judul: Re: [belajar-excel] rumus loncat
 

Coba ketik =IF(OR(A3="'-",A3=""),C2,A3) di sel C3, kemudian copy ke bawah.
Salam,HK

On Monday, 30 July 2018, 4:24:51 PM GMT+7, roy sumarna rohendi_2000@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com> wrote:

 

yth. master excel..
saya punya masalah.. yaitu bagaimana rumus mengcopy data
yang loncat loncat.. terlampir..
sebelumnya
saya ucapkan terima kasih

Reply to sender . Reply to group . Reply via Web Post . All Messages (9) . Top ^

2i

Fw: Re: [belajar-excel] rumus loncat

Mon Jul 30, 2018 8:32 pm (PDT) . Posted by:

"roy sumarna" rohendi_2000

IYA. MAKASIH.. MAS HENDRIK..

----- Pesan yang Diteruskan ----- Dari: roy sumarna rohendi_2000@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com>Kepada: "belajar-excel@yahoogroups.com" <belajar-excel@yahoogroups.com>Terkirim: Selasa, 31 Juli 2018 09.14.27 GMT+7Judul: Fw: Re: [belajar-excel] rumus loncat
 

makasih.. dah masuk rumusnya..

----- Pesan yang Diteruskan ----- Dari: hendrik karnadi hendrikkarnadi@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com>Kepada: roy sumarna rohendi_2000@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com>Terkirim: Senin, 30 Juli 2018 17.05.13 GMT+7Judul: Re: [belajar-excel] rumus loncat
 

Coba ketik =IF(OR(A3="'-",A3=""),C2,A3) di sel C3, kemudian copy ke bawah.
Salam,HK

On Monday, 30 July 2018, 4:24:51 PM GMT+7, roy sumarna rohendi_2000@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com> wrote:

 

yth. master excel..
saya punya masalah.. yaitu bagaimana rumus mengcopy data
yang loncat loncat.. terlampir..
sebelumnya
saya ucapkan terima kasih

Reply to sender . Reply to group . Reply via Web Post . All Messages (9) . Top ^

============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com
posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com
berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com
keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------

Visit Your Group

• Privacy • Unsubscribe • Terms of Use