Hai Matzen,
Yang musti diganti adalah:Formula pada sel M1, M2 dstnya....
Mis. baris terakhir 1000 maka- Formula pada sel M1, angka 11 nya diganti dengan
angka 1000, Row(1:10) diganti menjadi Row(1:999)- Sorot M2:M1000 dan ganti
formula pada formula bar, angka 11 diganti dengan angka 1000,
Row(1:10) diganti menjadi Row(1:999) lalu tekan tombol Ctrl Shift Enter (CSE)
secara bersamaan untuk membentuk Array Formula (komputer akan memberi
tanda { } secara otomatis)/.
Salam,HK
From: "'Subroto, Matzen' [email protected] [belajar-excel]"
<[email protected]>
To: [email protected]
Sent: Tuesday, 26 May 2015, 14:47
Subject: RE: [belajar-excel] Droplist By criteria
Dear Pak HK, Saya memiliki 400 lebih list, dan saya coba dengan file of
c_Dropdownlist update, akan tetapi ga bisa, sekiranya mana yang mesti saya
ganti Terima kasih atas perhatian dan kerjasamanya, dan saya mohon maaf
apabila ada kata-kata yang kurang berkenan Terima Kasih Matzen
From: [email protected] [mailto:[email protected]]
Sent: 25 Mei 2015 12:50
To: [email protected]
Subject: Re: [belajar-excel] Droplist By criteria [3 Attachments] Pilih
satu dari tiga warisan si mbah. Salam, HK From: "'Subroto, Matzen'
[email protected] [belajar-excel]" <[email protected]>
To: [email protected]
Sent: Monday, 25 May 2015, 11:16
Subject: [belajar-excel] Droplist By criteria [1 Attachment] Dear Master
Excel, Mohon pencerahannya untuk droplist by criteria, ketika saya create
awalan list, maka yang muncul hanya list yang sesuai dengan awalan hurup tadi
Terima kasih atas perhatian dan kerjasamanya, dan saya mohon maaf apabila ada
kata-kata yang kurang berkenan Terima Kasih Matzen
____________________________________________________________________________
This email has been scanned for Viruses and Spam. For more information
please contact your local Business Unit Information Security representative.
____________________________________________________________________________
#yiv2783271606 #yiv2783271606 -- #yiv2783271606ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2783271606
#yiv2783271606ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2783271606
#yiv2783271606ygrp-mkp #yiv2783271606hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv2783271606 #yiv2783271606ygrp-mkp #yiv2783271606ads
{margin-bottom:10px;}#yiv2783271606 #yiv2783271606ygrp-mkp .yiv2783271606ad
{padding:0 0;}#yiv2783271606 #yiv2783271606ygrp-mkp .yiv2783271606ad p
{margin:0;}#yiv2783271606 #yiv2783271606ygrp-mkp .yiv2783271606ad a
{color:#0000ff;text-decoration:none;}#yiv2783271606 #yiv2783271606ygrp-sponsor
#yiv2783271606ygrp-lc {font-family:Arial;}#yiv2783271606
#yiv2783271606ygrp-sponsor #yiv2783271606ygrp-lc #yiv2783271606hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2783271606
#yiv2783271606ygrp-sponsor #yiv2783271606ygrp-lc .yiv2783271606ad
{margin-bottom:10px;padding:0 0;}#yiv2783271606 #yiv2783271606actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2783271606
#yiv2783271606activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2783271606
#yiv2783271606activity span {font-weight:700;}#yiv2783271606
#yiv2783271606activity span:first-child
{text-transform:uppercase;}#yiv2783271606 #yiv2783271606activity span a
{color:#5085b6;text-decoration:none;}#yiv2783271606 #yiv2783271606activity span
span {color:#ff7900;}#yiv2783271606 #yiv2783271606activity span
.yiv2783271606underline {text-decoration:underline;}#yiv2783271606
.yiv2783271606attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv2783271606 .yiv2783271606attach div a
{text-decoration:none;}#yiv2783271606 .yiv2783271606attach img
{border:none;padding-right:5px;}#yiv2783271606 .yiv2783271606attach label
{display:block;margin-bottom:5px;}#yiv2783271606 .yiv2783271606attach label a
{text-decoration:none;}#yiv2783271606 blockquote {margin:0 0 0
4px;}#yiv2783271606 .yiv2783271606bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv2783271606
.yiv2783271606bold a {text-decoration:none;}#yiv2783271606 dd.yiv2783271606last
p a {font-family:Verdana;font-weight:700;}#yiv2783271606 dd.yiv2783271606last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2783271606
dd.yiv2783271606last p span.yiv2783271606yshortcuts
{margin-right:0;}#yiv2783271606 div.yiv2783271606attach-table div div a
{text-decoration:none;}#yiv2783271606 div.yiv2783271606attach-table
{width:400px;}#yiv2783271606 div.yiv2783271606file-title a, #yiv2783271606
div.yiv2783271606file-title a:active, #yiv2783271606
div.yiv2783271606file-title a:hover, #yiv2783271606 div.yiv2783271606file-title
a:visited {text-decoration:none;}#yiv2783271606 div.yiv2783271606photo-title a,
#yiv2783271606 div.yiv2783271606photo-title a:active, #yiv2783271606
div.yiv2783271606photo-title a:hover, #yiv2783271606
div.yiv2783271606photo-title a:visited {text-decoration:none;}#yiv2783271606
div#yiv2783271606ygrp-mlmsg #yiv2783271606ygrp-msg p a
span.yiv2783271606yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2783271606
.yiv2783271606green {color:#628c2a;}#yiv2783271606 .yiv2783271606MsoNormal
{margin:0 0 0 0;}#yiv2783271606 o {font-size:0;}#yiv2783271606
#yiv2783271606photos div {float:left;width:72px;}#yiv2783271606
#yiv2783271606photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv2783271606
#yiv2783271606photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2783271606
#yiv2783271606reco-category {font-size:77%;}#yiv2783271606
#yiv2783271606reco-desc {font-size:77%;}#yiv2783271606 .yiv2783271606replbq
{margin:4px;}#yiv2783271606 #yiv2783271606ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv2783271606 #yiv2783271606ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2783271606
#yiv2783271606ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2783271606
#yiv2783271606ygrp-mlmsg select, #yiv2783271606 input, #yiv2783271606 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv2783271606
#yiv2783271606ygrp-mlmsg pre, #yiv2783271606 code {font:115%
monospace;}#yiv2783271606 #yiv2783271606ygrp-mlmsg *
{line-height:1.22em;}#yiv2783271606 #yiv2783271606ygrp-mlmsg #yiv2783271606logo
{padding-bottom:10px;}#yiv2783271606 #yiv2783271606ygrp-msg p a
{font-family:Verdana;}#yiv2783271606 #yiv2783271606ygrp-msg
p#yiv2783271606attach-count span {color:#1E66AE;font-weight:700;}#yiv2783271606
#yiv2783271606ygrp-reco #yiv2783271606reco-head
{color:#ff7900;font-weight:700;}#yiv2783271606 #yiv2783271606ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv2783271606 #yiv2783271606ygrp-sponsor
#yiv2783271606ov li a {font-size:130%;text-decoration:none;}#yiv2783271606
#yiv2783271606ygrp-sponsor #yiv2783271606ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv2783271606
#yiv2783271606ygrp-sponsor #yiv2783271606ov ul {margin:0;padding:0 0 0
8px;}#yiv2783271606 #yiv2783271606ygrp-text
{font-family:Georgia;}#yiv2783271606 #yiv2783271606ygrp-text p {margin:0 0 1em
0;}#yiv2783271606 #yiv2783271606ygrp-text tt {font-size:120%;}#yiv2783271606
#yiv2783271606ygrp-vital ul li:last-child {border-right:none
!important;}#yiv2783271606
