Minggu, 28 Februari 2016

[smf_addin] Digest Number 3651

4 Messages

Digest #3651

Messages

Sat Feb 27, 2016 6:32 am (PST) . Posted by:

stevet99uk

Is it possible to disable smfForceRecalculate? Want to reopen book without updating the links as a reload of the cache takes awhile and in many cases the existing data is adequate

Sat Feb 27, 2016 7:44 am (PST) . Posted by:

"Randy Harmelink" rharmelink

That isn't something smfForceRecalculation does. If you've closed down and
restarted EXCEL, it will need to retrieve the web pages to extract data
from them. However, if all you did was close the workbook, then reopen it,
the web pages are still saved in the add-in's storage area and would not
need to be retrieved.

On Sat, Feb 27, 2016 at 7:32 AM, stevethompson486@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Is it possible to disable smfForceRecalculate? Want to reopen book without
> updating the links as a reload of the cache takes awhile and in many cases
> the existing data is adequate
>

Sat Feb 27, 2016 11:07 am (PST) . Posted by:

mff2805

hi,
i keep a spreadsheet of info on stocks, pulling data from IBD, Yahoo and others laces. i have ~800 tickers. i recently decided to pull info from Morningstar also, ala what's done in the mstar templates. i find that after pulling info for about 100 tickers or so, i start getting no more info. if i close my spreadsheet and restart, i can continue. is there any way via VBA to reset the pulling of mstar info? accomplish the same thing that closeing my file does. this appears unlike the ibd website where there's a daily limit of 300 stock checkups.
thanks much,
Mike


Sat Feb 27, 2016 11:22 am (PST) . Posted by:

"Randy Harmelink" rharmelink

The way the add-in works is that is saves a copy of the web page you're
extracting data from, then extracts the data from that saved copy of the
web page. That way, if you're extracting 10 items from the web page, the
web page only needs to be retrieved once, instead of once per formula that
extracts data from it.

However, there are only 1000 slots for saving web pages. So any session
that accesses over 1000 web pages will get "Error" for any additional web
pages.

The smfForceRecalculation macro does purge those 1000 slots. However, any
formulas that recalculate would just go right back and get the web pages
again. So it doesn't allow you to "restart" a workbook retrieval process
unless all previously retrieved items have been converted to values first.

On Sat, Feb 27, 2016 at 12:06 PM, mff3429@... wrote:

>
> i keep a spreadsheet of info on stocks, pulling data from IBD, Yahoo and
> others laces. i have ~800 tickers. i recently decided to pull info from
> Morningstar also, ala what's done in the mstar templates. i find that
> after pulling info for about 100 tickers or so, i start getting no more
> info. if i close my spreadsheet and restart, i can continue. is there any
> way via VBA to reset the pulling of mstar info? accomplish the same thing
> that closeing my file does. this appears unlike the ibd website where
> there's a daily limit of 300 stock checkups.
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
READ MORE....
Diposting oleh EXCEL FEED LEARNING di 02.37 0 komentar

Sabtu, 27 Februari 2016

[belajar-excel] Digest Number 3774

2 Messages

Digest #3774

Messages

Fri Feb 26, 2016 2:43 am (PST) . Posted by:

"odong nando"

dear all,
lg bingung mencari nilai lookup sebuah tanggal yang tidak ada di data,
saya punya sederetan tanggal dan nilai, setiap tanggal tidak selalu ada saat dicari, bagaimana caranya agar nilai tanggal sebelumnya dari nilai yang dicari menjadi hasil pencarian dari nilai tanggal yang tidak ada.
br,

odong nando

Fri Feb 26, 2016 6:57 am (PST) . Posted by:

"Arif Wijaya" arifw1979

Terima kasih Mas Susilo atas jawabannya, sangat bermanfaat.

Pada Jumat, 26 Februari 2016 10:04, "Susilo - susilo.ib@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Dear Arif
Berikut saya mencoba untuk memberikan solusi1. Untuk nama yang lulus saya menggunakan Index small if dengan array2. Untuk nomer urut saya menggunakan index match tanpa array
Rumus berikut untuk 500 baris input, jika data input lebih, maka jumlah kolomnya bisa disesuaikan
Terima kasihSusilo

2016-02-25 16:09 GMT+07:00 hendrik karnadi hendrikkarnadi@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com>:

  Hai Arif,Jwb terlampir, tapi formatnya ga persis sama.
Salam,HK

From: "Arif Wijaya arifw1979@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Thursday, 25 February 2016, 12:32
Subject: [belajar-excel] mengambil data sesuai kriteria di kolom lain [1 Attachment]

  Assalamu'alaikumKalau ingin mengambil data yang hanya sesuai kriteria seperti pada lampiran, formulanya bagamaina?Terima kasih

#yiv1769012852 #yiv1769012852 -- #yiv1769012852ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1769012852 #yiv1769012852ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1769012852 #yiv1769012852ygrp-mkp #yiv1769012852hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv1769012852 #yiv1769012852ygrp-mkp #yiv1769012852ads {margin-bottom:10px;}#yiv1769012852 #yiv1769012852ygrp-mkp .yiv1769012852ad {padding:0 0;}#yiv1769012852 #yiv1769012852ygrp-mkp .yiv1769012852ad p {margin:0;}#yiv1769012852 #yiv1769012852ygrp-mkp .yiv1769012852ad a {color:#0000ff;text-decoration:none;}#yiv1769012852 #yiv1769012852ygrp-sponsor #yiv1769012852ygrp-lc {font-family:Arial;}#yiv1769012852 #yiv1769012852ygrp-sponsor #yiv1769012852ygrp-lc #yiv1769012852hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1769012852 #yiv1769012852ygrp-sponsor #yiv1769012852ygrp-lc .yiv1769012852ad {margin-bottom:10px;padding:0 0;}#yiv1769012852 #yiv1769012852actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1769012852 #yiv1769012852activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1769012852 #yiv1769012852activity span {font-weight:700;}#yiv1769012852 #yiv1769012852activity span:first-child {text-transform:uppercase;}#yiv1769012852 #yiv1769012852activity span a {color:#5085b6;text-decoration:none;}#yiv1769012852 #yiv1769012852activity span span {color:#ff7900;}#yiv1769012852 #yiv1769012852activity span .yiv1769012852underline {text-decoration:underline;}#yiv1769012852 .yiv1769012852attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv1769012852 .yiv1769012852attach div a {text-decoration:none;}#yiv1769012852 .yiv1769012852attach img {border:none;padding-right:5px;}#yiv1769012852 .yiv1769012852attach label {display:block;margin-bottom:5px;}#yiv1769012852 .yiv1769012852attach label a {text-decoration:none;}#yiv1769012852 blockquote {margin:0 0 0 4px;}#yiv1769012852 .yiv1769012852bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv1769012852 .yiv1769012852bold a {text-decoration:none;}#yiv1769012852 dd.yiv1769012852last p a {font-family:Verdana;font-weight:700;}#yiv1769012852 dd.yiv1769012852last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1769012852 dd.yiv1769012852last p span.yiv1769012852yshortcuts {margin-right:0;}#yiv1769012852 div.yiv1769012852attach-table div div a {text-decoration:none;}#yiv1769012852 div.yiv1769012852attach-table {width:400px;}#yiv1769012852 div.yiv1769012852file-title a, #yiv1769012852 div.yiv1769012852file-title a:active, #yiv1769012852 div.yiv1769012852file-title a:hover, #yiv1769012852 div.yiv1769012852file-title a:visited {text-decoration:none;}#yiv1769012852 div.yiv1769012852photo-title a, #yiv1769012852 div.yiv1769012852photo-title a:active, #yiv1769012852 div.yiv1769012852photo-title a:hover, #yiv1769012852 div.yiv1769012852photo-title a:visited {text-decoration:none;}#yiv1769012852 div#yiv1769012852ygrp-mlmsg #yiv1769012852ygrp-msg p a span.yiv1769012852yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1769012852 .yiv1769012852green {color:#628c2a;}#yiv1769012852 .yiv1769012852MsoNormal {margin:0 0 0 0;}#yiv1769012852 o {font-size:0;}#yiv1769012852 #yiv1769012852photos div {float:left;width:72px;}#yiv1769012852 #yiv1769012852photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv1769012852 #yiv1769012852photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1769012852 #yiv1769012852reco-category {font-size:77%;}#yiv1769012852 #yiv1769012852reco-desc {font-size:77%;}#yiv1769012852 .yiv1769012852replbq {margin:4px;}#yiv1769012852 #yiv1769012852ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv1769012852 #yiv1769012852ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1769012852 #yiv1769012852ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1769012852 #yiv1769012852ygrp-mlmsg select, #yiv1769012852 input, #yiv1769012852 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv1769012852 #yiv1769012852ygrp-mlmsg pre, #yiv1769012852 code {font:115% monospace;}#yiv1769012852 #yiv1769012852ygrp-mlmsg * {line-height:1.22em;}#yiv1769012852 #yiv1769012852ygrp-mlmsg #yiv1769012852logo {padding-bottom:10px;}#yiv1769012852 #yiv1769012852ygrp-msg p a {font-family:Verdana;}#yiv1769012852 #yiv1769012852ygrp-msg p#yiv1769012852attach-count span {color:#1E66AE;font-weight:700;}#yiv1769012852 #yiv1769012852ygrp-reco #yiv1769012852reco-head {color:#ff7900;font-weight:700;}#yiv1769012852 #yiv1769012852ygrp-reco {margin-bottom:20px;padding:0px;}#yiv1769012852 #yiv1769012852ygrp-sponsor #yiv1769012852ov li a {font-size:130%;text-decoration:none;}#yiv1769012852 #yiv1769012852ygrp-sponsor #yiv1769012852ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv1769012852 #yiv1769012852ygrp-sponsor #yiv1769012852ov ul {margin:0;padding:0 0 0 8px;}#yiv1769012852 #yiv1769012852ygrp-text {font-family:Georgia;}#yiv1769012852 #yiv1769012852ygrp-text p {margin:0 0 1em 0;}#yiv1769012852 #yiv1769012852ygrp-text tt {font-size:120%;}#yiv1769012852 #yiv1769012852ygrp-vital ul li:last-child {border-right:none !important;}#yiv1769012852

============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com
posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com
berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com
keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------
READ MORE....
Diposting oleh EXCEL FEED LEARNING di 02.11 0 komentar

[smf_addin] Digest Number 3650

4 Messages

Digest #3650

Messages

Fri Feb 26, 2016 5:17 am (PST) . Posted by:

herbshack13

Thanks I will look into smfUpdateDownloadTable and see if this solves it.

What about the timer between queries thing -- is that a feature available?


Thanks,
Tom

Fri Feb 26, 2016 5:32 am (PST) . Posted by:

herbshack13

Hmm yeah, that one wouldn't work because my urls are different pages off of one domain.

Fri Feb 26, 2016 8:09 am (PST) . Posted by:

"Randy Harmelink" rharmelink

That's a no on the timer. EXCEL determines the order that cells are
recalculated.

smfUpdateDownloadTable would be the way to go.

On Fri, Feb 26, 2016 at 6:17 AM, therber2@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> What about the timer between queries thing -- is that a feature available?
>
>
>

Fri Feb 26, 2016 8:10 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Not sure what that is referring to?

On Fri, Feb 26, 2016 at 6:32 AM, therber2@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Hmm yeah, that one wouldn't work because my urls are different pages off
> of one domain.
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
READ MORE....
Diposting oleh EXCEL FEED LEARNING di 02.07 0 komentar

Jumat, 26 Februari 2016

[belajar-excel] Digest Number 3773

5 Messages

Digest #3773

Messages

Thu Feb 25, 2016 3:51 am (PST) . Posted by:

"Fatania Latifa"

Sip, terima kasih Mr. Nando, it works :)

On Thu, Feb 25, 2016 at 2:12 PM, odong nando odongnando@yahoo.com
[belajar-excel] <belajar-excel@yahoogroups.com> wrote:

>
>
> saya sering mengalaminya, ga tau jg knp, moga ada master yang dapat
> menjelaskan, namun biasanya untuk menanganinya saya menggunakan gabungan
> formula indirect dan row
>
> caranya ubah bagian formula dinamis menggunakan indirect dan row()
>
> contoh pada J9 didalam sebuah tabel di masukan formula :
>
> =SUMIF($E$8:E9;E9;$I$8:I9)
>
> maka ubahlah menjadi
>
> =SUMIF($E$8:INDIRECT("E"&ROW());E9;$I$8:INDIRECT("i"&ROW()))
>
> lakukan kepada setiap cell dalam tabel yang miliki formula yang range
> formula nya adalah gabungan tetap dan dinamis contoh, sum($A$1:A2) maka
> pada bagian A2 yang tidak ada simbol dolar $, di ganti dengan fungsi
> indirect & row()
>
> note : jika komputer setempat berigional english ubah karakter titik koma
> ";" menjadi koma ","
>
> br,
>
> odong nando
>
>
> Pada Kamis, 25 Februari 2016 11:56, "'Dede Sulaeman'
> dede_sulaeman@pinusmerahabadi.co.id [belajar-excel]" <
> belajar-excel@yahoogroups.com> menulis:
>
>
>
> Dear Mrs, Nia,
>
> See attach.
> Semoga sesuai harapan.
>
> Salam,
> DD
>
> *From:* belajar-excel@yahoogroups.com [mailto:
> belajar-excel@yahoogroups.com]
> *Sent:* 25 Februari 2016 11:30
> *To:* belajar-excel@yahoogroups.com
> *Subject:* RE: [belajar-excel] Tabel update rumus tetapi tidak seperti

> atasnya
>
>
> Dear Mrs Nia,
>
> Coba ganti formulanya di cell L9 seperti dbi :
>
>
> =(LOOKUP(K9;$I$2:$I$5;$J$2:$J$5))+((J9-LOOKUP(K9;$I$2:$I$5;$H$2:$H$5))*K9)-SUMIF($E8:E$9;E9;$L8:L$9)
> Copas kebawah.
>
> Semoga sesuai harapan,
>
> Salam,
> DD
>
> *From:* belajar-excel@yahoogroups.com [mailto:
> belajar-excel@yahoogroups.com]
> *Sent:* 25 Februari 2016 10:57
> *To:* belajar-excel@yahoogroups.com
> *Subject:* [belajar-excel] Tabel update rumus tetapi tidak seperti
> atasnya [1 Attachment]
>
>
> Dear all,
> Mau tanya kalau memakai tabel kenapa rumus data di bawahnya tidak seperti
> atasnya, file terlampir.
> Mohon solusinya, terima kasih.
>
>
>
>

Thu Feb 25, 2016 6:27 am (PST) . Posted by:

"Toby kenzo" tobykenzo

Hai Imam,

Pertama,coba kamu delete semua Name pada Name manager.
Kedua, coba ganti sheet,jgn lupa formulanya yg mengacu ke sheet seblumnya di ubah ke sheet yg baru.

TerimaKasih.

Sent from Yahoo Mail on Android

Thu Feb 25, 2016 7:03 pm (PST) . Posted by:

"Susilo -"

Dear Arif

Berikut saya mencoba untuk memberikan solusi
1. Untuk nama yang lulus saya menggunakan Index small if dengan array
2. Untuk nomer urut saya menggunakan index match tanpa array

Rumus berikut untuk 500 baris input, jika data input lebih, maka jumlah
kolomnya bisa disesuaikan

Terima kasih
Susilo

2016-02-25 16:09 GMT+07:00 hendrik karnadi hendrikkarnadi@yahoo.com
[belajar-excel] <belajar-excel@yahoogroups.com>:

>
>
> Hai Arif,
> Jwb terlampir, tapi formatnya ga persis sama.
>
> Salam,
> HK
>
>
> ------------------------------
> *From:* "Arif Wijaya arifw1979@yahoo.co.id [belajar-excel]" <
> belajar-excel@yahoogroups.com>
> *To:* belajar-excel@yahoogroups.com
> *Sent:* Thursday, 25 February 2016, 12:32
> *Subject:* [belajar-excel] mengambil data sesuai kriteria di kolom lain
> [1 Attachment]
>
>
> Assalamu'alaikum
> Kalau ingin mengambil data yang hanya sesuai kriteria seperti pada
> lampiran, formulanya bagamaina?
> Terima kasih
>
>
>
>
>

Thu Feb 25, 2016 7:04 pm (PST) . Posted by:

"Arif Wijaya" arifw1979

Terima kasih Bung Hendrik atas jawabannya.
Kalau dalam bentuk formula bagaimana?


Pada Kamis, 25 Februari 2016 16:10, "hendrik karnadi hendrikkarnadi@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Hai Arif,Jwb terlampir, tapi formatnya ga persis sama.
Salam,HK

From: "Arif Wijaya arifw1979@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Thursday, 25 February 2016, 12:32
Subject: [belajar-excel] mengambil data sesuai kriteria di kolom lain [1 Attachment]

  Assalamu'alaikumKalau ingin mengambil data yang hanya sesuai kriteria seperti pada lampiran, formulanya bagamaina?Terima kasih

#yiv1913769127 #yiv1913769127 -- #yiv1913769127ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1913769127 #yiv1913769127ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1913769127 #yiv1913769127ygrp-mkp #yiv1913769127hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv1913769127 #yiv1913769127ygrp-mkp #yiv1913769127ads {margin-bottom:10px;}#yiv1913769127 #yiv1913769127ygrp-mkp .yiv1913769127ad {padding:0 0;}#yiv1913769127 #yiv1913769127ygrp-mkp .yiv1913769127ad p {margin:0;}#yiv1913769127 #yiv1913769127ygrp-mkp .yiv1913769127ad a {color:#0000ff;text-decoration:none;}#yiv1913769127 #yiv1913769127ygrp-sponsor #yiv1913769127ygrp-lc {font-family:Arial;}#yiv1913769127 #yiv1913769127ygrp-sponsor #yiv1913769127ygrp-lc #yiv1913769127hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1913769127 #yiv1913769127ygrp-sponsor #yiv1913769127ygrp-lc .yiv1913769127ad {margin-bottom:10px;padding:0 0;}#yiv1913769127 #yiv1913769127actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1913769127 #yiv1913769127activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1913769127 #yiv1913769127activity span {font-weight:700;}#yiv1913769127 #yiv1913769127activity span:first-child {text-transform:uppercase;}#yiv1913769127 #yiv1913769127activity span a {color:#5085b6;text-decoration:none;}#yiv1913769127 #yiv1913769127activity span span {color:#ff7900;}#yiv1913769127 #yiv1913769127activity span .yiv1913769127underline {text-decoration:underline;}#yiv1913769127 .yiv1913769127attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv1913769127 .yiv1913769127attach div a {text-decoration:none;}#yiv1913769127 .yiv1913769127attach img {border:none;padding-right:5px;}#yiv1913769127 .yiv1913769127attach label {display:block;margin-bottom:5px;}#yiv1913769127 .yiv1913769127attach label a {text-decoration:none;}#yiv1913769127 blockquote {margin:0 0 0 4px;}#yiv1913769127 .yiv1913769127bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv1913769127 .yiv1913769127bold a {text-decoration:none;}#yiv1913769127 dd.yiv1913769127last p a {font-family:Verdana;font-weight:700;}#yiv1913769127 dd.yiv1913769127last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1913769127 dd.yiv1913769127last p span.yiv1913769127yshortcuts {margin-right:0;}#yiv1913769127 div.yiv1913769127attach-table div div a {text-decoration:none;}#yiv1913769127 div.yiv1913769127attach-table {width:400px;}#yiv1913769127 div.yiv1913769127file-title a, #yiv1913769127 div.yiv1913769127file-title a:active, #yiv1913769127 div.yiv1913769127file-title a:hover, #yiv1913769127 div.yiv1913769127file-title a:visited {text-decoration:none;}#yiv1913769127 div.yiv1913769127photo-title a, #yiv1913769127 div.yiv1913769127photo-title a:active, #yiv1913769127 div.yiv1913769127photo-title a:hover, #yiv1913769127 div.yiv1913769127photo-title a:visited {text-decoration:none;}#yiv1913769127 div#yiv1913769127ygrp-mlmsg #yiv1913769127ygrp-msg p a span.yiv1913769127yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1913769127 .yiv1913769127green {color:#628c2a;}#yiv1913769127 .yiv1913769127MsoNormal {margin:0 0 0 0;}#yiv1913769127 o {font-size:0;}#yiv1913769127 #yiv1913769127photos div {float:left;width:72px;}#yiv1913769127 #yiv1913769127photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv1913769127 #yiv1913769127photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1913769127 #yiv1913769127reco-category {font-size:77%;}#yiv1913769127 #yiv1913769127reco-desc {font-size:77%;}#yiv1913769127 .yiv1913769127replbq {margin:4px;}#yiv1913769127 #yiv1913769127ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv1913769127 #yiv1913769127ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1913769127 #yiv1913769127ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1913769127 #yiv1913769127ygrp-mlmsg select, #yiv1913769127 input, #yiv1913769127 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv1913769127 #yiv1913769127ygrp-mlmsg pre, #yiv1913769127 code {font:115% monospace;}#yiv1913769127 #yiv1913769127ygrp-mlmsg * {line-height:1.22em;}#yiv1913769127 #yiv1913769127ygrp-mlmsg #yiv1913769127logo {padding-bottom:10px;}#yiv1913769127 #yiv1913769127ygrp-msg p a {font-family:Verdana;}#yiv1913769127 #yiv1913769127ygrp-msg p#yiv1913769127attach-count span {color:#1E66AE;font-weight:700;}#yiv1913769127 #yiv1913769127ygrp-reco #yiv1913769127reco-head {color:#ff7900;font-weight:700;}#yiv1913769127 #yiv1913769127ygrp-reco {margin-bottom:20px;padding:0px;}#yiv1913769127 #yiv1913769127ygrp-sponsor #yiv1913769127ov li a {font-size:130%;text-decoration:none;}#yiv1913769127 #yiv1913769127ygrp-sponsor #yiv1913769127ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv1913769127 #yiv1913769127ygrp-sponsor #yiv1913769127ov ul {margin:0;padding:0 0 0 8px;}#yiv1913769127 #yiv1913769127ygrp-text {font-family:Georgia;}#yiv1913769127 #yiv1913769127ygrp-text p {margin:0 0 1em 0;}#yiv1913769127 #yiv1913769127ygrp-text tt {font-size:120%;}#yiv1913769127 #yiv1913769127ygrp-vital ul li:last-child {border-right:none !important;}#yiv1913769127

Thu Feb 25, 2016 7:04 pm (PST) . Posted by:

"Rudhie" rudhiedhie

Dear Mas Susilo
Terima kasih atas respon dan koreksinya.Case sudah close

Wassalam

Pada Kamis, 25 Februari 2016 14:45, "Susilo - susilo.ib@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Dear Rudhie
Rumus anda seperti berikut=INDEX(B4:B23,MOD(LARGE(COUNTIF(B4:B23,">"&B4:B23)+ROW(1:20)/100,ROW(1:20)),1)*100)

Saya mengubahnya sedikit sebagai berikut :=INDEX(B4:B23,MOD(LARGE(COUNTIF(B4:B23,">="&B4:B23)+ROW(1:20)/100,ROW(1:20)),1)*100)

Silakan dicobaTerima kasih
Susilo

Pada 25 Februari 2016 14.19, Rudhie rudhiedhie@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

  Dear Be Exceller

Selamat SiangMohon pencerahannya sekali lagi tentang filter menggunakan array formula.Saya baru belajar menggunakannya dengan mencoba-coba dari file-file milis excel yang ada disini.Kemudian saya mencoba menerapkannya untuk mengolah data di pekerjaan saya, tetapi saya menemukan kendala,yaitu : ada beberapa data yang tidak muncul saat di filter. (file terlampir sebagai contoh)Bisakah Be Exceller memberikan bantuan untuk menjelaskan permasalahan tersebut ?Mohon kiranya dapat dibantu untuk pencerahannya.

Terima kasih

Rudhie

#yiv5407666381 #yiv5407666381 -- #yiv5407666381ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5407666381 #yiv5407666381ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5407666381 #yiv5407666381ygrp-mkp #yiv5407666381hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5407666381 #yiv5407666381ygrp-mkp #yiv5407666381ads {margin-bottom:10px;}#yiv5407666381 #yiv5407666381ygrp-mkp .yiv5407666381ad {padding:0 0;}#yiv5407666381 #yiv5407666381ygrp-mkp .yiv5407666381ad p {margin:0;}#yiv5407666381 #yiv5407666381ygrp-mkp .yiv5407666381ad a {color:#0000ff;text-decoration:none;}#yiv5407666381 #yiv5407666381ygrp-sponsor #yiv5407666381ygrp-lc {font-family:Arial;}#yiv5407666381 #yiv5407666381ygrp-sponsor #yiv5407666381ygrp-lc #yiv5407666381hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5407666381 #yiv5407666381ygrp-sponsor #yiv5407666381ygrp-lc .yiv5407666381ad {margin-bottom:10px;padding:0 0;}#yiv5407666381 #yiv5407666381actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5407666381 #yiv5407666381activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5407666381 #yiv5407666381activity span {font-weight:700;}#yiv5407666381 #yiv5407666381activity span:first-child {text-transform:uppercase;}#yiv5407666381 #yiv5407666381activity span a {color:#5085b6;text-decoration:none;}#yiv5407666381 #yiv5407666381activity span span {color:#ff7900;}#yiv5407666381 #yiv5407666381activity span .yiv5407666381underline {text-decoration:underline;}#yiv5407666381 .yiv5407666381attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv5407666381 .yiv5407666381attach div a {text-decoration:none;}#yiv5407666381 .yiv5407666381attach img {border:none;padding-right:5px;}#yiv5407666381 .yiv5407666381attach label {display:block;margin-bottom:5px;}#yiv5407666381 .yiv5407666381attach label a {text-decoration:none;}#yiv5407666381 blockquote {margin:0 0 0 4px;}#yiv5407666381 .yiv5407666381bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv5407666381 .yiv5407666381bold a {text-decoration:none;}#yiv5407666381 dd.yiv5407666381last p a {font-family:Verdana;font-weight:700;}#yiv5407666381 dd.yiv5407666381last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5407666381 dd.yiv5407666381last p span.yiv5407666381yshortcuts {margin-right:0;}#yiv5407666381 div.yiv5407666381attach-table div div a {text-decoration:none;}#yiv5407666381 div.yiv5407666381attach-table {width:400px;}#yiv5407666381 div.yiv5407666381file-title a, #yiv5407666381 div.yiv5407666381file-title a:active, #yiv5407666381 div.yiv5407666381file-title a:hover, #yiv5407666381 div.yiv5407666381file-title a:visited {text-decoration:none;}#yiv5407666381 div.yiv5407666381photo-title a, #yiv5407666381 div.yiv5407666381photo-title a:active, #yiv5407666381 div.yiv5407666381photo-title a:hover, #yiv5407666381 div.yiv5407666381photo-title a:visited {text-decoration:none;}#yiv5407666381 div#yiv5407666381ygrp-mlmsg #yiv5407666381ygrp-msg p a span.yiv5407666381yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5407666381 .yiv5407666381green {color:#628c2a;}#yiv5407666381 .yiv5407666381MsoNormal {margin:0 0 0 0;}#yiv5407666381 o {font-size:0;}#yiv5407666381 #yiv5407666381photos div {float:left;width:72px;}#yiv5407666381 #yiv5407666381photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv5407666381 #yiv5407666381photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5407666381 #yiv5407666381reco-category {font-size:77%;}#yiv5407666381 #yiv5407666381reco-desc {font-size:77%;}#yiv5407666381 .yiv5407666381replbq {margin:4px;}#yiv5407666381 #yiv5407666381ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv5407666381 #yiv5407666381ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5407666381 #yiv5407666381ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5407666381 #yiv5407666381ygrp-mlmsg select, #yiv5407666381 input, #yiv5407666381 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv5407666381 #yiv5407666381ygrp-mlmsg pre, #yiv5407666381 code {font:115% monospace;}#yiv5407666381 #yiv5407666381ygrp-mlmsg * {line-height:1.22em;}#yiv5407666381 #yiv5407666381ygrp-mlmsg #yiv5407666381logo {padding-bottom:10px;}#yiv5407666381 #yiv5407666381ygrp-msg p a {font-family:Verdana;}#yiv5407666381 #yiv5407666381ygrp-msg p#yiv5407666381attach-count span {color:#1E66AE;font-weight:700;}#yiv5407666381 #yiv5407666381ygrp-reco #yiv5407666381reco-head {color:#ff7900;font-weight:700;}#yiv5407666381 #yiv5407666381ygrp-reco {margin-bottom:20px;padding:0px;}#yiv5407666381 #yiv5407666381ygrp-sponsor #yiv5407666381ov li a {font-size:130%;text-decoration:none;}#yiv5407666381 #yiv5407666381ygrp-sponsor #yiv5407666381ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv5407666381 #yiv5407666381ygrp-sponsor #yiv5407666381ov ul {margin:0;padding:0 0 0 8px;}#yiv5407666381 #yiv5407666381ygrp-text {font-family:Georgia;}#yiv5407666381 #yiv5407666381ygrp-text p {margin:0 0 1em 0;}#yiv5407666381 #yiv5407666381ygrp-text tt {font-size:120%;}#yiv5407666381 #yiv5407666381ygrp-vital ul li:last-child {border-right:none !important;}#yiv5407666381

============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com
posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com
berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com
keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------
READ MORE....
Diposting oleh EXCEL FEED LEARNING di 02.23 0 komentar
Langganan: Postingan (Atom)