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 #yiv1913237671 #yiv1913237671 -- #yiv1913237671ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1913237671 #yiv1913237671ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1913237671 #yiv1913237671ygrp-mkp #yiv1913237671hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv1913237671 #yiv1913237671ygrp-mkp #yiv1913237671ads {margin-bottom:10px;}#yiv1913237671 #yiv1913237671ygrp-mkp .yiv1913237671ad {padding:0 0;}#yiv1913237671 #yiv1913237671ygrp-mkp .yiv1913237671ad p {margin:0;}#yiv1913237671 #yiv1913237671ygrp-mkp .yiv1913237671ad a {color:#0000ff;text-decoration:none;}#yiv1913237671 #yiv1913237671ygrp-sponsor #yiv1913237671ygrp-lc {font-family:Arial;}#yiv1913237671 #yiv1913237671ygrp-sponsor #yiv1913237671ygrp-lc #yiv1913237671hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1913237671 #yiv1913237671ygrp-sponsor #yiv1913237671ygrp-lc .yiv1913237671ad {margin-bottom:10px;padding:0 0;}#yiv1913237671 #yiv1913237671actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1913237671 #yiv1913237671activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1913237671 #yiv1913237671activity span {font-weight:700;}#yiv1913237671 #yiv1913237671activity span:first-child {text-transform:uppercase;}#yiv1913237671 #yiv1913237671activity span a {color:#5085b6;text-decoration:none;}#yiv1913237671 #yiv1913237671activity span span {color:#ff7900;}#yiv1913237671 #yiv1913237671activity span .yiv1913237671underline {text-decoration:underline;}#yiv1913237671 .yiv1913237671attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv1913237671 .yiv1913237671attach div a {text-decoration:none;}#yiv1913237671 .yiv1913237671attach img {border:none;padding-right:5px;}#yiv1913237671 .yiv1913237671attach label {display:block;margin-bottom:5px;}#yiv1913237671 .yiv1913237671attach label a {text-decoration:none;}#yiv1913237671 blockquote {margin:0 0 0 4px;}#yiv1913237671 .yiv1913237671bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv1913237671 .yiv1913237671bold a {text-decoration:none;}#yiv1913237671 dd.yiv1913237671last p a {font-family:Verdana;font-weight:700;}#yiv1913237671 dd.yiv1913237671last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1913237671 dd.yiv1913237671last p span.yiv1913237671yshortcuts {margin-right:0;}#yiv1913237671 div.yiv1913237671attach-table div div a {text-decoration:none;}#yiv1913237671 div.yiv1913237671attach-table {width:400px;}#yiv1913237671 div.yiv1913237671file-title a, #yiv1913237671 div.yiv1913237671file-title a:active, #yiv1913237671 div.yiv1913237671file-title a:hover, #yiv1913237671 div.yiv1913237671file-title a:visited {text-decoration:none;}#yiv1913237671 div.yiv1913237671photo-title a, #yiv1913237671 div.yiv1913237671photo-title a:active, #yiv1913237671 div.yiv1913237671photo-title a:hover, #yiv1913237671 div.yiv1913237671photo-title a:visited {text-decoration:none;}#yiv1913237671 div#yiv1913237671ygrp-mlmsg #yiv1913237671ygrp-msg p a span.yiv1913237671yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1913237671 .yiv1913237671green {color:#628c2a;}#yiv1913237671 .yiv1913237671MsoNormal {margin:0 0 0 0;}#yiv1913237671 o {font-size:0;}#yiv1913237671 #yiv1913237671photos div {float:left;width:72px;}#yiv1913237671 #yiv1913237671photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv1913237671 #yiv1913237671photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1913237671 #yiv1913237671reco-category {font-size:77%;}#yiv1913237671 #yiv1913237671reco-desc {font-size:77%;}#yiv1913237671 .yiv1913237671replbq {margin:4px;}#yiv1913237671 #yiv1913237671ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv1913237671 #yiv1913237671ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1913237671 #yiv1913237671ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1913237671 #yiv1913237671ygrp-mlmsg select, #yiv1913237671 input, #yiv1913237671 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv1913237671 #yiv1913237671ygrp-mlmsg pre, #yiv1913237671 code {font:115% monospace;}#yiv1913237671 #yiv1913237671ygrp-mlmsg * {line-height:1.22em;}#yiv1913237671 #yiv1913237671ygrp-mlmsg #yiv1913237671logo {padding-bottom:10px;}#yiv1913237671 #yiv1913237671ygrp-msg p a {font-family:Verdana;}#yiv1913237671 #yiv1913237671ygrp-msg p#yiv1913237671attach-count span {color:#1E66AE;font-weight:700;}#yiv1913237671 #yiv1913237671ygrp-reco #yiv1913237671reco-head {color:#ff7900;font-weight:700;}#yiv1913237671 #yiv1913237671ygrp-reco {margin-bottom:20px;padding:0px;}#yiv1913237671 #yiv1913237671ygrp-sponsor #yiv1913237671ov li a {font-size:130%;text-decoration:none;}#yiv1913237671 #yiv1913237671ygrp-sponsor #yiv1913237671ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv1913237671 #yiv1913237671ygrp-sponsor #yiv1913237671ov ul {margin:0;padding:0 0 0 8px;}#yiv1913237671 #yiv1913237671ygrp-text {font-family:Georgia;}#yiv1913237671 #yiv1913237671ygrp-text p {margin:0 0 1em 0;}#yiv1913237671 #yiv1913237671ygrp-text tt {font-size:120%;}#yiv1913237671 #yiv1913237671ygrp-vital ul li:last-child {border-right:none !important;}#yiv1913237671