Re: Bls: [belajar-excel] memilih nilai pada sheet tertentu

hendrik karnadi [email protected] [belajar-excel] Wed, 15 Feb 2017 00:01:08 -0800

Hai Cety,Bisa lihat contohnya diINDIRECT (Fungsi INDIRECT) - Dukungan Office  
|  
|   
|   
|   |    |


   |

  |
|  
|   |  
INDIRECT (Fungsi INDIRECT) - Dukungan Office
 
Artikel ini menguraikan sintaks rumus dan penggunaan fungsi INDIRECT di 
Microsoft Excel.
  |   |

  |

  |

  
Salam,HK


Sent from Yahoo Mail on Android 
 
  On Tue, Feb 14, 2017 at 20:03, Cety Carmelo Julita [email protected] 
[belajar-excel]<[email protected]> wrote:       


Makasih atas bantuan semua suhu. Bolehkah saya minta sedikit penjelasan 
mengenai penggunaan formula indirect? Sesuaikan dengan konteks pertanyaan saya 
biar sya lebih paham. Supaya bila ada kasus yang sama atau hampir sama saya 
mudah menggunakannya. Makasih sebelumnya.

  
--
 Sent from myMail for Android
Minggu, 12 Februari 2017, 04:32PM +09:00 from ghozi alkatiri 
[email protected] [belajar-excel] [email protected]:


        
tulis di B2 
=INDIRECT($I$2"!B"&ROW(1:1))
copy ke bawah 

wassalam

Ghozi Alkatiri
--------------------------------------------
Pada Sab, 11/2/17, Cety Carmelo Julita [email protected] [belajar-excel] 
<[email protected]> menulis:

Judul: [belajar-excel] memilih nilai pada sheet tertentu [1 Attachment]
 Kepada: [email protected]
 Tanggal: Sabtu, 11 Februari, 2017, 12:05 PM
 
 
  
 
 
 
 
 
 
 
 
 
 
 Selamat siang para
 suhu, saya punya masalah formula excel seperti pada
 lampiran. Mohon bantuannya. Makasih
 
 
 
 
 
 
 
 
 
 
 #yiv9320867305 #yiv9320867305 --
 #yiv9320867305ygrp-mkp {
 border:1px solid #d8d8d8;font-family:Arial;margin:10px
 0;padding:0 10px;}
 
 #yiv9320867305 #yiv9320867305ygrp-mkp hr {
 border:1px solid #d8d8d8;}
 
 #yiv9320867305 #yiv9320867305ygrp-mkp #yiv9320867305hd {
 color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
 0;}
 
 #yiv9320867305 #yiv9320867305ygrp-mkp #yiv9320867305ads {
 margin-bottom:10px;}
 
 #yiv9320867305 #yiv9320867305ygrp-mkp .yiv9320867305ad {
 padding:0 0;}
 
 #yiv9320867305 #yiv9320867305ygrp-mkp .yiv9320867305ad p {
 margin:0;}
 
 #yiv9320867305 #yiv9320867305ygrp-mkp .yiv9320867305ad a {
 color:#0000ff;text-decoration:none;}
 #yiv9320867305 #yiv9320867305ygrp-sponsor
 #yiv9320867305ygrp-lc {
 font-family:Arial;}
 
 #yiv9320867305 #yiv9320867305ygrp-sponsor
 #yiv9320867305ygrp-lc #yiv9320867305hd {
 margin:10px
 0px;font-weight:700;font-size:78%;line-height:122%;}
 
 #yiv9320867305 #yiv9320867305ygrp-sponsor
 #yiv9320867305ygrp-lc .yiv9320867305ad {
 margin-bottom:10px;padding:0 0;}
 
 #yiv9320867305 #yiv9320867305actions {
 font-family:Verdana;font-size:11px;padding:10px 0;}
 
 #yiv9320867305 #yiv9320867305activity {
 
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}
 
 #yiv9320867305 #yiv9320867305activity span {
 font-weight:700;}
 
 #yiv9320867305 #yiv9320867305activity span:first-child {
 text-transform:uppercase;}
 
 #yiv9320867305 #yiv9320867305activity span a {
 color:#5085b6;text-decoration:none;}
 
 #yiv9320867305 #yiv9320867305activity span span {
 color:#ff7900;}
 
 #yiv9320867305 #yiv9320867305activity span
 .yiv9320867305underline {
 text-decoration:underline;}
 
 #yiv9320867305 .yiv9320867305attach {
 clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
 0;width:400px;}
 
 #yiv9320867305 .yiv9320867305attach div a {
 text-decoration:none;}
 
 #yiv9320867305 .yiv9320867305attach img {
 border:none;padding-right:5px;}
 
 #yiv9320867305 .yiv9320867305attach label {
 display:block;margin-bottom:5px;}
 
 #yiv9320867305 .yiv9320867305attach label a {
 text-decoration:none;}
 
 #yiv9320867305 blockquote {
 margin:0 0 0 4px;}
 
 #yiv9320867305 .yiv9320867305bold {
 font-family:Arial;font-size:13px;font-weight:700;}
 
 #yiv9320867305 .yiv9320867305bold a {
 text-decoration:none;}
 
 #yiv9320867305 dd.yiv9320867305last p a {
 font-family:Verdana;font-weight:700;}
 
 #yiv9320867305 dd.yiv9320867305last p span {
 margin-right:10px;font-family:Verdana;font-weight:700;}
 
 #yiv9320867305 dd.yiv9320867305last p
 span.yiv9320867305yshortcuts {
 margin-right:0;}
 
 #yiv9320867305 div.yiv9320867305attach-table div div a {
 text-decoration:none;}
 
 #yiv9320867305 div.yiv9320867305attach-table {
 width:400px;}
 
 #yiv9320867305 div.yiv9320867305file-title a, #yiv9320867305
 div.yiv9320867305file-title a:active, #yiv9320867305
 div.yiv9320867305file-title a:hover, #yiv9320867305
 div.yiv9320867305file-title a:visited {
 text-decoration:none;}
 
 #yiv9320867305 div.yiv9320867305photo-title a,
 #yiv9320867305 div.yiv9320867305photo-title a:active,
 #yiv9320867305 div.yiv9320867305photo-title a:hover,
 #yiv9320867305 div.yiv9320867305photo-title a:visited {
 text-decoration:none;}
 
 #yiv9320867305 div#yiv9320867305ygrp-mlmsg
 #yiv9320867305ygrp-msg p a span.yiv9320867305yshortcuts {
 font-family:Verdana;font-size:10px;font-weight:normal;}
 
 #yiv9320867305 .yiv9320867305green {
 color:#628c2a;}
 
 #yiv9320867305 .yiv9320867305MsoNormal {
 margin:0 0 0 0;}
 
 #yiv9320867305 o {
 font-size:0;}
 
 #yiv9320867305 #yiv9320867305photos div {
 float:left;width:72px;}
 
 #yiv9320867305 #yiv9320867305photos div div {
 border:1px solid
 #666666;height:62px;overflow:hidden;width:62px;}
 
 #yiv9320867305 #yiv9320867305photos div label {
 
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}
 
 #yiv9320867305 #yiv9320867305reco-category {
 font-size:77%;}
 
 #yiv9320867305 #yiv9320867305reco-desc {
 font-size:77%;}
 
 #yiv9320867305 .yiv9320867305replbq {
 margin:4px;}
 
 #yiv9320867305 #yiv9320867305ygrp-actbar div a:first-child {
 margin-right:2px;padding-right:5px;}
 
 #yiv9320867305 #yiv9320867305ygrp-mlmsg {
 font-size:13px;font-family:Arial, helvetica, clean,
 sans-serif;}
 
 #yiv9320867305 #yiv9320867305ygrp-mlmsg table {
 font-size:inherit;font:100%;}
 
 #yiv9320867305 #yiv9320867305ygrp-mlmsg select,
 #yiv9320867305 input, #yiv9320867305 textarea {
 font:99% Arial, Helvetica, clean, sans-serif;}
 
 #yiv9320867305 #yiv9320867305ygrp-mlmsg pre, #yiv9320867305
 code {
 font:115% monospace;}
 
 #yiv9320867305 #yiv9320867305ygrp-mlmsg * {
 line-height:1.22em;}
 
 #yiv9320867305 #yiv9320867305ygrp-mlmsg #yiv9320867305logo {
 padding-bottom:10px;}
 
 
 #yiv9320867305 #yiv9320867305ygrp-msg p a {
 font-family:Verdana;}
 
 #yiv9320867305 #yiv9320867305ygrp-msg
 p#yiv9320867305attach-count span {
 color:#1E66AE;font-weight:700;}
 
 #yiv9320867305 #yiv9320867305ygrp-reco
 #yiv9320867305reco-head {
 color:#ff7900;font-weight:700;}
 
 #yiv9320867305 #yiv9320867305ygrp-reco {
 margin-bottom:20px;padding:0px;}
 
 #yiv9320867305 #yiv9320867305ygrp-sponsor #yiv9320867305ov
 li a {
 font-size:130%;text-decoration:none;}
 
 #yiv9320867305 #yiv9320867305ygrp-sponsor #yiv9320867305ov
 li {
 font-size:77%;list-style-type:square;padding:6px 0;}
 
 #yiv9320867305 #yiv9320867305ygrp-sponsor #yiv9320867305ov
 ul {
 margin:0;padding:0 0 0 8px;}
 
 #yiv9320867305 #yiv9320867305ygrp-text {
 font-family:Georgia;}
 
 #yiv9320867305 #yiv9320867305ygrp-text p {
 margin:0 0 1em 0;}
 
 #yiv9320867305 #yiv9320867305ygrp-text tt {
 font-size:120%;}
 
 #yiv9320867305 #yiv9320867305ygrp-vital ul li:last-child {
 border-right:none !important;
 }
 #yiv9320867305

Re: Bls: [belajar-excel] memilih nilai pada sheet tertentu

Kirim email ke