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 > >
