Pada Rabu, 4 November 2015 6:39, HAIRUL ALAM <ha_m...@yahoo.co.id> menulis: AssalamualaikumPak Kid saya sudah coba seperti contoh terlampir, bagaimana caranya agar data unit bisa berurut bila di data inputnya terdapat cell yang kosong seperti lampiran, dimana nilai pada outputnya "0" TerimakasihWassalamualaikum Hairul Alam Pada Rabu, 4 November 2015 6:08, HAIRUL ALAM <ha_m...@yahoo.co.id> menulis: Assalamualaikum Pak Kid Saya sudah lihat di Array formula filtering unique, di baris paling bawah muncul (#N/A) gimana cara menghilangkan kata tersebut bila dengan rumus yang tertera TerimakasihWassalamualaikum Pada Selasa, 3 November 2015 23:14, "'Mr. Kid' mr.nm...@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis: Hai Hairul, Array formula filtering unique ? Coba jalan-jalan kesini dan terapkan konsepnya (bukan bunyi formula persisnya) pada kasus Anda. Wassalam, Kid On Mon, Nov 2, 2015 at 10:10 PM, HAIRUL ALAM ha_m...@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com> wrote: Maaf Pak Odong Bila misalkan dengan pada kolom C3 sd C2532 ada data yang sama 2 data atau lebih, bagaimana cara mengambil salah satu dari masing2 data yang sama dan memisahkannya dengan criteria kolom/row F20, Mohon Formulanya Pak TerimakasihSalam Pada Rabu, 28 Oktober 2015 17:56, "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 #yiv3531798658 -- #yiv3531798658ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3531798658 #yiv3531798658ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3531798658 #yiv3531798658ygrp-mkp #yiv3531798658hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3531798658 #yiv3531798658ygrp-mkp #yiv3531798658ads {margin-bottom:10px;}#yiv3531798658 #yiv3531798658ygrp-mkp .yiv3531798658ad {padding:0 0;}#yiv3531798658 #yiv3531798658ygrp-mkp .yiv3531798658ad p {margin:0;}#yiv3531798658 #yiv3531798658ygrp-mkp .yiv3531798658ad a {color:#0000ff;text-decoration:none;}#yiv3531798658 #yiv3531798658ygrp-sponsor #yiv3531798658ygrp-lc {font-family:Arial;}#yiv3531798658 #yiv3531798658ygrp-sponsor #yiv3531798658ygrp-lc #yiv3531798658hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3531798658 #yiv3531798658ygrp-sponsor #yiv3531798658ygrp-lc .yiv3531798658ad {margin-bottom:10px;padding:0 0;}#yiv3531798658 #yiv3531798658actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3531798658 #yiv3531798658activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3531798658 #yiv3531798658activity span {font-weight:700;}#yiv3531798658 #yiv3531798658activity span:first-child {text-transform:uppercase;}#yiv3531798658 #yiv3531798658activity span a {color:#5085b6;text-decoration:none;}#yiv3531798658 #yiv3531798658activity span span {color:#ff7900;}#yiv3531798658 #yiv3531798658activity span .yiv3531798658underline {text-decoration:underline;}#yiv3531798658 .yiv3531798658attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3531798658 .yiv3531798658attach div a {text-decoration:none;}#yiv3531798658 .yiv3531798658attach img {border:none;padding-right:5px;}#yiv3531798658 .yiv3531798658attach label {display:block;margin-bottom:5px;}#yiv3531798658 .yiv3531798658attach label a {text-decoration:none;}#yiv3531798658 blockquote {margin:0 0 0 4px;}#yiv3531798658 .yiv3531798658bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3531798658 .yiv3531798658bold a {text-decoration:none;}#yiv3531798658 dd.yiv3531798658last p a {font-family:Verdana;font-weight:700;}#yiv3531798658 dd.yiv3531798658last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3531798658 dd.yiv3531798658last p span.yiv3531798658yshortcuts {margin-right:0;}#yiv3531798658 div.yiv3531798658attach-table div div a {text-decoration:none;}#yiv3531798658 div.yiv3531798658attach-table {width:400px;}#yiv3531798658 div.yiv3531798658file-title a, #yiv3531798658 div.yiv3531798658file-title a:active, #yiv3531798658 div.yiv3531798658file-title a:hover, #yiv3531798658 div.yiv3531798658file-title a:visited {text-decoration:none;}#yiv3531798658 div.yiv3531798658photo-title a, #yiv3531798658 div.yiv3531798658photo-title a:active, #yiv3531798658 div.yiv3531798658photo-title a:hover, #yiv3531798658 div.yiv3531798658photo-title a:visited {text-decoration:none;}#yiv3531798658 div#yiv3531798658ygrp-mlmsg #yiv3531798658ygrp-msg p a span.yiv3531798658yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3531798658 .yiv3531798658green {color:#628c2a;}#yiv3531798658 .yiv3531798658MsoNormal {margin:0 0 0 0;}#yiv3531798658 o {font-size:0;}#yiv3531798658 #yiv3531798658photos div {float:left;width:72px;}#yiv3531798658 #yiv3531798658photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv3531798658 #yiv3531798658photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3531798658 #yiv3531798658reco-category {font-size:77%;}#yiv3531798658 #yiv3531798658reco-desc {font-size:77%;}#yiv3531798658 .yiv3531798658replbq {margin:4px;}#yiv3531798658 #yiv3531798658ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3531798658 #yiv3531798658ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3531798658 #yiv3531798658ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3531798658 #yiv3531798658ygrp-mlmsg select, #yiv3531798658 input, #yiv3531798658 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3531798658 #yiv3531798658ygrp-mlmsg pre, #yiv3531798658 code {font:115% monospace;}#yiv3531798658 #yiv3531798658ygrp-mlmsg * {line-height:1.22em;}#yiv3531798658 #yiv3531798658ygrp-mlmsg #yiv3531798658logo {padding-bottom:10px;}#yiv3531798658 #yiv3531798658ygrp-msg p a {font-family:Verdana;}#yiv3531798658 #yiv3531798658ygrp-msg p#yiv3531798658attach-count span {color:#1E66AE;font-weight:700;}#yiv3531798658 #yiv3531798658ygrp-reco #yiv3531798658reco-head {color:#ff7900;font-weight:700;}#yiv3531798658 #yiv3531798658ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3531798658 #yiv3531798658ygrp-sponsor #yiv3531798658ov li a {font-size:130%;text-decoration:none;}#yiv3531798658 #yiv3531798658ygrp-sponsor #yiv3531798658ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3531798658 #yiv3531798658ygrp-sponsor #yiv3531798658ov ul {margin:0;padding:0 0 0 8px;}#yiv3531798658 #yiv3531798658ygrp-text {font-family:Georgia;}#yiv3531798658 #yiv3531798658ygrp-text p {margin:0 0 1em 0;}#yiv3531798658 #yiv3531798658ygrp-text tt {font-size:120%;}#yiv3531798658 #yiv3531798658ygrp-vital ul li:last-child {border-right:none !important;}#yiv3531798658
DATA UNIK.xlsx
Description: MS-Excel 2007 spreadsheet