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
#yiv1722419502 #yiv1722419502 -- #yiv1722419502ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1722419502
#yiv1722419502ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1722419502
#yiv1722419502ygrp-mkp #yiv1722419502hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv1722419502 #yiv1722419502ygrp-mkp #yiv1722419502ads
{margin-bottom:10px;}#yiv1722419502 #yiv1722419502ygrp-mkp .yiv1722419502ad
{padding:0 0;}#yiv1722419502 #yiv1722419502ygrp-mkp .yiv1722419502ad p
{margin:0;}#yiv1722419502 #yiv1722419502ygrp-mkp .yiv1722419502ad a
{color:#0000ff;text-decoration:none;}#yiv1722419502 #yiv1722419502ygrp-sponsor
#yiv1722419502ygrp-lc {font-family:Arial;}#yiv1722419502
#yiv1722419502ygrp-sponsor #yiv1722419502ygrp-lc #yiv1722419502hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1722419502
#yiv1722419502ygrp-sponsor #yiv1722419502ygrp-lc .yiv1722419502ad
{margin-bottom:10px;padding:0 0;}#yiv1722419502 #yiv1722419502actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1722419502
#yiv1722419502activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1722419502
#yiv1722419502activity span {font-weight:700;}#yiv1722419502
#yiv1722419502activity span:first-child
{text-transform:uppercase;}#yiv1722419502 #yiv1722419502activity span a
{color:#5085b6;text-decoration:none;}#yiv1722419502 #yiv1722419502activity span
span {color:#ff7900;}#yiv1722419502 #yiv1722419502activity span
.yiv1722419502underline {text-decoration:underline;}#yiv1722419502
.yiv1722419502attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv1722419502 .yiv1722419502attach div a
{text-decoration:none;}#yiv1722419502 .yiv1722419502attach img
{border:none;padding-right:5px;}#yiv1722419502 .yiv1722419502attach label
{display:block;margin-bottom:5px;}#yiv1722419502 .yiv1722419502attach label a
{text-decoration:none;}#yiv1722419502 blockquote {margin:0 0 0
4px;}#yiv1722419502 .yiv1722419502bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv1722419502
.yiv1722419502bold a {text-decoration:none;}#yiv1722419502 dd.yiv1722419502last
p a {font-family:Verdana;font-weight:700;}#yiv1722419502 dd.yiv1722419502last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1722419502
dd.yiv1722419502last p span.yiv1722419502yshortcuts
{margin-right:0;}#yiv1722419502 div.yiv1722419502attach-table div div a
{text-decoration:none;}#yiv1722419502 div.yiv1722419502attach-table
{width:400px;}#yiv1722419502 div.yiv1722419502file-title a, #yiv1722419502
div.yiv1722419502file-title a:active, #yiv1722419502
div.yiv1722419502file-title a:hover, #yiv1722419502 div.yiv1722419502file-title
a:visited {text-decoration:none;}#yiv1722419502 div.yiv1722419502photo-title a,
#yiv1722419502 div.yiv1722419502photo-title a:active, #yiv1722419502
div.yiv1722419502photo-title a:hover, #yiv1722419502
div.yiv1722419502photo-title a:visited {text-decoration:none;}#yiv1722419502
div#yiv1722419502ygrp-mlmsg #yiv1722419502ygrp-msg p a
span.yiv1722419502yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1722419502
.yiv1722419502green {color:#628c2a;}#yiv1722419502 .yiv1722419502MsoNormal
{margin:0 0 0 0;}#yiv1722419502 o {font-size:0;}#yiv1722419502
#yiv1722419502photos div {float:left;width:72px;}#yiv1722419502
#yiv1722419502photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv1722419502
#yiv1722419502photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1722419502
#yiv1722419502reco-category {font-size:77%;}#yiv1722419502
#yiv1722419502reco-desc {font-size:77%;}#yiv1722419502 .yiv1722419502replbq
{margin:4px;}#yiv1722419502 #yiv1722419502ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv1722419502 #yiv1722419502ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1722419502
#yiv1722419502ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1722419502
#yiv1722419502ygrp-mlmsg select, #yiv1722419502 input, #yiv1722419502 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv1722419502
#yiv1722419502ygrp-mlmsg pre, #yiv1722419502 code {font:115%
monospace;}#yiv1722419502 #yiv1722419502ygrp-mlmsg *
{line-height:1.22em;}#yiv1722419502 #yiv1722419502ygrp-mlmsg #yiv1722419502logo
{padding-bottom:10px;}#yiv1722419502 #yiv1722419502ygrp-msg p a
{font-family:Verdana;}#yiv1722419502 #yiv1722419502ygrp-msg
p#yiv1722419502attach-count span {color:#1E66AE;font-weight:700;}#yiv1722419502
#yiv1722419502ygrp-reco #yiv1722419502reco-head
{color:#ff7900;font-weight:700;}#yiv1722419502 #yiv1722419502ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv1722419502 #yiv1722419502ygrp-sponsor
#yiv1722419502ov li a {font-size:130%;text-decoration:none;}#yiv1722419502
#yiv1722419502ygrp-sponsor #yiv1722419502ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv1722419502
#yiv1722419502ygrp-sponsor #yiv1722419502ov ul {margin:0;padding:0 0 0
8px;}#yiv1722419502 #yiv1722419502ygrp-text
{font-family:Georgia;}#yiv1722419502 #yiv1722419502ygrp-text p {margin:0 0 1em
0;}#yiv1722419502 #yiv1722419502ygrp-text tt {font-size:120%;}#yiv1722419502
#yiv1722419502ygrp-vital ul li:last-child {border-right:none
!important;}#yiv1722419502
URUT DAN STATUS 4.xlsx
Description: MS-Excel 2007 spreadsheet
