Terimakasih banyak Pak
Pada Kamis, 29 Oktober 2015 17:01, "odong nando odongna...@yahoo.com
[belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
cell J4
=IF(($I$10<>"")*(COUNTIF($C$3:$C$17;$I$10)>=COLUMNS($I$2:I2));INDEX($C$3:$C$17;MATCH($I$10;$C$3:$C$17;0)+COLUMNS($I$2:I2)-1);"")bagian
C ganti dengan kolom yang akan dituju, untuk yang lokasi
br,
odong nando
Pada Kamis, 29 Oktober 2015 16:48, "HAIRUL ALAM ha_m...@yahoo.co.id
[belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Maaf Pak Odong
Masalah saya sesuai lampiran berikut, yang pertama saya ralat, maaf Pak
Pada Kamis, 29 Oktober 2015 16:20, "HAIRUL ALAM ha_m...@yahoo.co.id
[belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Terimakasih Banyak Pak Odong
Maaf Kalau saya selalu tanya, Maklum saya juga pemula
TerimakasihSalam
Pada Kamis, 29 Oktober 2015 15:38, "odong nando odongna...@yahoo.com
[belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
bisa memanfaatkan formula
=INDIRECT("F"&COLUMNS($J$2:J2)+2)
tinggal ganti F dengan kolom yang di inginkan dalam kasus ini kolom B dan E br,
odong nando
Pada Kamis, 29 Oktober 2015 15:04, "HAIRUL ALAM ha_m...@yahoo.co.id
[belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Yth. Para Master Excel
Assalamualaikum Wr. Wb.
Saya mengalami problem seperti data terlampir, Mohon Pencerahannya, agar dapat
bekerja secara otomatis dengan formula dan semoga file excel dikalkulasi dengan
ringan
Wassalamualaikum Wr. Wb.
TerimakasihHairul Alam
#yiv6819515648 #yiv6819515648 -- #yiv6819515648ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6819515648
#yiv6819515648ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6819515648
#yiv6819515648ygrp-mkp #yiv6819515648hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv6819515648 #yiv6819515648ygrp-mkp #yiv6819515648ads
{margin-bottom:10px;}#yiv6819515648 #yiv6819515648ygrp-mkp .yiv6819515648ad
{padding:0 0;}#yiv6819515648 #yiv6819515648ygrp-mkp .yiv6819515648ad p
{margin:0;}#yiv6819515648 #yiv6819515648ygrp-mkp .yiv6819515648ad a
{color:#0000ff;text-decoration:none;}#yiv6819515648 #yiv6819515648ygrp-sponsor
#yiv6819515648ygrp-lc {font-family:Arial;}#yiv6819515648
#yiv6819515648ygrp-sponsor #yiv6819515648ygrp-lc #yiv6819515648hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6819515648
#yiv6819515648ygrp-sponsor #yiv6819515648ygrp-lc .yiv6819515648ad
{margin-bottom:10px;padding:0 0;}#yiv6819515648 #yiv6819515648actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6819515648
#yiv6819515648activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6819515648
#yiv6819515648activity span {font-weight:700;}#yiv6819515648
#yiv6819515648activity span:first-child
{text-transform:uppercase;}#yiv6819515648 #yiv6819515648activity span a
{color:#5085b6;text-decoration:none;}#yiv6819515648 #yiv6819515648activity span
span {color:#ff7900;}#yiv6819515648 #yiv6819515648activity span
.yiv6819515648underline {text-decoration:underline;}#yiv6819515648
.yiv6819515648attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv6819515648 .yiv6819515648attach div a
{text-decoration:none;}#yiv6819515648 .yiv6819515648attach img
{border:none;padding-right:5px;}#yiv6819515648 .yiv6819515648attach label
{display:block;margin-bottom:5px;}#yiv6819515648 .yiv6819515648attach label a
{text-decoration:none;}#yiv6819515648 blockquote {margin:0 0 0
4px;}#yiv6819515648 .yiv6819515648bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv6819515648
.yiv6819515648bold a {text-decoration:none;}#yiv6819515648 dd.yiv6819515648last
p a {font-family:Verdana;font-weight:700;}#yiv6819515648 dd.yiv6819515648last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6819515648
dd.yiv6819515648last p span.yiv6819515648yshortcuts
{margin-right:0;}#yiv6819515648 div.yiv6819515648attach-table div div a
{text-decoration:none;}#yiv6819515648 div.yiv6819515648attach-table
{width:400px;}#yiv6819515648 div.yiv6819515648file-title a, #yiv6819515648
div.yiv6819515648file-title a:active, #yiv6819515648
div.yiv6819515648file-title a:hover, #yiv6819515648 div.yiv6819515648file-title
a:visited {text-decoration:none;}#yiv6819515648 div.yiv6819515648photo-title a,
#yiv6819515648 div.yiv6819515648photo-title a:active, #yiv6819515648
div.yiv6819515648photo-title a:hover, #yiv6819515648
div.yiv6819515648photo-title a:visited {text-decoration:none;}#yiv6819515648
div#yiv6819515648ygrp-mlmsg #yiv6819515648ygrp-msg p a
span.yiv6819515648yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6819515648
.yiv6819515648green {color:#628c2a;}#yiv6819515648 .yiv6819515648MsoNormal
{margin:0 0 0 0;}#yiv6819515648 o {font-size:0;}#yiv6819515648
#yiv6819515648photos div {float:left;width:72px;}#yiv6819515648
#yiv6819515648photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv6819515648
#yiv6819515648photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6819515648
#yiv6819515648reco-category {font-size:77%;}#yiv6819515648
#yiv6819515648reco-desc {font-size:77%;}#yiv6819515648 .yiv6819515648replbq
{margin:4px;}#yiv6819515648 #yiv6819515648ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv6819515648 #yiv6819515648ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6819515648
#yiv6819515648ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6819515648
#yiv6819515648ygrp-mlmsg select, #yiv6819515648 input, #yiv6819515648 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv6819515648
#yiv6819515648ygrp-mlmsg pre, #yiv6819515648 code {font:115%
monospace;}#yiv6819515648 #yiv6819515648ygrp-mlmsg *
{line-height:1.22em;}#yiv6819515648 #yiv6819515648ygrp-mlmsg #yiv6819515648logo
{padding-bottom:10px;}#yiv6819515648 #yiv6819515648ygrp-msg p a
{font-family:Verdana;}#yiv6819515648 #yiv6819515648ygrp-msg
p#yiv6819515648attach-count span {color:#1E66AE;font-weight:700;}#yiv6819515648
#yiv6819515648ygrp-reco #yiv6819515648reco-head
{color:#ff7900;font-weight:700;}#yiv6819515648 #yiv6819515648ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv6819515648 #yiv6819515648ygrp-sponsor
#yiv6819515648ov li a {font-size:130%;text-decoration:none;}#yiv6819515648
#yiv6819515648ygrp-sponsor #yiv6819515648ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv6819515648
#yiv6819515648ygrp-sponsor #yiv6819515648ov ul {margin:0;padding:0 0 0
8px;}#yiv6819515648 #yiv6819515648ygrp-text
{font-family:Georgia;}#yiv6819515648 #yiv6819515648ygrp-text p {margin:0 0 1em
0;}#yiv6819515648 #yiv6819515648ygrp-text tt {font-size:120%;}#yiv6819515648
#yiv6819515648ygrp-vital ul li:last-child {border-right:none
!important;}#yiv6819515648
