[belajar-excel] Digest Number 3236

Milis Belajar Microsoft Excel Group

7 Messages

Digest #3236

1a

Re: Help, menanpilkan data terakhir yang tidak nol by "hendrik karnadi" hendrikkarnadi

2

Menampilakan 10 Data by icat_omez@ymail.com

3a

Re: Menampilakan 10 Data [1 Attachment] by "Hendrik Karnadi" hendrikkarnadi

3b

Re: Menampilakan 10 Data by "hendrik karnadi" hendrikkarnadi

3c

Bls: [belajar-excel] Menampilakan 10 Data by "Icat Omez" icat_omez@ymail.com

3d

Bls: [belajar-excel] Menampilakan 10 Data by "Icat Omez" icat_omez@ymail.com

4

Vlookup problems by "hendrik karnadi" hendrikkarnadi

Messages

1a

Re: Help, menanpilkan data terakhir yang tidak nol

Mon Dec 22, 2014 7:03 am (PST) . Posted by:

"hendrik karnadi" hendrikkarnadi

Hai Yuridis,Mis nilai Max mau ditampilkan di H1, maka pada sel H1 diketik Formula berikut ini:=MAX(IF(A1:G1>0,A1:G1)) lalu tekan Ctrl Shift Enter  secara bersamaan (Array Formula)

Yang tampak di Formula Bar adalah :{=MAX(IF(A1:H1>0,A1:H1))} dimana tanda buka tutup kurung kurawal (warna merah) tidak diketik melainkan tampak setelah kita menekan tombol Ctrl Shift Enter.

Salam,HK
From: "Yuridhis Kurniawan diesel_mdr@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Monday, 22 December 2014, 12:36
Subject: [belajar-excel] Help, menanpilkan data terakhir yang tidak nol

 
| Dear all,

Mohon bantuannya saya ingin menampilkan data terakhir dari deretan data yang tidak nol di excel.
Misalkan saya punya data :
A1 : 10
B1 : 20
C1 : 35
D1 : 45
E1 : 0
F1 : 0
G1: 0
Dari data A1:G1 diatas yang saya ingin ditampilkan adalah 45.
Mohon bantuannya, formula excel untuk case diatas.

Terima kasih

Rgds,
Yuridhis Hwang

Sent from Yahoo Mail for iPhone |

#yiv1596285924 #yiv1596285924 -- #yiv1596285924ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1596285924 #yiv1596285924ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1596285924 #yiv1596285924ygrp-mkp #yiv1596285924hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv1596285924 #yiv1596285924ygrp-mkp #yiv1596285924ads {margin-bottom:10px;}#yiv1596285924 #yiv1596285924ygrp-mkp .yiv1596285924ad {padding:0 0;}#yiv1596285924 #yiv1596285924ygrp-mkp .yiv1596285924ad p {margin:0;}#yiv1596285924 #yiv1596285924ygrp-mkp .yiv1596285924ad a {color:#0000ff;text-decoration:none;}#yiv1596285924 #yiv1596285924ygrp-sponsor #yiv1596285924ygrp-lc {font-family:Arial;}#yiv1596285924 #yiv1596285924ygrp-sponsor #yiv1596285924ygrp-lc #yiv1596285924hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1596285924 #yiv1596285924ygrp-sponsor #yiv1596285924ygrp-lc .yiv1596285924ad {margin-bottom:10px;padding:0 0;}#yiv1596285924 #yiv1596285924actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1596285924 #yiv1596285924activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1596285924 #yiv1596285924activity span {font-weight:700;}#yiv1596285924 #yiv1596285924activity span:first-child {text-transform:uppercase;}#yiv1596285924 #yiv1596285924activity span a {color:#5085b6;text-decoration:none;}#yiv1596285924 #yiv1596285924activity span span {color:#ff7900;}#yiv1596285924 #yiv1596285924activity span .yiv1596285924underline {text-decoration:underline;}#yiv1596285924 .yiv1596285924attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv1596285924 .yiv1596285924attach div a {text-decoration:none;}#yiv1596285924 .yiv1596285924attach img {border:none;padding-right:5px;}#yiv1596285924 .yiv1596285924attach label {display:block;margin-bottom:5px;}#yiv1596285924 .yiv1596285924attach label a {text-decoration:none;}#yiv1596285924 blockquote {margin:0 0 0 4px;}#yiv1596285924 .yiv1596285924bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv1596285924 .yiv1596285924bold a {text-decoration:none;}#yiv1596285924 dd.yiv1596285924last p a {font-family:Verdana;font-weight:700;}#yiv1596285924 dd.yiv1596285924last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1596285924 dd.yiv1596285924last p span.yiv1596285924yshortcuts {margin-right:0;}#yiv1596285924 div.yiv1596285924attach-table div div a {text-decoration:none;}#yiv1596285924 div.yiv1596285924attach-table {width:400px;}#yiv1596285924 div.yiv1596285924file-title a, #yiv1596285924 div.yiv1596285924file-title a:active, #yiv1596285924 div.yiv1596285924file-title a:hover, #yiv1596285924 div.yiv1596285924file-title a:visited {text-decoration:none;}#yiv1596285924 div.yiv1596285924photo-title a, #yiv1596285924 div.yiv1596285924photo-title a:active, #yiv1596285924 div.yiv1596285924photo-title a:hover, #yiv1596285924 div.yiv1596285924photo-title a:visited {text-decoration:none;}#yiv1596285924 div#yiv1596285924ygrp-mlmsg #yiv1596285924ygrp-msg p a span.yiv1596285924yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1596285924 .yiv1596285924green {color:#628c2a;}#yiv1596285924 .yiv1596285924MsoNormal {margin:0 0 0 0;}#yiv1596285924 o {font-size:0;}#yiv1596285924 #yiv1596285924photos div {float:left;width:72px;}#yiv1596285924 #yiv1596285924photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv1596285924 #yiv1596285924photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1596285924 #yiv1596285924reco-category {font-size:77%;}#yiv1596285924 #yiv1596285924reco-desc {font-size:77%;}#yiv1596285924 .yiv1596285924replbq {margin:4px;}#yiv1596285924 #yiv1596285924ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv1596285924 #yiv1596285924ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1596285924 #yiv1596285924ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1596285924 #yiv1596285924ygrp-mlmsg select, #yiv1596285924 input, #yiv1596285924 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv1596285924 #yiv1596285924ygrp-mlmsg pre, #yiv1596285924 code {font:115% monospace;}#yiv1596285924 #yiv1596285924ygrp-mlmsg * {line-height:1.22em;}#yiv1596285924 #yiv1596285924ygrp-mlmsg #yiv1596285924logo {padding-bottom:10px;}#yiv1596285924 #yiv1596285924ygrp-msg p a {font-family:Verdana;}#yiv1596285924 #yiv1596285924ygrp-msg p#yiv1596285924attach-count span {color:#1E66AE;font-weight:700;}#yiv1596285924 #yiv1596285924ygrp-reco #yiv1596285924reco-head {color:#ff7900;font-weight:700;}#yiv1596285924 #yiv1596285924ygrp-reco {margin-bottom:20px;padding:0px;}#yiv1596285924 #yiv1596285924ygrp-sponsor #yiv1596285924ov li a {font-size:130%;text-decoration:none;}#yiv1596285924 #yiv1596285924ygrp-sponsor #yiv1596285924ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv1596285924 #yiv1596285924ygrp-sponsor #yiv1596285924ov ul {margin:0;padding:0 0 0 8px;}#yiv1596285924 #yiv1596285924ygrp-text {font-family:Georgia;}#yiv1596285924 #yiv1596285924ygrp-text p {margin:0 0 1em 0;}#yiv1596285924 #yiv1596285924ygrp-text tt {font-size:120%;}#yiv1596285924 #yiv1596285924ygrp-vital ul li:last-child {border-right:none !important;}#yiv1596285924

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

2

Menampilakan 10 Data

Mon Dec 22, 2014 9:46 am (PST) . Posted by:

icat_omez@ymail.com

Selamat malam para master
Sampai malam saya belum bisa menemukan formula yang pas buat memangil data 10 sekaligus
Saya ingin memangil data di page 1 akan muncul 10 data sekaligus .
Semoga Para Mr.Excle Bisa Membantu Saya.
Berikut ini Saya Lampirkan File Pendukungnya
Terima Kasih


Good Night Mr

Reply to sender . Reply to group . Reply via Web Post . All Messages (1) . Top ^

3a

Re: Menampilakan 10 Data [1 Attachment]

Mon Dec 22, 2014 3:46 pm (PST) . Posted by:

"Hendrik Karnadi" hendrikkarnadi

Hai. Mr.X,
Sdh coba cari di di file milis?

Salam,
HK

Sent from Samsung Mobile

<div>-------- Original message --------</div><div>From: "icat_omez@ymail.com [belajar-excel]" <belajar-excel@yahoogroups.com> </div><div>Date:22/12/2014 22:51 (GMT+07:00) </div><div>To: belajar-excel@yahoogroups.com </div><div>Subject: [belajar-excel] Menampilakan 10 Data [1 Attachment] </div><div>
</div>Selamat malam para master

Sampai malam saya belum bisa menemukan formula yang pas buat memangil data 10 sekaligus

Saya ingin memangil data di page 1 akan muncul 10 data sekaligus .

Semoga Para Mr.Excle Bisa Membantu Saya.

Berikut ini Saya Lampirkan File Pendukungnya

Terima Kasih

Good Night Mr

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

3b

Re: Menampilakan 10 Data

Mon Dec 22, 2014 6:10 pm (PST) . Posted by:

"hendrik karnadi" hendrikkarnadi

Barangkali kedua file ini bisa menjadi rujukan.
Salam,HK
From: "Hendrik Karnadi hendrikkarnadi@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Tuesday, 23 December 2014, 6:47
Subject: Re: [belajar-excel] Menampilakan 10 Data

  Hai. Mr.X,Sdh coba cari di di file milis?
Salam,HK

Sent from Samsung Mobile

-------- Original message --------From: "icat_omez@ymail.com [belajar-excel]" Date:22/12/2014 22:51 (GMT+07:00) To: belajar-excel@yahoogroups.com Subject: [belajar-excel] Menampilakan 10 Data [1 Attachment]
  Selamat malam para masterSampai malam saya belum bisa menemukan formula yang pas buat memangil data 10 sekaligusSaya ingin memangil data di page 1 akan muncul 10 data sekaligus .Semoga Para Mr.Excle Bisa Membantu Saya.Berikut ini Saya Lampirkan File Pendukungnya Terima Kasih
Good Night Mr #yiv2268868294 #yiv2268868294 -- #yiv2268868294ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2268868294 #yiv2268868294ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2268868294 #yiv2268868294ygrp-mkp #yiv2268868294hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2268868294 #yiv2268868294ygrp-mkp #yiv2268868294ads {margin-bottom:10px;}#yiv2268868294 #yiv2268868294ygrp-mkp .yiv2268868294ad {padding:0 0;}#yiv2268868294 #yiv2268868294ygrp-mkp .yiv2268868294ad p {margin:0;}#yiv2268868294 #yiv2268868294ygrp-mkp .yiv2268868294ad a {color:#0000ff;text-decoration:none;}#yiv2268868294 #yiv2268868294ygrp-sponsor #yiv2268868294ygrp-lc {font-family:Arial;}#yiv2268868294 #yiv2268868294ygrp-sponsor #yiv2268868294ygrp-lc #yiv2268868294hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2268868294 #yiv2268868294ygrp-sponsor #yiv2268868294ygrp-lc .yiv2268868294ad {margin-bottom:10px;padding:0 0;}#yiv2268868294 #yiv2268868294actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2268868294 #yiv2268868294activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2268868294 #yiv2268868294activity span {font-weight:700;}#yiv2268868294 #yiv2268868294activity span:first-child {text-transform:uppercase;}#yiv2268868294 #yiv2268868294activity span a {color:#5085b6;text-decoration:none;}#yiv2268868294 #yiv2268868294activity span span {color:#ff7900;}#yiv2268868294 #yiv2268868294activity span .yiv2268868294underline {text-decoration:underline;}#yiv2268868294 .yiv2268868294attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2268868294 .yiv2268868294attach div a {text-decoration:none;}#yiv2268868294 .yiv2268868294attach img {border:none;padding-right:5px;}#yiv2268868294 .yiv2268868294attach label {display:block;margin-bottom:5px;}#yiv2268868294 .yiv2268868294attach label a {text-decoration:none;}#yiv2268868294 blockquote {margin:0 0 0 4px;}#yiv2268868294 .yiv2268868294bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2268868294 .yiv2268868294bold a {text-decoration:none;}#yiv2268868294 dd.yiv2268868294last p a {font-family:Verdana;font-weight:700;}#yiv2268868294 dd.yiv2268868294last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2268868294 dd.yiv2268868294last p span.yiv2268868294yshortcuts {margin-right:0;}#yiv2268868294 div.yiv2268868294attach-table div div a {text-decoration:none;}#yiv2268868294 div.yiv2268868294attach-table {width:400px;}#yiv2268868294 div.yiv2268868294file-title a, #yiv2268868294 div.yiv2268868294file-title a:active, #yiv2268868294 div.yiv2268868294file-title a:hover, #yiv2268868294 div.yiv2268868294file-title a:visited {text-decoration:none;}#yiv2268868294 div.yiv2268868294photo-title a, #yiv2268868294 div.yiv2268868294photo-title a:active, #yiv2268868294 div.yiv2268868294photo-title a:hover, #yiv2268868294 div.yiv2268868294photo-title a:visited {text-decoration:none;}#yiv2268868294 div#yiv2268868294ygrp-mlmsg #yiv2268868294ygrp-msg p a span.yiv2268868294yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2268868294 .yiv2268868294green {color:#628c2a;}#yiv2268868294 .yiv2268868294MsoNormal {margin:0 0 0 0;}#yiv2268868294 o {font-size:0;}#yiv2268868294 #yiv2268868294photos div {float:left;width:72px;}#yiv2268868294 #yiv2268868294photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv2268868294 #yiv2268868294photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2268868294 #yiv2268868294reco-category {font-size:77%;}#yiv2268868294 #yiv2268868294reco-desc {font-size:77%;}#yiv2268868294 .yiv2268868294replbq {margin:4px;}#yiv2268868294 #yiv2268868294ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2268868294 #yiv2268868294ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2268868294 #yiv2268868294ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2268868294 #yiv2268868294ygrp-mlmsg select, #yiv2268868294 input, #yiv2268868294 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2268868294 #yiv2268868294ygrp-mlmsg pre, #yiv2268868294 code {font:115% monospace;}#yiv2268868294 #yiv2268868294ygrp-mlmsg * {line-height:1.22em;}#yiv2268868294 #yiv2268868294ygrp-mlmsg #yiv2268868294logo {padding-bottom:10px;}#yiv2268868294 #yiv2268868294ygrp-msg p a {font-family:Verdana;}#yiv2268868294 #yiv2268868294ygrp-msg p#yiv2268868294attach-count span {color:#1E66AE;font-weight:700;}#yiv2268868294 #yiv2268868294ygrp-reco #yiv2268868294reco-head {color:#ff7900;font-weight:700;}#yiv2268868294 #yiv2268868294ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2268868294 #yiv2268868294ygrp-sponsor #yiv2268868294ov li a {font-size:130%;text-decoration:none;}#yiv2268868294 #yiv2268868294ygrp-sponsor #yiv2268868294ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2268868294 #yiv2268868294ygrp-sponsor #yiv2268868294ov ul {margin:0;padding:0 0 0 8px;}#yiv2268868294 #yiv2268868294ygrp-text {font-family:Georgia;}#yiv2268868294 #yiv2268868294ygrp-text p {margin:0 0 1em 0;}#yiv2268868294 #yiv2268868294ygrp-text tt {font-size:120%;}#yiv2268868294 #yiv2268868294ygrp-vital ul li:last-child {border-right:none !important;}#yiv2268868294

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

3c

Bls: [belajar-excel] Menampilakan 10 Data

Tue Dec 23, 2014 12:02 am (PST) . Posted by:

"Icat Omez" icat_omez@ymail.com

Belum .Bisa Minta Link .a yang membahas masalah itu Mr.HK
Terima Kasih

Pada Selasa, 23 Desember 2014 6:46, "Hendrik Karnadi hendrikkarnadi@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Hai. Mr.X,Sdh coba cari di di file milis?
Salam,HK

Sent from Samsung Mobile

-------- Original message --------From: "icat_omez@ymail.com [belajar-excel]" Date:22/12/2014 22:51 (GMT+07:00) To: belajar-excel@yahoogroups.com Subject: [belajar-excel] Menampilakan 10 Data [1 Attachment]
  Selamat malam para masterSampai malam saya belum bisa menemukan formula yang pas buat memangil data 10 sekaligusSaya ingin memangil data di page 1 akan muncul 10 data sekaligus .Semoga Para Mr.Excle Bisa Membantu Saya.Berikut ini Saya Lampirkan File Pendukungnya Terima Kasih
Good Night Mr #yiv0461029750 #yiv0461029750 -- #yiv0461029750ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0461029750 #yiv0461029750ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0461029750 #yiv0461029750ygrp-mkp #yiv0461029750hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0461029750 #yiv0461029750ygrp-mkp #yiv0461029750ads {margin-bottom:10px;}#yiv0461029750 #yiv0461029750ygrp-mkp .yiv0461029750ad {padding:0 0;}#yiv0461029750 #yiv0461029750ygrp-mkp .yiv0461029750ad p {margin:0;}#yiv0461029750 #yiv0461029750ygrp-mkp .yiv0461029750ad a {color:#0000ff;text-decoration:none;}#yiv0461029750 #yiv0461029750ygrp-sponsor #yiv0461029750ygrp-lc {font-family:Arial;}#yiv0461029750 #yiv0461029750ygrp-sponsor #yiv0461029750ygrp-lc #yiv0461029750hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0461029750 #yiv0461029750ygrp-sponsor #yiv0461029750ygrp-lc .yiv0461029750ad {margin-bottom:10px;padding:0 0;}#yiv0461029750 #yiv0461029750actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0461029750 #yiv0461029750activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0461029750 #yiv0461029750activity span {font-weight:700;}#yiv0461029750 #yiv0461029750activity span:first-child {text-transform:uppercase;}#yiv0461029750 #yiv0461029750activity span a {color:#5085b6;text-decoration:none;}#yiv0461029750 #yiv0461029750activity span span {color:#ff7900;}#yiv0461029750 #yiv0461029750activity span .yiv0461029750underline {text-decoration:underline;}#yiv0461029750 .yiv0461029750attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0461029750 .yiv0461029750attach div a {text-decoration:none;}#yiv0461029750 .yiv0461029750attach img {border:none;padding-right:5px;}#yiv0461029750 .yiv0461029750attach label {display:block;margin-bottom:5px;}#yiv0461029750 .yiv0461029750attach label a {text-decoration:none;}#yiv0461029750 blockquote {margin:0 0 0 4px;}#yiv0461029750 .yiv0461029750bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0461029750 .yiv0461029750bold a {text-decoration:none;}#yiv0461029750 dd.yiv0461029750last p a {font-family:Verdana;font-weight:700;}#yiv0461029750 dd.yiv0461029750last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0461029750 dd.yiv0461029750last p span.yiv0461029750yshortcuts {margin-right:0;}#yiv0461029750 div.yiv0461029750attach-table div div a {text-decoration:none;}#yiv0461029750 div.yiv0461029750attach-table {width:400px;}#yiv0461029750 div.yiv0461029750file-title a, #yiv0461029750 div.yiv0461029750file-title a:active, #yiv0461029750 div.yiv0461029750file-title a:hover, #yiv0461029750 div.yiv0461029750file-title a:visited {text-decoration:none;}#yiv0461029750 div.yiv0461029750photo-title a, #yiv0461029750 div.yiv0461029750photo-title a:active, #yiv0461029750 div.yiv0461029750photo-title a:hover, #yiv0461029750 div.yiv0461029750photo-title a:visited {text-decoration:none;}#yiv0461029750 div#yiv0461029750ygrp-mlmsg #yiv0461029750ygrp-msg p a span.yiv0461029750yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0461029750 .yiv0461029750green {color:#628c2a;}#yiv0461029750 .yiv0461029750MsoNormal {margin:0 0 0 0;}#yiv0461029750 o {font-size:0;}#yiv0461029750 #yiv0461029750photos div {float:left;width:72px;}#yiv0461029750 #yiv0461029750photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv0461029750 #yiv0461029750photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0461029750 #yiv0461029750reco-category {font-size:77%;}#yiv0461029750 #yiv0461029750reco-desc {font-size:77%;}#yiv0461029750 .yiv0461029750replbq {margin:4px;}#yiv0461029750 #yiv0461029750ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0461029750 #yiv0461029750ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0461029750 #yiv0461029750ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0461029750 #yiv0461029750ygrp-mlmsg select, #yiv0461029750 input, #yiv0461029750 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0461029750 #yiv0461029750ygrp-mlmsg pre, #yiv0461029750 code {font:115% monospace;}#yiv0461029750 #yiv0461029750ygrp-mlmsg * {line-height:1.22em;}#yiv0461029750 #yiv0461029750ygrp-mlmsg #yiv0461029750logo {padding-bottom:10px;}#yiv0461029750 #yiv0461029750ygrp-msg p a {font-family:Verdana;}#yiv0461029750 #yiv0461029750ygrp-msg p#yiv0461029750attach-count span {color:#1E66AE;font-weight:700;}#yiv0461029750 #yiv0461029750ygrp-reco #yiv0461029750reco-head {color:#ff7900;font-weight:700;}#yiv0461029750 #yiv0461029750ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0461029750 #yiv0461029750ygrp-sponsor #yiv0461029750ov li a {font-size:130%;text-decoration:none;}#yiv0461029750 #yiv0461029750ygrp-sponsor #yiv0461029750ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0461029750 #yiv0461029750ygrp-sponsor #yiv0461029750ov ul {margin:0;padding:0 0 0 8px;}#yiv0461029750 #yiv0461029750ygrp-text {font-family:Georgia;}#yiv0461029750 #yiv0461029750ygrp-text p {margin:0 0 1em 0;}#yiv0461029750 #yiv0461029750ygrp-text tt {font-size:120%;}#yiv0461029750 #yiv0461029750ygrp-vital ul li:last-child {border-right:none !important;}#yiv0461029750

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

3d

Bls: [belajar-excel] Menampilakan 10 Data

Tue Dec 23, 2014 12:02 am (PST) . Posted by:

"Icat Omez" icat_omez@ymail.com

Okey Terima kasih saya coba dulu Mr.HK


Pada Selasa, 23 Desember 2014 9:12, "hendrik karnadi hendrikkarnadi@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Barangkali kedua file ini bisa menjadi rujukan.
Salam,HK
From: "Hendrik Karnadi hendrikkarnadi@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Tuesday, 23 December 2014, 6:47
Subject: Re: [belajar-excel] Menampilakan 10 Data

  Hai. Mr.X,Sdh coba cari di di file milis?
Salam,HK

Sent from Samsung Mobile

-------- Original message --------From: "icat_omez@ymail.com [belajar-excel]" Date:22/12/2014 22:51 (GMT+07:00) To: belajar-excel@yahoogroups.com Subject: [belajar-excel] Menampilakan 10 Data [1 Attachment]
  Selamat malam para masterSampai malam saya belum bisa menemukan formula yang pas buat memangil data 10 sekaligusSaya ingin memangil data di page 1 akan muncul 10 data sekaligus .Semoga Para Mr.Excle Bisa Membantu Saya.Berikut ini Saya Lampirkan File Pendukungnya Terima Kasih
Good Night Mr

#yiv5508925765 #yiv5508925765 -- #yiv5508925765ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5508925765 #yiv5508925765ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5508925765 #yiv5508925765ygrp-mkp #yiv5508925765hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5508925765 #yiv5508925765ygrp-mkp #yiv5508925765ads {margin-bottom:10px;}#yiv5508925765 #yiv5508925765ygrp-mkp .yiv5508925765ad {padding:0 0;}#yiv5508925765 #yiv5508925765ygrp-mkp .yiv5508925765ad p {margin:0;}#yiv5508925765 #yiv5508925765ygrp-mkp .yiv5508925765ad a {color:#0000ff;text-decoration:none;}#yiv5508925765 #yiv5508925765ygrp-sponsor #yiv5508925765ygrp-lc {font-family:Arial;}#yiv5508925765 #yiv5508925765ygrp-sponsor #yiv5508925765ygrp-lc #yiv5508925765hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5508925765 #yiv5508925765ygrp-sponsor #yiv5508925765ygrp-lc .yiv5508925765ad {margin-bottom:10px;padding:0 0;}#yiv5508925765 #yiv5508925765actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5508925765 #yiv5508925765activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5508925765 #yiv5508925765activity span {font-weight:700;}#yiv5508925765 #yiv5508925765activity span:first-child {text-transform:uppercase;}#yiv5508925765 #yiv5508925765activity span a {color:#5085b6;text-decoration:none;}#yiv5508925765 #yiv5508925765activity span span {color:#ff7900;}#yiv5508925765 #yiv5508925765activity span .yiv5508925765underline {text-decoration:underline;}#yiv5508925765 .yiv5508925765attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv5508925765 .yiv5508925765attach div a {text-decoration:none;}#yiv5508925765 .yiv5508925765attach img {border:none;padding-right:5px;}#yiv5508925765 .yiv5508925765attach label {display:block;margin-bottom:5px;}#yiv5508925765 .yiv5508925765attach label a {text-decoration:none;}#yiv5508925765 blockquote {margin:0 0 0 4px;}#yiv5508925765 .yiv5508925765bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv5508925765 .yiv5508925765bold a {text-decoration:none;}#yiv5508925765 dd.yiv5508925765last p a {font-family:Verdana;font-weight:700;}#yiv5508925765 dd.yiv5508925765last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5508925765 dd.yiv5508925765last p span.yiv5508925765yshortcuts {margin-right:0;}#yiv5508925765 div.yiv5508925765attach-table div div a {text-decoration:none;}#yiv5508925765 div.yiv5508925765attach-table {width:400px;}#yiv5508925765 div.yiv5508925765file-title a, #yiv5508925765 div.yiv5508925765file-title a:active, #yiv5508925765 div.yiv5508925765file-title a:hover, #yiv5508925765 div.yiv5508925765file-title a:visited {text-decoration:none;}#yiv5508925765 div.yiv5508925765photo-title a, #yiv5508925765 div.yiv5508925765photo-title a:active, #yiv5508925765 div.yiv5508925765photo-title a:hover, #yiv5508925765 div.yiv5508925765photo-title a:visited {text-decoration:none;}#yiv5508925765 div#yiv5508925765ygrp-mlmsg #yiv5508925765ygrp-msg p a span.yiv5508925765yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5508925765 .yiv5508925765green {color:#628c2a;}#yiv5508925765 .yiv5508925765MsoNormal {margin:0 0 0 0;}#yiv5508925765 o {font-size:0;}#yiv5508925765 #yiv5508925765photos div {float:left;width:72px;}#yiv5508925765 #yiv5508925765photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv5508925765 #yiv5508925765photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5508925765 #yiv5508925765reco-category {font-size:77%;}#yiv5508925765 #yiv5508925765reco-desc {font-size:77%;}#yiv5508925765 .yiv5508925765replbq {margin:4px;}#yiv5508925765 #yiv5508925765ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv5508925765 #yiv5508925765ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5508925765 #yiv5508925765ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5508925765 #yiv5508925765ygrp-mlmsg select, #yiv5508925765 input, #yiv5508925765 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv5508925765 #yiv5508925765ygrp-mlmsg pre, #yiv5508925765 code {font:115% monospace;}#yiv5508925765 #yiv5508925765ygrp-mlmsg * {line-height:1.22em;}#yiv5508925765 #yiv5508925765ygrp-mlmsg #yiv5508925765logo {padding-bottom:10px;}#yiv5508925765 #yiv5508925765ygrp-msg p a {font-family:Verdana;}#yiv5508925765 #yiv5508925765ygrp-msg p#yiv5508925765attach-count span {color:#1E66AE;font-weight:700;}#yiv5508925765 #yiv5508925765ygrp-reco #yiv5508925765reco-head {color:#ff7900;font-weight:700;}#yiv5508925765 #yiv5508925765ygrp-reco {margin-bottom:20px;padding:0px;}#yiv5508925765 #yiv5508925765ygrp-sponsor #yiv5508925765ov li a {font-size:130%;text-decoration:none;}#yiv5508925765 #yiv5508925765ygrp-sponsor #yiv5508925765ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv5508925765 #yiv5508925765ygrp-sponsor #yiv5508925765ov ul {margin:0;padding:0 0 0 8px;}#yiv5508925765 #yiv5508925765ygrp-text {font-family:Georgia;}#yiv5508925765 #yiv5508925765ygrp-text p {margin:0 0 1em 0;}#yiv5508925765 #yiv5508925765ygrp-text tt {font-size:120%;}#yiv5508925765 #yiv5508925765ygrp-vital ul li:last-child {border-right:none !important;}#yiv5508925765

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

4

Vlookup problems

Mon Dec 22, 2014 6:33 pm (PST) . Posted by:

"hendrik karnadi" hendrikkarnadi

Dear Be-Excelers,Dalam menggunakan fungsi Vlookup sering kita menjumpai masalah.Kutipan dari internet ini mungkin bisa sedikit membantu.
Salam,HK

Reply to sender . Reply to group . Reply via Web Post . All Messages (1) . Top ^

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

Visit Your Group

• New Members 5

• Privacy • Unsubscribe • Terms of Use