waalaikum slm, wr.wb
hai hairul,seblm ada master yang posting mungkin untuk sementara bisa pakai
formuladi cell F3=MID(INDIRECT("B"&COLUMNS($F$2:F2)+2);9;10)
di cell F4=IF(INDIRECT("C"&COLUMNS($F$2:F2)+2)=0;"";1)
untuk CF bisa diblok dulu yang akan di warnai dengan kondisi tertentu, kemudian
pilih use formula to determine which cells to format, setelah itu masukan
formula
=F$4=1pada "values where this.... "
br,
odong nando
Pada Rabu, 28 Oktober 2015 10:41, "HAIRUL ALAM [email protected]
[belajar-excel]" <[email protected]> menulis:
Yth. Para Master Excel
Assalamualaikum Wr. Wb.
Saya mengalami problem seperti data terlampir, Mohon Pencerahannya, untuk
bekerja secara formula dan otomatis agar Excel bekerja tidak berat karena
kebanyakan formula yang memakan memory
Wassalamualaikum Wr. Wb.
TerimakasihHairul Alam #yiv4823108554 #yiv4823108554 -- #yiv4823108554ygrp-mkp
{border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0
10px;}#yiv4823108554 #yiv4823108554ygrp-mkp hr {border:1px solid
#d8d8d8;}#yiv4823108554 #yiv4823108554ygrp-mkp #yiv4823108554hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv4823108554 #yiv4823108554ygrp-mkp #yiv4823108554ads
{margin-bottom:10px;}#yiv4823108554 #yiv4823108554ygrp-mkp .yiv4823108554ad
{padding:0 0;}#yiv4823108554 #yiv4823108554ygrp-mkp .yiv4823108554ad p
{margin:0;}#yiv4823108554 #yiv4823108554ygrp-mkp .yiv4823108554ad a
{color:#0000ff;text-decoration:none;}#yiv4823108554 #yiv4823108554ygrp-sponsor
#yiv4823108554ygrp-lc {font-family:Arial;}#yiv4823108554
#yiv4823108554ygrp-sponsor #yiv4823108554ygrp-lc #yiv4823108554hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4823108554
#yiv4823108554ygrp-sponsor #yiv4823108554ygrp-lc .yiv4823108554ad
{margin-bottom:10px;padding:0 0;}#yiv4823108554 #yiv4823108554actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4823108554
#yiv4823108554activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4823108554
#yiv4823108554activity span {font-weight:700;}#yiv4823108554
#yiv4823108554activity span:first-child
{text-transform:uppercase;}#yiv4823108554 #yiv4823108554activity span a
{color:#5085b6;text-decoration:none;}#yiv4823108554 #yiv4823108554activity span
span {color:#ff7900;}#yiv4823108554 #yiv4823108554activity span
.yiv4823108554underline {text-decoration:underline;}#yiv4823108554
.yiv4823108554attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv4823108554 .yiv4823108554attach div a
{text-decoration:none;}#yiv4823108554 .yiv4823108554attach img
{border:none;padding-right:5px;}#yiv4823108554 .yiv4823108554attach label
{display:block;margin-bottom:5px;}#yiv4823108554 .yiv4823108554attach label a
{text-decoration:none;}#yiv4823108554 blockquote {margin:0 0 0
4px;}#yiv4823108554 .yiv4823108554bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv4823108554
.yiv4823108554bold a {text-decoration:none;}#yiv4823108554 dd.yiv4823108554last
p a {font-family:Verdana;font-weight:700;}#yiv4823108554 dd.yiv4823108554last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4823108554
dd.yiv4823108554last p span.yiv4823108554yshortcuts
{margin-right:0;}#yiv4823108554 div.yiv4823108554attach-table div div a
{text-decoration:none;}#yiv4823108554 div.yiv4823108554attach-table
{width:400px;}#yiv4823108554 div.yiv4823108554file-title a, #yiv4823108554
div.yiv4823108554file-title a:active, #yiv4823108554
div.yiv4823108554file-title a:hover, #yiv4823108554 div.yiv4823108554file-title
a:visited {text-decoration:none;}#yiv4823108554 div.yiv4823108554photo-title a,
#yiv4823108554 div.yiv4823108554photo-title a:active, #yiv4823108554
div.yiv4823108554photo-title a:hover, #yiv4823108554
div.yiv4823108554photo-title a:visited {text-decoration:none;}#yiv4823108554
div#yiv4823108554ygrp-mlmsg #yiv4823108554ygrp-msg p a
span.yiv4823108554yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4823108554
.yiv4823108554green {color:#628c2a;}#yiv4823108554 .yiv4823108554MsoNormal
{margin:0 0 0 0;}#yiv4823108554 o {font-size:0;}#yiv4823108554
#yiv4823108554photos div {float:left;width:72px;}#yiv4823108554
#yiv4823108554photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv4823108554
#yiv4823108554photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4823108554
#yiv4823108554reco-category {font-size:77%;}#yiv4823108554
#yiv4823108554reco-desc {font-size:77%;}#yiv4823108554 .yiv4823108554replbq
{margin:4px;}#yiv4823108554 #yiv4823108554ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv4823108554 #yiv4823108554ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4823108554
#yiv4823108554ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4823108554
#yiv4823108554ygrp-mlmsg select, #yiv4823108554 input, #yiv4823108554 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv4823108554
#yiv4823108554ygrp-mlmsg pre, #yiv4823108554 code {font:115%
monospace;}#yiv4823108554 #yiv4823108554ygrp-mlmsg *
{line-height:1.22em;}#yiv4823108554 #yiv4823108554ygrp-mlmsg #yiv4823108554logo
{padding-bottom:10px;}#yiv4823108554 #yiv4823108554ygrp-msg p a
{font-family:Verdana;}#yiv4823108554 #yiv4823108554ygrp-msg
p#yiv4823108554attach-count span {color:#1E66AE;font-weight:700;}#yiv4823108554
#yiv4823108554ygrp-reco #yiv4823108554reco-head
{color:#ff7900;font-weight:700;}#yiv4823108554 #yiv4823108554ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv4823108554 #yiv4823108554ygrp-sponsor
#yiv4823108554ov li a {font-size:130%;text-decoration:none;}#yiv4823108554
#yiv4823108554ygrp-sponsor #yiv4823108554ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv4823108554
#yiv4823108554ygrp-sponsor #yiv4823108554ov ul {margin:0;padding:0 0 0
8px;}#yiv4823108554 #yiv4823108554ygrp-text
{font-family:Georgia;}#yiv4823108554 #yiv4823108554ygrp-text p {margin:0 0 1em
0;}#yiv4823108554 #yiv4823108554ygrp-text tt {font-size:120%;}#yiv4823108554
#yiv4823108554ygrp-vital ul li:last-child {border-right:none
!important;}#yiv4823108554
