Kamis, 11 Mei 2017

[belajar-excel] Digest Number 4181

5 Messages

Digest #4181

Messages

Wed May 10, 2017 8:50 pm (PDT) . Posted by:

"Agus W" agus_1194

Kepada Yang Terhormat Para Master eXcel,
Sekiranya murid yang fakir ini Mohon bantuannya, insun/saya bingung harus dimana lagi bertanya kalau bukan di sinijadi ceritanya insun dapat tugas baru dari atasan insun yang baru untuk membuat data pinjaman karyawan dengan jumlah data mencapai ratusan bahkan ribuan baris untuk diselesaikan dengan secepat mungkin. ini sedikit insun kasih contoh data yang sedang insun kerjakan. Mohon kiranya agar para Suhu Sepuh maupun Suhu Muda agar mau turun gunung untuk bisa membantu kesulitan dari murid yang masih baru ini.Atas perhatian serta pertolongannya insun ucapkan jazakumullah khairan semoga menjadi amal Jariyah buat para Suhu Master sekaliyan.
Salam,Guswie

Thu May 11, 2017 6:58 pm (PDT) . Posted by:

"nangagus"

Saya juga masih belajar excel gak bisa-bisa.
Datanya digunakan tabel excel biar menjadi data yang dinamis (jika
datanya ditambah maka otomatis hasilnya juga otomatis bertambah)
Hanya saja formula yang disarankan belum dilengkapi dengan trap error,
silahkan ditambahkan formula IFERROR agar cell tampak kosong kalau error.

salam
NangAgus

On 11/05/17 10.50, Agus W agus_1194@yahoo.co.id [belajar-excel] wrote:
> Kepada Yang Terhormat Para Master eXcel,
>
> Sekiranya murid yang fakir ini Mohon bantuannya, insun/saya bingung
> harus dimana lagi bertanya kalau bukan di sini
> jadi ceritanya insun dapat tugas baru dari atasan insun yang baru
> untuk membuat data pinjaman karyawan dengan jumlah data mencapai
> ratusan bahkan ribuan baris untuk diselesaikan dengan secepat mungkin.
> ini sedikit insun kasih contoh data yang sedang insun kerjakan. Mohon
> kiranya agar para Suhu Sepuh maupun Suhu Muda agar mau turun gunung
> untuk bisa membantu kesulitan dari murid yang masih baru ini.
> Atas perhatian serta pertolongannya insun ucapkan jazakumullah khairan
> semoga menjadi amal Jariyah buat para Suhu Master sekaliyan.
>
> Salam,
> Guswie
>
>

Wed May 10, 2017 10:33 pm (PDT) . Posted by:

"HAIRUL ALAM"

Yang TerhormatMr.Kid
Bagaimana bila pada cell T1 tidak ada kode / cell kosong dapatkah oada cell A1 nilainya juga kosong atau ""
TerimakasihSalamHairul Alam

Pada Kamis, 11 Mei 2017 1:55, "'Mr. Kid' mr.nmkid@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Kalau di cells T1 ada isi teks berbunyi "1a2a3", maka jumlah angka di cells a1 dengan formula                      Len( T1 ) - Len( Substitute( T1 , "a" , "" ) ) + 1
2017-05-10 22:31 GMT+07:00 HAIRUL ALAM ha_mj76@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com>:

  Assalamualaikum Wr. Wb.Para Master
Menjumlahkan karakter pada Cell A2 bisa dengan misal " = LEN (A2) " menjumlahkan kata 1 kata Cell A2 bisa dengan " counta (A2) " bagaimana formula bila menjumlahkan 2 kata atau lebih pada Cell (A2) "H01, H02, H03" seperti data terlampir..
Terimakasih Banyak Pencerahannya
Hairul Alam

#yiv3098995578 #yiv3098995578 -- #yiv3098995578ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3098995578 #yiv3098995578ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3098995578 #yiv3098995578ygrp-mkp #yiv3098995578hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3098995578 #yiv3098995578ygrp-mkp #yiv3098995578ads {margin-bottom:10px;}#yiv3098995578 #yiv3098995578ygrp-mkp .yiv3098995578ad {padding:0 0;}#yiv3098995578 #yiv3098995578ygrp-mkp .yiv3098995578ad p {margin:0;}#yiv3098995578 #yiv3098995578ygrp-mkp .yiv3098995578ad a {color:#0000ff;text-decoration:none;}#yiv3098995578 #yiv3098995578ygrp-sponsor #yiv3098995578ygrp-lc {font-family:Arial;}#yiv3098995578 #yiv3098995578ygrp-sponsor #yiv3098995578ygrp-lc #yiv3098995578hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3098995578 #yiv3098995578ygrp-sponsor #yiv3098995578ygrp-lc .yiv3098995578ad {margin-bottom:10px;padding:0 0;}#yiv3098995578 #yiv3098995578actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3098995578 #yiv3098995578activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3098995578 #yiv3098995578activity span {font-weight:700;}#yiv3098995578 #yiv3098995578activity span:first-child {text-transform:uppercase;}#yiv3098995578 #yiv3098995578activity span a {color:#5085b6;text-decoration:none;}#yiv3098995578 #yiv3098995578activity span span {color:#ff7900;}#yiv3098995578 #yiv3098995578activity span .yiv3098995578underline {text-decoration:underline;}#yiv3098995578 .yiv3098995578attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3098995578 .yiv3098995578attach div a {text-decoration:none;}#yiv3098995578 .yiv3098995578attach img {border:none;padding-right:5px;}#yiv3098995578 .yiv3098995578attach label {display:block;margin-bottom:5px;}#yiv3098995578 .yiv3098995578attach label a {text-decoration:none;}#yiv3098995578 blockquote {margin:0 0 0 4px;}#yiv3098995578 .yiv3098995578bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3098995578 .yiv3098995578bold a {text-decoration:none;}#yiv3098995578 dd.yiv3098995578last p a {font-family:Verdana;font-weight:700;}#yiv3098995578 dd.yiv3098995578last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3098995578 dd.yiv3098995578last p span.yiv3098995578yshortcuts {margin-right:0;}#yiv3098995578 div.yiv3098995578attach-table div div a {text-decoration:none;}#yiv3098995578 div.yiv3098995578attach-table {width:400px;}#yiv3098995578 div.yiv3098995578file-title a, #yiv3098995578 div.yiv3098995578file-title a:active, #yiv3098995578 div.yiv3098995578file-title a:hover, #yiv3098995578 div.yiv3098995578file-title a:visited {text-decoration:none;}#yiv3098995578 div.yiv3098995578photo-title a, #yiv3098995578 div.yiv3098995578photo-title a:active, #yiv3098995578 div.yiv3098995578photo-title a:hover, #yiv3098995578 div.yiv3098995578photo-title a:visited {text-decoration:none;}#yiv3098995578 div#yiv3098995578ygrp-mlmsg #yiv3098995578ygrp-msg p a span.yiv3098995578yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3098995578 .yiv3098995578green {color:#628c2a;}#yiv3098995578 .yiv3098995578MsoNormal {margin:0 0 0 0;}#yiv3098995578 o {font-size:0;}#yiv3098995578 #yiv3098995578photos div {float:left;width:72px;}#yiv3098995578 #yiv3098995578photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv3098995578 #yiv3098995578photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3098995578 #yiv3098995578reco-category {font-size:77%;}#yiv3098995578 #yiv3098995578reco-desc {font-size:77%;}#yiv3098995578 .yiv3098995578replbq {margin:4px;}#yiv3098995578 #yiv3098995578ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3098995578 #yiv3098995578ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3098995578 #yiv3098995578ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3098995578 #yiv3098995578ygrp-mlmsg select, #yiv3098995578 input, #yiv3098995578 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3098995578 #yiv3098995578ygrp-mlmsg pre, #yiv3098995578 code {font:115% monospace;}#yiv3098995578 #yiv3098995578ygrp-mlmsg * {line-height:1.22em;}#yiv3098995578 #yiv3098995578ygrp-mlmsg #yiv3098995578logo {padding-bottom:10px;}#yiv3098995578 #yiv3098995578ygrp-msg p a {font-family:Verdana;}#yiv3098995578 #yiv3098995578ygrp-msg p#yiv3098995578attach-count span {color:#1E66AE;font-weight:700;}#yiv3098995578 #yiv3098995578ygrp-reco #yiv3098995578reco-head {color:#ff7900;font-weight:700;}#yiv3098995578 #yiv3098995578ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3098995578 #yiv3098995578ygrp-sponsor #yiv3098995578ov li a {font-size:130%;text-decoration:none;}#yiv3098995578 #yiv3098995578ygrp-sponsor #yiv3098995578ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3098995578 #yiv3098995578ygrp-sponsor #yiv3098995578ov ul {margin:0;padding:0 0 0 8px;}#yiv3098995578 #yiv3098995578ygrp-text {font-family:Georgia;}#yiv3098995578 #yiv3098995578ygrp-text p {margin:0 0 1em 0;}#yiv3098995578 #yiv3098995578ygrp-text tt {font-size:120%;}#yiv3098995578 #yiv3098995578ygrp-vital ul li:last-child {border-right:none !important;}#yiv3098995578

Wed May 10, 2017 10:33 pm (PDT) . Posted by:

ivan_zalukhu

Selamat pagi. Di Excel Online/Google Spreensheet kan file kerja kita, bisa sharing sama orang lain. Bagaimana caranya jika teman kita/user, jika dia sudah input data sekali maka data itu tidak bisa diganggu gugat lagi (tidak bisa dihapus, diedit) kecuali admin. Mohon dibantu kalau ada yg tau. Saya cara di google dapat yg seperti ini https://productforums.google.com/forum/#!topic/docs/gnrD6_XtZT0, gk ngerti cara pakaiannya dan juga bahasa Inggris gk lancar



Thu May 11, 2017 7:09 am (PDT) . Posted by:

"Ilyas"

Tolong dibaca dulu  :
Share files from Google Drive - Computer - Docs editors Help
|
|
|
| | |

|

|
|
| |
Share files from Google Drive - Computer - Docs editors Help

You can share the files and folders that you store in Google Drive with anyone.The people you share with will always see the most updated version of the file. If you share Google Docs, Sheets, Slide
| |

|

|

Kalau yang dimaksud data input pada kolom maka tidak bisa  tapi kalau file xls itu bisa aja


On Thu, May 11, 2017 at 14:33, ivan_zalukhu@yahoo.com [belajar-excel]<belajar-excel@yahoogroups.com> wrote:  

Selamat pagi. Di Excel Online/Google Spreensheet kan file kerja kita, bisa sharing sama orang lain.  Bagaimana caranya jika teman kita/user, jika dia sudah input data sekali maka data itu tidak bisa diganggu gugat lagi (tidak bisa dihapus, diedit) kecuali admin. Mohon dibantu kalau ada yg tau. Saya cara di google dapat yg seperti ini https://productforums.google.com/forum/#!topic/docs/gnrD6_XtZT0, gk ngerti cara pakaiannya dan juga bahasa Inggris gk lancar

#yiv4883762181 #yiv4883762181 -- #yiv4883762181ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4883762181 #yiv4883762181ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4883762181 #yiv4883762181ygrp-mkp #yiv4883762181hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv4883762181 #yiv4883762181ygrp-mkp #yiv4883762181ads {margin-bottom:10px;}#yiv4883762181 #yiv4883762181ygrp-mkp .yiv4883762181ad {padding:0 0;}#yiv4883762181 #yiv4883762181ygrp-mkp .yiv4883762181ad p {margin:0;}#yiv4883762181 #yiv4883762181ygrp-mkp .yiv4883762181ad a {color:#0000ff;text-decoration:none;}#yiv4883762181 #yiv4883762181ygrp-sponsor #yiv4883762181ygrp-lc {font-family:Arial;}#yiv4883762181 #yiv4883762181ygrp-sponsor #yiv4883762181ygrp-lc #yiv4883762181hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4883762181 #yiv4883762181ygrp-sponsor #yiv4883762181ygrp-lc .yiv4883762181ad {margin-bottom:10px;padding:0 0;}#yiv4883762181 #yiv4883762181actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4883762181 #yiv4883762181activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4883762181 #yiv4883762181activity span {font-weight:700;}#yiv4883762181 #yiv4883762181activity span:first-child {text-transform:uppercase;}#yiv4883762181 #yiv4883762181activity span a {color:#5085b6;text-decoration:none;}#yiv4883762181 #yiv4883762181activity span span {color:#ff7900;}#yiv4883762181 #yiv4883762181activity span .yiv4883762181underline {text-decoration:underline;}#yiv4883762181 .yiv4883762181attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv4883762181 .yiv4883762181attach div a {text-decoration:none;}#yiv4883762181 .yiv4883762181attach img {border:none;padding-right:5px;}#yiv4883762181 .yiv4883762181attach label {display:block;margin-bottom:5px;}#yiv4883762181 .yiv4883762181attach label a {text-decoration:none;}#yiv4883762181 blockquote {margin:0 0 0 4px;}#yiv4883762181 .yiv4883762181bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv4883762181 .yiv4883762181bold a {text-decoration:none;}#yiv4883762181 dd.yiv4883762181last p a {font-family:Verdana;font-weight:700;}#yiv4883762181 dd.yiv4883762181last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4883762181 dd.yiv4883762181last p span.yiv4883762181yshortcuts {margin-right:0;}#yiv4883762181 div.yiv4883762181attach-table div div a {text-decoration:none;}#yiv4883762181 div.yiv4883762181attach-table {width:400px;}#yiv4883762181 div.yiv4883762181file-title a, #yiv4883762181 div.yiv4883762181file-title a:active, #yiv4883762181 div.yiv4883762181file-title a:hover, #yiv4883762181 div.yiv4883762181file-title a:visited {text-decoration:none;}#yiv4883762181 div.yiv4883762181photo-title a, #yiv4883762181 div.yiv4883762181photo-title a:active, #yiv4883762181 div.yiv4883762181photo-title a:hover, #yiv4883762181 div.yiv4883762181photo-title a:visited {text-decoration:none;}#yiv4883762181 div#yiv4883762181ygrp-mlmsg #yiv4883762181ygrp-msg p a span.yiv4883762181yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4883762181 .yiv4883762181green {color:#628c2a;}#yiv4883762181 .yiv4883762181MsoNormal {margin:0 0 0 0;}#yiv4883762181 o {font-size:0;}#yiv4883762181 #yiv4883762181photos div {float:left;width:72px;}#yiv4883762181 #yiv4883762181photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv4883762181 #yiv4883762181photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4883762181 #yiv4883762181reco-category {font-size:77%;}#yiv4883762181 #yiv4883762181reco-desc {font-size:77%;}#yiv4883762181 .yiv4883762181replbq {margin:4px;}#yiv4883762181 #yiv4883762181ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv4883762181 #yiv4883762181ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4883762181 #yiv4883762181ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4883762181 #yiv4883762181ygrp-mlmsg select, #yiv4883762181 input, #yiv4883762181 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv4883762181 #yiv4883762181ygrp-mlmsg pre, #yiv4883762181 code {font:115% monospace;}#yiv4883762181 #yiv4883762181ygrp-mlmsg * {line-height:1.22em;}#yiv4883762181 #yiv4883762181ygrp-mlmsg #yiv4883762181logo {padding-bottom:10px;}#yiv4883762181 #yiv4883762181ygrp-msg p a {font-family:Verdana;}#yiv4883762181 #yiv4883762181ygrp-msg p#yiv4883762181attach-count span {color:#1E66AE;font-weight:700;}#yiv4883762181 #yiv4883762181ygrp-reco #yiv4883762181reco-head {color:#ff7900;font-weight:700;}#yiv4883762181 #yiv4883762181ygrp-reco {margin-bottom:20px;padding:0px;}#yiv4883762181 #yiv4883762181ygrp-sponsor #yiv4883762181ov li a {font-size:130%;text-decoration:none;}#yiv4883762181 #yiv4883762181ygrp-sponsor #yiv4883762181ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv4883762181 #yiv4883762181ygrp-sponsor #yiv4883762181ov ul {margin:0;padding:0 0 0 8px;}#yiv4883762181 #yiv4883762181ygrp-text {font-family:Georgia;}#yiv4883762181 #yiv4883762181ygrp-text p {margin:0 0 1em 0;}#yiv4883762181 #yiv4883762181ygrp-text tt {font-size:120%;}#yiv4883762181 #yiv4883762181ygrp-vital ul li:last-child {border-right:none !important;}#yiv4883762181
============================================================
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
---------------------------------------------------------------------

Tidak ada komentar:

Posting Komentar