Setelah Edit formula pada sel M1, akhiri juga dengan menekan tombol Ctrl Shift
Enter secara bersamaan (Array Formula).
Salam,HK
----- Forwarded Message -----
From: hendrik karnadi <[email protected]>
To: "[email protected]" <[email protected]>
Sent: Tuesday, 26 May 2015, 15:43
Subject: Re: [belajar-excel] Droplist By criteria
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.
____________________________________________________________________________
#yiv4200498862 -- #yiv4200498862ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4200498862
#yiv4200498862ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4200498862
#yiv4200498862ygrp-mkp #yiv4200498862hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv4200498862 #yiv4200498862ygrp-mkp #yiv4200498862ads
{margin-bottom:10px;}#yiv4200498862 #yiv4200498862ygrp-mkp .yiv4200498862ad
{padding:0 0;}#yiv4200498862 #yiv4200498862ygrp-mkp .yiv4200498862ad p
{margin:0;}#yiv4200498862 #yiv4200498862ygrp-mkp .yiv4200498862ad a
{color:#0000ff;text-decoration:none;}#yiv4200498862 #yiv4200498862ygrp-sponsor
#yiv4200498862ygrp-lc {font-family:Arial;}#yiv4200498862
#yiv4200498862ygrp-sponsor #yiv4200498862ygrp-lc #yiv4200498862hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4200498862
#yiv4200498862ygrp-sponsor #yiv4200498862ygrp-lc .yiv4200498862ad
{margin-bottom:10px;padding:0 0;}#yiv4200498862 #yiv4200498862actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4200498862
#yiv4200498862activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4200498862
#yiv4200498862activity span {font-weight:700;}#yiv4200498862
#yiv4200498862activity span:first-child
{text-transform:uppercase;}#yiv4200498862 #yiv4200498862activity span a
{color:#5085b6;text-decoration:none;}#yiv4200498862 #yiv4200498862activity span
span {color:#ff7900;}#yiv4200498862 #yiv4200498862activity span
.yiv4200498862underline {text-decoration:underline;}#yiv4200498862
.yiv4200498862attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv4200498862 .yiv4200498862attach div a
{text-decoration:none;}#yiv4200498862 .yiv4200498862attach img
{border:none;padding-right:5px;}#yiv4200498862 .yiv4200498862attach label
{display:block;margin-bottom:5px;}#yiv4200498862 .yiv4200498862attach label a
{text-decoration:none;}#yiv4200498862 blockquote {margin:0 0 0
4px;}#yiv4200498862 .yiv4200498862bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv4200498862
.yiv4200498862bold a {text-decoration:none;}#yiv4200498862 dd.yiv4200498862last
p a {font-family:Verdana;font-weight:700;}#yiv4200498862 dd.yiv4200498862last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4200498862
dd.yiv4200498862last p span.yiv4200498862yshortcuts
{margin-right:0;}#yiv4200498862 div.yiv4200498862attach-table div div a
{text-decoration:none;}#yiv4200498862 div.yiv4200498862attach-table
{width:400px;}#yiv4200498862 div.yiv4200498862file-title a, #yiv4200498862
div.yiv4200498862file-title a:active, #yiv4200498862
div.yiv4200498862file-title a:hover, #yiv4200498862 div.yiv4200498862file-title
a:visited {text-decoration:none;}#yiv4200498862 div.yiv4200498862photo-title a,
#yiv4200498862 div.yiv4200498862photo-title a:active, #yiv4200498862
div.yiv4200498862photo-title a:hover, #yiv4200498862
div.yiv4200498862photo-title a:visited {text-decoration:none;}#yiv4200498862
div#yiv4200498862ygrp-mlmsg #yiv4200498862ygrp-msg p a
span.yiv4200498862yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4200498862
.yiv4200498862green {color:#628c2a;}#yiv4200498862 .yiv4200498862MsoNormal
{margin:0 0 0 0;}#yiv4200498862 o {font-size:0;}#yiv4200498862
#yiv4200498862photos div {float:left;width:72px;}#yiv4200498862
#yiv4200498862photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv4200498862
#yiv4200498862photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4200498862
#yiv4200498862reco-category {font-size:77%;}#yiv4200498862
#yiv4200498862reco-desc {font-size:77%;}#yiv4200498862 .yiv4200498862replbq
{margin:4px;}#yiv4200498862 #yiv4200498862ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv4200498862 #yiv4200498862ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4200498862
#yiv4200498862ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4200498862
#yiv4200498862ygrp-mlmsg select, #yiv4200498862 input, #yiv4200498862 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv4200498862
#yiv4200498862ygrp-mlmsg pre, #yiv4200498862 code {font:115%
monospace;}#yiv4200498862 #yiv4200498862ygrp-mlmsg *
{line-height:1.22em;}#yiv4200498862 #yiv4200498862ygrp-mlmsg #yiv4200498862logo
{padding-bottom:10px;}#yiv4200498862 #yiv4200498862ygrp-msg p a
{font-family:Verdana;}#yiv4200498862 #yiv4200498862ygrp-msg
p#yiv4200498862attach-count span {color:#1E66AE;font-weight:700;}#yiv4200498862
#yiv4200498862ygrp-reco #yiv4200498862reco-head
{color:#ff7900;font-weight:700;}#yiv4200498862 #yiv4200498862ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv4200498862 #yiv4200498862ygrp-sponsor
#yiv4200498862ov li a {font-size:130%;text-decoration:none;}#yiv4200498862
#yiv4200498862ygrp-sponsor #yiv4200498862ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv4200498862
#yiv4200498862ygrp-sponsor #yiv4200498862ov ul {margin:0;padding:0 0 0
8px;}#yiv4200498862 #yiv4200498862ygrp-text
{font-family:Georgia;}#yiv4200498862 #yiv4200498862ygrp-text p {margin:0 0 1em
0;}#yiv4200498862 #yiv4200498862ygrp-text tt {font-size:120%;}#yiv4200498862
#yiv4200498862ygrp-vital ul li:last-child {border-right:none
!important;}#yiv4200498862
