wah klo harus di delet, tidak bisa dengan formula, kita tunggu para master saja
untuk memecahkan nya. tapi bila maksudnya, " bila tidak ada nilai maka broder
akan ngebleng ", bisa menggunakan CF pak, contoh :
blok G3 s.d BP4, blank kan borders yang ada, kemudian masuk CF, new rule, use a
formula to determine which cell to format, masukan formula pada format value
dengan =G3<>"", klik format, border, klik outline, OK
br,
odong nando
Pada Kamis, 29 Oktober 2015 6:22, "HAIRUL ALAM ha_m...@yahoo.co.id
[belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Maaf Pak Odong
Maksudnya yang di delet row yang kosong begitu, Terimakasih
Pada Rabu, 28 Oktober 2015 23:57, "odong nando odongna...@yahoo.com
[belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
mohon di perhatikan lagi pak hairul untuk "....formula berjalan bila
LOCATION PADA KOLOM B HARUS DI SHORT A to Z, DAN DI DELET SEMUA YANG KOSONG."
br,
odong nando
Pada Rabu, 28 Oktober 2015 19:29, "HAIRUL ALAM ha_m...@yahoo.co.id
[belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Yth. Pak Odong Nando
Terlampir masalah Urut & Status yang saya higligh kuning tidak berjumlah
otomatis, Maaf
Terimakasih
Pada Rabu, 28 Oktober 2015 18:24, "HAIRUL ALAM ha_m...@yahoo.co.id
[belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Terimakasih Banyak Pak Odong
Pada Rabu, 28 Oktober 2015 17:55, "odong nando odongna...@yahoo.com
[belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
yoo...hairul,bisa dicoba di cell
:G3=IF($F$20="";MID(INDIRECT("C"&COLUMNS($F$2:F2)+2);9;10);IF(($F$20<>"")*(COUNTIF($B$3:$B$2528;$F$20)>=COLUMNS($F$2:F2));MID(INDEX($C$3:$C$2528;MATCH($F$20;$B$3:$B$2528;0)+COLUMNS($F$2:F2)-1);9;10);""))
G4=IF($F$20="";IF(INDIRECT("D"&COLUMNS($F$2:F2)+2)=0;"";1);IF(($F$20<>"")*(COUNTIF($B$3:$B$2528;$F$20)>=COLUMNS($F$2:F2));IF(INDEX($D$3:$D$2528;MATCH($F$20;$B$3:$B$2528;0)+COLUMNS($F$2:F2)-1);1;"");""))
G6=IF($F$20="";MID(INDIRECT("C"&COLUMNS($F$2:F2)+64);9;10);IF(($F$20<>"")*(COUNTIF($B$3:$B$2528;$F$20)>=COLUMNS($F$2:F2)+62);MID(INDEX($C$3:$C$2528;MATCH($F$20;$B$3:$B$2528;0)+COLUMNS($F$2:F2)+61);9;10);""))
G7=IF($F$20="";IF(INDIRECT("D"&COLUMNS($F$2:F2)+64)=0;"";1);IF(($F$20<>"")*(COUNTIF($B$3:$B$2528;$F$20)>=COLUMNS($F$2:F2)+62);IF(INDEX($D$3:$D$2528;MATCH($F$20;$B$3:$B$2528;0)+COLUMNS($F$2:F2)+61);1;"");""))
perhatikan daerah yang di arsir kuning dan ungu, G3 menjadi G6 dan G4 menjadi
G7untuk G9,G10,G12,G13,G15 & G16, pada daerah terarsir ungu dapat di tambah
masing2 62, sesuai dengan jumlah kolom dari G s.d BP (62 kolom)
bila regional setting anda english maka ubah titikkoma ";" menjadi koma ",".
br,
odong nando
Pada Rabu, 28 Oktober 2015 15:01, "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, untuk
bekerja secara formula dan otomatis agar Excel bekerja tidak berat karena
kebanyakan formula yang memakan memory
Wassalamualaikum Wr. Wb.
TerimakasihHairul Alam
#yiv3194834963 #yiv3194834963 -- #yiv3194834963ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3194834963
#yiv3194834963ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3194834963
#yiv3194834963ygrp-mkp #yiv3194834963hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv3194834963 #yiv3194834963ygrp-mkp #yiv3194834963ads
{margin-bottom:10px;}#yiv3194834963 #yiv3194834963ygrp-mkp .yiv3194834963ad
{padding:0 0;}#yiv3194834963 #yiv3194834963ygrp-mkp .yiv3194834963ad p
{margin:0;}#yiv3194834963 #yiv3194834963ygrp-mkp .yiv3194834963ad a
{color:#0000ff;text-decoration:none;}#yiv3194834963 #yiv3194834963ygrp-sponsor
#yiv3194834963ygrp-lc {font-family:Arial;}#yiv3194834963
#yiv3194834963ygrp-sponsor #yiv3194834963ygrp-lc #yiv3194834963hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3194834963
#yiv3194834963ygrp-sponsor #yiv3194834963ygrp-lc .yiv3194834963ad
{margin-bottom:10px;padding:0 0;}#yiv3194834963 #yiv3194834963actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3194834963
#yiv3194834963activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3194834963
#yiv3194834963activity span {font-weight:700;}#yiv3194834963
#yiv3194834963activity span:first-child
{text-transform:uppercase;}#yiv3194834963 #yiv3194834963activity span a
{color:#5085b6;text-decoration:none;}#yiv3194834963 #yiv3194834963activity span
span {color:#ff7900;}#yiv3194834963 #yiv3194834963activity span
.yiv3194834963underline {text-decoration:underline;}#yiv3194834963
.yiv3194834963attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv3194834963 .yiv3194834963attach div a
{text-decoration:none;}#yiv3194834963 .yiv3194834963attach img
{border:none;padding-right:5px;}#yiv3194834963 .yiv3194834963attach label
{display:block;margin-bottom:5px;}#yiv3194834963 .yiv3194834963attach label a
{text-decoration:none;}#yiv3194834963 blockquote {margin:0 0 0
4px;}#yiv3194834963 .yiv3194834963bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv3194834963
.yiv3194834963bold a {text-decoration:none;}#yiv3194834963 dd.yiv3194834963last
p a {font-family:Verdana;font-weight:700;}#yiv3194834963 dd.yiv3194834963last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3194834963
dd.yiv3194834963last p span.yiv3194834963yshortcuts
{margin-right:0;}#yiv3194834963 div.yiv3194834963attach-table div div a
{text-decoration:none;}#yiv3194834963 div.yiv3194834963attach-table
{width:400px;}#yiv3194834963 div.yiv3194834963file-title a, #yiv3194834963
div.yiv3194834963file-title a:active, #yiv3194834963
div.yiv3194834963file-title a:hover, #yiv3194834963 div.yiv3194834963file-title
a:visited {text-decoration:none;}#yiv3194834963 div.yiv3194834963photo-title a,
#yiv3194834963 div.yiv3194834963photo-title a:active, #yiv3194834963
div.yiv3194834963photo-title a:hover, #yiv3194834963
div.yiv3194834963photo-title a:visited {text-decoration:none;}#yiv3194834963
div#yiv3194834963ygrp-mlmsg #yiv3194834963ygrp-msg p a
span.yiv3194834963yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3194834963
.yiv3194834963green {color:#628c2a;}#yiv3194834963 .yiv3194834963MsoNormal
{margin:0 0 0 0;}#yiv3194834963 o {font-size:0;}#yiv3194834963
#yiv3194834963photos div {float:left;width:72px;}#yiv3194834963
#yiv3194834963photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv3194834963
#yiv3194834963photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3194834963
#yiv3194834963reco-category {font-size:77%;}#yiv3194834963
#yiv3194834963reco-desc {font-size:77%;}#yiv3194834963 .yiv3194834963replbq
{margin:4px;}#yiv3194834963 #yiv3194834963ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv3194834963 #yiv3194834963ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3194834963
#yiv3194834963ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3194834963
#yiv3194834963ygrp-mlmsg select, #yiv3194834963 input, #yiv3194834963 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv3194834963
#yiv3194834963ygrp-mlmsg pre, #yiv3194834963 code {font:115%
monospace;}#yiv3194834963 #yiv3194834963ygrp-mlmsg *
{line-height:1.22em;}#yiv3194834963 #yiv3194834963ygrp-mlmsg #yiv3194834963logo
{padding-bottom:10px;}#yiv3194834963 #yiv3194834963ygrp-msg p a
{font-family:Verdana;}#yiv3194834963 #yiv3194834963ygrp-msg
p#yiv3194834963attach-count span {color:#1E66AE;font-weight:700;}#yiv3194834963
#yiv3194834963ygrp-reco #yiv3194834963reco-head
{color:#ff7900;font-weight:700;}#yiv3194834963 #yiv3194834963ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv3194834963 #yiv3194834963ygrp-sponsor
#yiv3194834963ov li a {font-size:130%;text-decoration:none;}#yiv3194834963
#yiv3194834963ygrp-sponsor #yiv3194834963ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv3194834963
#yiv3194834963ygrp-sponsor #yiv3194834963ov ul {margin:0;padding:0 0 0
8px;}#yiv3194834963 #yiv3194834963ygrp-text
{font-family:Georgia;}#yiv3194834963 #yiv3194834963ygrp-text p {margin:0 0 1em
0;}#yiv3194834963 #yiv3194834963ygrp-text tt {font-size:120%;}#yiv3194834963
#yiv3194834963ygrp-vital ul li:last-child {border-right:none
!important;}#yiv3194834963
