Selasa, 24 Maret 2015

[belajar-excel] Digest Number 3357

10 Messages

Digest #3357
2a
Bls: [belajar-excel] vlookup dengan kriteria dan average by "Krisan Flower" krisan_flower@rocketmail.com
2c
Re: vlookup dengan kriteria dan average by "Mr. Kid" nmkid.family@ymail.com
3
Input Baris Otomatis by "kiki tanjung" kieki_e
4a
Tanya Macro by "Dwi Hartanto"
5a
Bls: [belajar-excel] Tanya Formula [1 Attachment] by "Jerry Luthfianto" jerryluthfianto
5b
Bls: [belajar-excel] Tanya Formula by "Jerry Luthfianto" jerryluthfianto
6
Memangil Data Di Localhost Mysql by "omeza" icat_omez@ymail.com
7a
Re: Memisahkan alamat yg berbeda2 by "omeza" icat_omez@ymail.com

Messages

Tue Mar 24, 2015 12:09 am (PDT) . Posted by:

"ris ha" har1sn.excel

Assalamu'alaikum.
Mohon bantuannya rekan2 master excel semua.Seharian ini, saya utak atik pivot, tapi hasilnya belum sesuai dengan yang diharapkan (file terlampir).Saya ingin Data Blank hilang pada pivot, namun tampaknya memang tidak bisa hilang.
Bagaimana ya caranya...???
Makasih sebelumnya atas pencerahan para master excel semua.
SalamHaris

Tue Mar 24, 2015 12:18 am (PDT) . Posted by:

"Krisan Flower" krisan_flower@rocketmail.com

Dear Pak Uharyanto,
Salam 
Setelah saya pakai hasilnya masih 0 Pak, mohon pencerahan.
Dear Mr. Kid,
saya mencoba menggunakan rumus tersebut tapi masih bingung dalam penentuan criterianya (nilai tidak keluar). saya coba cek di google gak ada literatur tentang AVERAGEIF yang ada cuman average atau if saja. mohon penjelasannya.
Terimakasih,
Krisan,

Pada Selasa, 24 Maret 2015 13:24, "'Mr. Kid' mr.nmkid@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  di xl2007 ke atas ada fungsi Average, AverageIF, dan AverageIFs loh...

;)

2015-03-24 14:29 GMT+11:00 uharyanto uharyanto@gmail.com [belajar-excel] <belajar-excel@yahoogroups.com>:

  Coba pake array formula
{=AVERAGE(IF($B$5:$B$20>=F6,IF($B$5:$B$20<=G6,$C$5:$C$20)))}

Terima kasih.


On 24/03/2015 9:11 AM, Krisan Flower krisan_flower@rocketmail.com [belajar-excel] wrote:

  Dear Para Master,
Salam,
Saya kesulitan dalam mengambil nilai average dari kriteria di sebuah sheet, berikut saya lampirkan contoh kasusnya, Mungkin ada banyak dari rekan2 yang punya persoalan yang sama dengan saya. Makasi sebelumnya.
Krisan.




#yiv3121736440 #yiv3121736440 -- #yiv3121736440ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3121736440 #yiv3121736440ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3121736440 #yiv3121736440ygrp-mkp #yiv3121736440hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3121736440 #yiv3121736440ygrp-mkp #yiv3121736440ads {margin-bottom:10px;}#yiv3121736440 #yiv3121736440ygrp-mkp .yiv3121736440ad {padding:0 0;}#yiv3121736440 #yiv3121736440ygrp-mkp .yiv3121736440ad p {margin:0;}#yiv3121736440 #yiv3121736440ygrp-mkp .yiv3121736440ad a {color:#0000ff;text-decoration:none;}#yiv3121736440 #yiv3121736440ygrp-sponsor #yiv3121736440ygrp-lc {font-family:Arial;}#yiv3121736440 #yiv3121736440ygrp-sponsor #yiv3121736440ygrp-lc #yiv3121736440hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3121736440 #yiv3121736440ygrp-sponsor #yiv3121736440ygrp-lc .yiv3121736440ad {margin-bottom:10px;padding:0 0;}#yiv3121736440 #yiv3121736440actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3121736440 #yiv3121736440activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3121736440 #yiv3121736440activity span {font-weight:700;}#yiv3121736440 #yiv3121736440activity span:first-child {text-transform:uppercase;}#yiv3121736440 #yiv3121736440activity span a {color:#5085b6;text-decoration:none;}#yiv3121736440 #yiv3121736440activity span span {color:#ff7900;}#yiv3121736440 #yiv3121736440activity span .yiv3121736440underline {text-decoration:underline;}#yiv3121736440 .yiv3121736440attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3121736440 .yiv3121736440attach div a {text-decoration:none;}#yiv3121736440 .yiv3121736440attach img {border:none;padding-right:5px;}#yiv3121736440 .yiv3121736440attach label {display:block;margin-bottom:5px;}#yiv3121736440 .yiv3121736440attach label a {text-decoration:none;}#yiv3121736440 blockquote {margin:0 0 0 4px;}#yiv3121736440 .yiv3121736440bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3121736440 .yiv3121736440bold a {text-decoration:none;}#yiv3121736440 dd.yiv3121736440last p a {font-family:Verdana;font-weight:700;}#yiv3121736440 dd.yiv3121736440last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3121736440 dd.yiv3121736440last p span.yiv3121736440yshortcuts {margin-right:0;}#yiv3121736440 div.yiv3121736440attach-table div div a {text-decoration:none;}#yiv3121736440 div.yiv3121736440attach-table {width:400px;}#yiv3121736440 div.yiv3121736440file-title a, #yiv3121736440 div.yiv3121736440file-title a:active, #yiv3121736440 div.yiv3121736440file-title a:hover, #yiv3121736440 div.yiv3121736440file-title a:visited {text-decoration:none;}#yiv3121736440 div.yiv3121736440photo-title a, #yiv3121736440 div.yiv3121736440photo-title a:active, #yiv3121736440 div.yiv3121736440photo-title a:hover, #yiv3121736440 div.yiv3121736440photo-title a:visited {text-decoration:none;}#yiv3121736440 div#yiv3121736440ygrp-mlmsg #yiv3121736440ygrp-msg p a span.yiv3121736440yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3121736440 .yiv3121736440green {color:#628c2a;}#yiv3121736440 .yiv3121736440MsoNormal {margin:0 0 0 0;}#yiv3121736440 o {font-size:0;}#yiv3121736440 #yiv3121736440photos div {float:left;width:72px;}#yiv3121736440 #yiv3121736440photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv3121736440 #yiv3121736440photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3121736440 #yiv3121736440reco-category {font-size:77%;}#yiv3121736440 #yiv3121736440reco-desc {font-size:77%;}#yiv3121736440 .yiv3121736440replbq {margin:4px;}#yiv3121736440 #yiv3121736440ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3121736440 #yiv3121736440ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3121736440 #yiv3121736440ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3121736440 #yiv3121736440ygrp-mlmsg select, #yiv3121736440 input, #yiv3121736440 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3121736440 #yiv3121736440ygrp-mlmsg pre, #yiv3121736440 code {font:115% monospace;}#yiv3121736440 #yiv3121736440ygrp-mlmsg * {line-height:1.22em;}#yiv3121736440 #yiv3121736440ygrp-mlmsg #yiv3121736440logo {padding-bottom:10px;}#yiv3121736440 #yiv3121736440ygrp-msg p a {font-family:Verdana;}#yiv3121736440 #yiv3121736440ygrp-msg p#yiv3121736440attach-count span {color:#1E66AE;font-weight:700;}#yiv3121736440 #yiv3121736440ygrp-reco #yiv3121736440reco-head {color:#ff7900;font-weight:700;}#yiv3121736440 #yiv3121736440ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3121736440 #yiv3121736440ygrp-sponsor #yiv3121736440ov li a {font-size:130%;text-decoration:none;}#yiv3121736440 #yiv3121736440ygrp-sponsor #yiv3121736440ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3121736440 #yiv3121736440ygrp-sponsor #yiv3121736440ov ul {margin:0;padding:0 0 0 8px;}#yiv3121736440 #yiv3121736440ygrp-text {font-family:Georgia;}#yiv3121736440 #yiv3121736440ygrp-text p {margin:0 0 1em 0;}#yiv3121736440 #yiv3121736440ygrp-text tt {font-size:120%;}#yiv3121736440 #yiv3121736440ygrp-vital ul li:last-child {border-right:none !important;}#yiv3121736440

Tue Mar 24, 2015 12:39 am (PDT) . Posted by:

"Dede"

Dear Mr Krisan,

Ikutan nimbrung yah.....

Formula dari Mr Haryanto sudah OK koq.

Mungkin kurung kurawalnya hilang, makanya nilai yang dihasilkan 0. Karena rumusnya jadi seperti ini =AVERAGE(IF($B$5:$B$20>=F6,IF($B$5:$B$20<=G6,$C$5:$C$20)))

Coba praktekkan langkah berikut :

1. Latakkan kursor d cell H6

2. Tekan F2 dibarisan paling atas

3. Tekan Ctrl+Shift+Enter secara bersamaan (lokasi tombolnya yang ditengah yah, ini satu group) atau Tekan Ctrl+Shift+Enter secara bersamaan (lokasi tombolnya paling kiri untuk ctrl+shift dan enter posisi paling kanan,ini satu group).

4. Sehingga formula akan tampil seperti ini {=AVERAGE(IF($B$5:$B$20>=F6,IF($B$5:$B$20<=G6,$C$5:$C$20)))}

Semoga nggak bingung yah..

Salam

DD

From: Krisan Flower krisan_flower@rocketmail.com [belajar-excel] [mailto:belajar-excel@yahoogroups.com]
Sent: 24 Maret 2015 13:32
To: belajar-excel@yahoogroups.com
Subject: Bls: [belajar-excel] vlookup dengan kriteria dan average

Dear Pak Uharyanto,

Salam

Setelah saya pakai hasilnya masih 0 Pak, mohon pencerahan.

Dear Mr. Kid,

saya mencoba menggunakan rumus tersebut tapi masih bingung dalam penentuan criterianya (nilai tidak keluar). saya coba cek di google gak ada literatur tentang AVERAGEIF yang ada cuman average atau if saja. mohon penjelasannya.

Terimakasih,

Krisan,

Pada Selasa, 24 Maret 2015 13:24, "'Mr. Kid' mr.nmkid@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:

di xl2007 ke atas ada fungsi Average, AverageIF, dan AverageIFs loh...

;)

2015-03-24 14:29 GMT+11:00 uharyanto uharyanto@gmail.com [belajar-excel] <belajar-excel@yahoogroups.com>:

Coba pake array formula
{=AVERAGE(IF($B$5:$B$20>=F6,IF($B$5:$B$20<=G6,$C$5:$C$20)))}

Terima kasih.

On 24/03/2015 9:11 AM, Krisan Flower krisan_flower@rocketmail.com [belajar-excel] wrote:

Dear Para Master,

Salam,

Saya kesulitan dalam mengambil nilai average dari kriteria di sebuah sheet,

berikut saya lampirkan contoh kasusnya, Mungkin ada banyak dari rekan2 yang punya persoalan yang sama dengan saya. Makasi sebelumnya.

Krisan.

_____

This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual to whom it is addressed. If you have received this email in error please send it back to the person that sent it to you. Any views or opinions presented are solely those of its author and do not necessarily represent those of NABATI or any of its subsidiary companies. Unauthorized publication, use, dissemination, forwarding, printing or copying of this email and its associated attachments is strictly prohibited.

Tue Mar 24, 2015 12:40 am (PDT) . Posted by:

"Mr. Kid" nmkid.family@ymail.com

hehehe...

Sering menggunakan fungsi Sum ?
-> menjumlahkan nilai-nilai numerik suatu range
-> contoh : total nilai penjualan (kolom A) =Sum( a1:a100 )

Pernah kenal SumIF ?
-> menjumlahkan nilai-nilai numerik berdasar 1 (SATU) kriteria
-> contoh : total penjualan (kolom A) untuk produk (kolom B) mobil
=SumIF( b1:b100 , "mobil" , a1:a100 )

Pernah dengar SumIFs ?
-> menjumlahkan nilai-nilai numerik berdasar BANYAK kriteria (minimal 1
(SATU) kriteria)
-> contoh : Total penjualan (kolom A) untuk bulan Agustus 1945 (kolom C
bertipe datetime berdata tanggal)
=SumIFs( a1:a100 , c1:c100 , ">=" & 1*
"1945-08-01" , c1:c100 , "<=" & 1* "1945-08-31" )

Cara pakai Average mirip dengan cara pakai Sum bukan ? Hanya nama fungsinya
yang berbeda.
Cara pakai AverageIF juga sama dengan cara pakai SumIF.
Jadi cara pakai AverageIFs sama dengan SumIFs.
Kenapa ?

Contoh referensi untuk averageif dan averageIFs (sayangnya memang ndak ada
di google... untungnya ada di microsoft)
https://support.office.com/en-za/article/AVERAGEIF-function-ff3c70f9-5afe-4d3e-87d4-717187f98c20?ui=en-US&rs=en-ZA&ad=ZA
https://support.office.com/en-us/article/AVERAGEIFS-function-4cca2550-dab3-41c4-bcd2-648e17f20553?ui=en-US&rs=en-US&ad=US
;) untungnya, google bisa nyariin jalan untuk ketemu dengan microsoft

Sebenarnya kalau punya Excel Help yang bisa dibuka offline di komputer akan
lebih enak, karena ndak usah repot cari jaringan internet dan cari link ke
microsoft.

Wassalam,
Kid

2015-03-24 17:31 GMT+11:00 Krisan Flower krisan_flower@rocketmail.com
[belajar-excel] <belajar-excel@yahoogroups.com>:

>
>
> Dear Pak Uharyanto,
>
> Salam
>
> Setelah saya pakai hasilnya masih 0 Pak, mohon pencerahan.
>
> Dear Mr. Kid,
>
> saya mencoba menggunakan rumus tersebut tapi masih bingung dalam penentuan
> criterianya (nilai tidak keluar). saya coba cek di google gak ada literatur
> tentang AVERAGEIF yang ada cuman average atau if saja. mohon penjelasannya.
>
> Terimakasih,
>
> Krisan,
>
>
>
>
> Pada Selasa, 24 Maret 2015 13:24, "'Mr. Kid' mr.nmkid@gmail.com
> [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
>
>
>
> di xl2007 ke atas ada fungsi Average, AverageIF, dan AverageIFs loh...
>
> ;)
>
>
> 2015-03-24 14:29 GMT+11:00 uharyanto uharyanto@gmail.com [belajar-excel] <
> belajar-excel@yahoogroups.com>:
>
>
> Coba pake array formula
> {=AVERAGE(IF($B$5:$B$20>=F6,IF($B$5:$B$20<=G6,$C$5:$C$20)))}
>
> Terima kasih.
>
>
> On 24/03/2015 9:11 AM, Krisan Flower krisan_flower@rocketmail.com
> [belajar-excel] wrote:
>
>
> Dear Para Master,
>
> Salam,
>
> Saya kesulitan dalam mengambil nilai average dari kriteria di sebuah
> sheet,
> berikut saya lampirkan contoh kasusnya, Mungkin ada banyak dari rekan2
> yang punya persoalan yang sama dengan saya. Makasi sebelumnya.
>
> Krisan.
>
>
>
>
>
>
>

Tue Mar 24, 2015 12:24 am (PDT) . Posted by:

"kiki tanjung" kieki_e

Dear Rekan -rekan
Mohon pencerahan otomatisasi cara input 2 tabel yang berada dalam dua workbook
1. Tabel PO2. Tabel Invoice
Tabel invoice merupakan data2 dari Tabel PO dengan penambahan beberapa kolom
Terlampir file kasus

Terima kasih atas pencerahan dari rekan rekan

Tue Mar 24, 2015 12:52 am (PDT) . Posted by:

"Dwi Hartanto"

Salam Guru,Saya buat rekam macro dan bagaimana menjalankannya rumus macro tersebut sampai data terakhir, karena pada saat dijalankan out of stack selalu pada baris ke 180Terima kasih

Tue Mar 24, 2015 1:48 am (PDT) . Posted by:

"Jerry Luthfianto" jerryluthfianto

Dear mas Dede,
Makasih atas bantuannya..

Pada Selasa, 24 Maret 2015 8:50, "Dede pmaho_log4@nabatisnack.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  DearMr. Jerry,   Sayapinjam formulanya Mas Agus yah. Seeattach.   Salam, Dede   From: Nang Agusnangagus@gmail.com [belajar-excel] [mailto:belajar-excel@yahoogroups.com]
Sent: 24 Maret 2015 07:27
To: BExcel
Subject: Re: [belajar-excel] Tanya Formula     Coba yaa: di V5 diketik formula:
=IF(Q5<$Q$3,INDEX($U$21:$U$23,MATCH(T5,$T$21:$T$23,0))*S5) di W5 ketik formula:
=S5-V5+INDEX($O$18:$Q$18,,MATCH(U5,$O$17:$Q$17,0)) copy ke bawah Salam   2015-03-23 22:38 GMT+07:00 jerryluthfianto@yahoo.co.id[belajar-excel] <belajar-excel@yahoogroups.com>:   Selamat malam,   Saya punya tabel seperti diattachment, dan saya ingin memasukkan data sbb: 1. Diskon Jika tiket dibeli lebih dari 60hari sebelumnya, maka mendapat diskon, Jumlah diskon diambil dari Tabel Kelassesuai Kode Tiket dikali Harga   2.Harga Jual Diambil dari Harga dikurangi Diskonditambah Harga Menu. Harga Menu diambil dari Tabel Menu Makanan sesuai KodeTiket.   Bagaimana Formula ini ditulis??   Terima kasih
Jerry       This e-mail and any files transmitted with it are confidential andintended solely for the use of the individual to whom it is addressed. If youhave received this email in error please send it back to the person that sentit to you. Any views or opinions presented are solely those of its author anddo not necessarily represent those of NABATI or any of its subsidiarycompanies. Unauthorized publication, use, dissemination, forwarding, printingor copying of this email and its associated attachments is strictly prohibited. #yiv6994258746 #yiv6994258746 -- #yiv6994258746ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6994258746 #yiv6994258746ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6994258746 #yiv6994258746ygrp-mkp #yiv6994258746hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv6994258746 #yiv6994258746ygrp-mkp #yiv6994258746ads {margin-bottom:10px;}#yiv6994258746 #yiv6994258746ygrp-mkp .yiv6994258746ad {padding:0 0;}#yiv6994258746 #yiv6994258746ygrp-mkp .yiv6994258746ad p {margin:0;}#yiv6994258746 #yiv6994258746ygrp-mkp .yiv6994258746ad a {color:#0000ff;text-decoration:none;}#yiv6994258746 #yiv6994258746ygrp-sponsor #yiv6994258746ygrp-lc {font-family:Arial;}#yiv6994258746 #yiv6994258746ygrp-sponsor #yiv6994258746ygrp-lc #yiv6994258746hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6994258746 #yiv6994258746ygrp-sponsor #yiv6994258746ygrp-lc .yiv6994258746ad {margin-bottom:10px;padding:0 0;}#yiv6994258746 #yiv6994258746actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6994258746 #yiv6994258746activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6994258746 #yiv6994258746activity span {font-weight:700;}#yiv6994258746 #yiv6994258746activity span:first-child {text-transform:uppercase;}#yiv6994258746 #yiv6994258746activity span a {color:#5085b6;text-decoration:none;}#yiv6994258746 #yiv6994258746activity span span {color:#ff7900;}#yiv6994258746 #yiv6994258746activity span .yiv6994258746underline {text-decoration:underline;}#yiv6994258746 .yiv6994258746attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv6994258746 .yiv6994258746attach div a {text-decoration:none;}#yiv6994258746 .yiv6994258746attach img {border:none;padding-right:5px;}#yiv6994258746 .yiv6994258746attach label {display:block;margin-bottom:5px;}#yiv6994258746 .yiv6994258746attach label a {text-decoration:none;}#yiv6994258746 blockquote {margin:0 0 0 4px;}#yiv6994258746 .yiv6994258746bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv6994258746 .yiv6994258746bold a {text-decoration:none;}#yiv6994258746 dd.yiv6994258746last p a {font-family:Verdana;font-weight:700;}#yiv6994258746 dd.yiv6994258746last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6994258746 dd.yiv6994258746last p span.yiv6994258746yshortcuts {margin-right:0;}#yiv6994258746 div.yiv6994258746attach-table div div a {text-decoration:none;}#yiv6994258746 div.yiv6994258746attach-table {width:400px;}#yiv6994258746 div.yiv6994258746file-title a, #yiv6994258746 div.yiv6994258746file-title a:active, #yiv6994258746 div.yiv6994258746file-title a:hover, #yiv6994258746 div.yiv6994258746file-title a:visited {text-decoration:none;}#yiv6994258746 div.yiv6994258746photo-title a, #yiv6994258746 div.yiv6994258746photo-title a:active, #yiv6994258746 div.yiv6994258746photo-title a:hover, #yiv6994258746 div.yiv6994258746photo-title a:visited {text-decoration:none;}#yiv6994258746 div#yiv6994258746ygrp-mlmsg #yiv6994258746ygrp-msg p a span.yiv6994258746yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6994258746 .yiv6994258746green {color:#628c2a;}#yiv6994258746 .yiv6994258746MsoNormal {margin:0 0 0 0;}#yiv6994258746 o {font-size:0;}#yiv6994258746 #yiv6994258746photos div {float:left;width:72px;}#yiv6994258746 #yiv6994258746photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv6994258746 #yiv6994258746photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6994258746 #yiv6994258746reco-category {font-size:77%;}#yiv6994258746 #yiv6994258746reco-desc {font-size:77%;}#yiv6994258746 .yiv6994258746replbq {margin:4px;}#yiv6994258746 #yiv6994258746ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv6994258746 #yiv6994258746ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6994258746 #yiv6994258746ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6994258746 #yiv6994258746ygrp-mlmsg select, #yiv6994258746 input, #yiv6994258746 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv6994258746 #yiv6994258746ygrp-mlmsg pre, #yiv6994258746 code {font:115% monospace;}#yiv6994258746 #yiv6994258746ygrp-mlmsg * {line-height:1.22em;}#yiv6994258746 #yiv6994258746ygrp-mlmsg #yiv6994258746logo {padding-bottom:10px;}#yiv6994258746 #yiv6994258746ygrp-msg p a {font-family:Verdana;}#yiv6994258746 #yiv6994258746ygrp-msg p#yiv6994258746attach-count span {color:#1E66AE;font-weight:700;}#yiv6994258746 #yiv6994258746ygrp-reco #yiv6994258746reco-head {color:#ff7900;font-weight:700;}#yiv6994258746 #yiv6994258746ygrp-reco {margin-bottom:20px;padding:0px;}#yiv6994258746 #yiv6994258746ygrp-sponsor #yiv6994258746ov li a {font-size:130%;text-decoration:none;}#yiv6994258746 #yiv6994258746ygrp-sponsor #yiv6994258746ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv6994258746 #yiv6994258746ygrp-sponsor #yiv6994258746ov ul {margin:0;padding:0 0 0 8px;}#yiv6994258746 #yiv6994258746ygrp-text {font-family:Georgia;}#yiv6994258746 #yiv6994258746ygrp-text p {margin:0 0 1em 0;}#yiv6994258746 #yiv6994258746ygrp-text tt {font-size:120%;}#yiv6994258746 #yiv6994258746ygrp-vital ul li:last-child {border-right:none !important;}#yiv6994258746

Tue Mar 24, 2015 2:00 am (PDT) . Posted by:

"Jerry Luthfianto" jerryluthfianto

Mas Nang Agus maksih atas bantuannya

Pada Selasa, 24 Maret 2015 15:48, "Jerry Luthfianto jerryluthfianto@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Dear mas Dede,
Makasih atas bantuannya..

Pada Selasa, 24 Maret 2015 8:50, "Dede pmaho_log4@nabatisnack.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  DearMr. Jerry,   Sayapinjam formulanya Mas Agus yah. Seeattach.   Salam, Dede   From: Nang Agusnangagus@gmail.com [belajar-excel] [mailto:belajar-excel@yahoogroups.com]
Sent: 24 Maret 2015 07:27
To: BExcel
Subject: Re: [belajar-excel] Tanya Formula     Coba yaa: di V5 diketik formula:
=IF(Q5<$Q$3,INDEX($U$21:$U$23,MATCH(T5,$T$21:$T$23,0))*S5) di W5 ketik formula:
=S5-V5+INDEX($O$18:$Q$18,,MATCH(U5,$O$17:$Q$17,0)) copy ke bawah Salam   2015-03-23 22:38 GMT+07:00 jerryluthfianto@yahoo.co.id[belajar-excel] <belajar-excel@yahoogroups.com>:   Selamat malam,   Saya punya tabel seperti diattachment, dan saya ingin memasukkan data sbb: 1. Diskon Jika tiket dibeli lebih dari 60hari sebelumnya, maka mendapat diskon, Jumlah diskon diambil dari Tabel Kelassesuai Kode Tiket dikali Harga   2.Harga Jual Diambil dari Harga dikurangi Diskonditambah Harga Menu. Harga Menu diambil dari Tabel Menu Makanan sesuai KodeTiket.   Bagaimana Formula ini ditulis??   Terima kasih
Jerry       This e-mail and any files transmitted with it are confidential andintended solely for the use of the individual to whom it is addressed. If youhave received this email in error please send it back to the person that sentit to you. Any views or opinions presented are solely those of its author anddo not necessarily represent those of NABATI or any of its subsidiarycompanies. Unauthorized publication, use, dissemination, forwarding, printingor copying of this email and its associated attachments is strictly prohibited.

#yiv5553299321 #yiv5553299321 -- #yiv5553299321ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5553299321 #yiv5553299321ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5553299321 #yiv5553299321ygrp-mkp #yiv5553299321hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5553299321 #yiv5553299321ygrp-mkp #yiv5553299321ads {margin-bottom:10px;}#yiv5553299321 #yiv5553299321ygrp-mkp .yiv5553299321ad {padding:0 0;}#yiv5553299321 #yiv5553299321ygrp-mkp .yiv5553299321ad p {margin:0;}#yiv5553299321 #yiv5553299321ygrp-mkp .yiv5553299321ad a {color:#0000ff;text-decoration:none;}#yiv5553299321 #yiv5553299321ygrp-sponsor #yiv5553299321ygrp-lc {font-family:Arial;}#yiv5553299321 #yiv5553299321ygrp-sponsor #yiv5553299321ygrp-lc #yiv5553299321hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5553299321 #yiv5553299321ygrp-sponsor #yiv5553299321ygrp-lc .yiv5553299321ad {margin-bottom:10px;padding:0 0;}#yiv5553299321 #yiv5553299321actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5553299321 #yiv5553299321activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5553299321 #yiv5553299321activity span {font-weight:700;}#yiv5553299321 #yiv5553299321activity span:first-child {text-transform:uppercase;}#yiv5553299321 #yiv5553299321activity span a {color:#5085b6;text-decoration:none;}#yiv5553299321 #yiv5553299321activity span span {color:#ff7900;}#yiv5553299321 #yiv5553299321activity span .yiv5553299321underline {text-decoration:underline;}#yiv5553299321 .yiv5553299321attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv5553299321 .yiv5553299321attach div a {text-decoration:none;}#yiv5553299321 .yiv5553299321attach img {border:none;padding-right:5px;}#yiv5553299321 .yiv5553299321attach label {display:block;margin-bottom:5px;}#yiv5553299321 .yiv5553299321attach label a {text-decoration:none;}#yiv5553299321 blockquote {margin:0 0 0 4px;}#yiv5553299321 .yiv5553299321bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv5553299321 .yiv5553299321bold a {text-decoration:none;}#yiv5553299321 dd.yiv5553299321last p a {font-family:Verdana;font-weight:700;}#yiv5553299321 dd.yiv5553299321last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5553299321 dd.yiv5553299321last p span.yiv5553299321yshortcuts {margin-right:0;}#yiv5553299321 div.yiv5553299321attach-table div div a {text-decoration:none;}#yiv5553299321 div.yiv5553299321attach-table {width:400px;}#yiv5553299321 div.yiv5553299321file-title a, #yiv5553299321 div.yiv5553299321file-title a:active, #yiv5553299321 div.yiv5553299321file-title a:hover, #yiv5553299321 div.yiv5553299321file-title a:visited {text-decoration:none;}#yiv5553299321 div.yiv5553299321photo-title a, #yiv5553299321 div.yiv5553299321photo-title a:active, #yiv5553299321 div.yiv5553299321photo-title a:hover, #yiv5553299321 div.yiv5553299321photo-title a:visited {text-decoration:none;}#yiv5553299321 div#yiv5553299321ygrp-mlmsg #yiv5553299321ygrp-msg p a span.yiv5553299321yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5553299321 .yiv5553299321green {color:#628c2a;}#yiv5553299321 .yiv5553299321MsoNormal {margin:0 0 0 0;}#yiv5553299321 o {font-size:0;}#yiv5553299321 #yiv5553299321photos div {float:left;width:72px;}#yiv5553299321 #yiv5553299321photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv5553299321 #yiv5553299321photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5553299321 #yiv5553299321reco-category {font-size:77%;}#yiv5553299321 #yiv5553299321reco-desc {font-size:77%;}#yiv5553299321 .yiv5553299321replbq {margin:4px;}#yiv5553299321 #yiv5553299321ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv5553299321 #yiv5553299321ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5553299321 #yiv5553299321ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5553299321 #yiv5553299321ygrp-mlmsg select, #yiv5553299321 input, #yiv5553299321 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv5553299321 #yiv5553299321ygrp-mlmsg pre, #yiv5553299321 code {font:115% monospace;}#yiv5553299321 #yiv5553299321ygrp-mlmsg * {line-height:1.22em;}#yiv5553299321 #yiv5553299321ygrp-mlmsg #yiv5553299321logo {padding-bottom:10px;}#yiv5553299321 #yiv5553299321ygrp-msg p a {font-family:Verdana;}#yiv5553299321 #yiv5553299321ygrp-msg p#yiv5553299321attach-count span {color:#1E66AE;font-weight:700;}#yiv5553299321 #yiv5553299321ygrp-reco #yiv5553299321reco-head {color:#ff7900;font-weight:700;}#yiv5553299321 #yiv5553299321ygrp-reco {margin-bottom:20px;padding:0px;}#yiv5553299321 #yiv5553299321ygrp-sponsor #yiv5553299321ov li a {font-size:130%;text-decoration:none;}#yiv5553299321 #yiv5553299321ygrp-sponsor #yiv5553299321ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv5553299321 #yiv5553299321ygrp-sponsor #yiv5553299321ov ul {margin:0;padding:0 0 0 8px;}#yiv5553299321 #yiv5553299321ygrp-text {font-family:Georgia;}#yiv5553299321 #yiv5553299321ygrp-text p {margin:0 0 1em 0;}#yiv5553299321 #yiv5553299321ygrp-text tt {font-size:120%;}#yiv5553299321 #yiv5553299321ygrp-vital ul li:last-child {border-right:none !important;}#yiv5553299321

Tue Mar 24, 2015 2:22 am (PDT) . Posted by:

"omeza" icat_omez@ymail.com

Slemat Sore Master,,,,Saya ingin bertanya bisakah saya memangil data di
localhost mysql dan ditampilkan di sheeet excel..dengan macro,,saya
mengunakan conecctor ODBC dan sudah saya koneksikan dengan databese yg ada
di localhost dan sukses..bagaimanakah koding,a untuk memangil data tersebut
ke excle... terima kasih semoga para master bisa memberikan pencerahan
atas masalah ini.. berikut saya lampirkan
tampilanya.. koneksi222.jpg
<http://milis-belajar-excel.1048464.n5.nabble.com/file/n5729702/koneksi222.jpg>
koneksi.jpg
<http://milis-belajar-excel.1048464.n5.nabble.com/file/n5729702/koneksi.jpg>
MYsql.xlsx
<http://milis-belajar-excel.1048464.n5.nabble.com/file/n5729702/MYsql.xlsx>

--
View this message in context: http://milis-belajar-excel.1048464.n5.nabble.com/Memangil-Data-Di-Localhost-Mysql-tp5729702.html
Sent from the Milis Belajar Excel mailing list archive at Nabble.com.

Tue Mar 24, 2015 2:22 am (PDT) . Posted by:

"omeza" icat_omez@ymail.com

terima kasih MR.HK Formula.a manjur buat masalah yg saya hadapi kemaren.....
terima kasih ...MR.HK

--
View this message in context: http://milis-belajar-excel.1048464.n5.nabble.com/Memisahkan-alamat-yg-berbeda2-tp5729647p5729703.html
Sent from the Milis Belajar Excel mailing list archive at Nabble.com.

============================================================
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
---------------------------------------------------------------------

Tidak ada komentar:

Poskan Komentar