Jumat, 24 April 2015

[belajar-excel] Digest Number 3399

6 Messages

Digest #3399

Messages

Thu Apr 23, 2015 5:21 pm (PDT) . Posted by:

"heru mulyono"

Terimakasih Mr Kid
Jawaban sesuai keinginan
diluar dugaan,....ternyata rumusnya sangat simpel...
sekali lagi terimakasih

Pada 22 April 2015 18.33, 'Mr. Kid' mr.nmkid@gmail.com [belajar-excel] <
belajar-excel@yahoogroups.com> menulis:

>
>
> Hai Heru,
>
> Berdasar bunyi :
>
>> Pada kolom "Hasil", yang diingnkan adalah menampillkan nama dari urutan
>> paling kiri berdasarkan sel G2
>>
>
> diasumsikan :
> 1. inputan di cell G2 berupa angka dari kolom No (ada di kolom B mestinya)
> 2. header data di baris 5, berarti data di range C6:E10
> 3. ada angka-angka 1 sampai 5 sebelum area hasil paling kanan, tampaknya
> kolom ini adalah kolom i (berarti mulai i6)
> 4. range hasil :
> - range G6
> - range K6:K10 (tampaknya ada kolom kosong di sebelum dan sesudah
> nilai-nilai 1 sampai 5 yang dekat area hasil)
> 5. hasil menampilkan teks tidak kosong pertama yang ada di baris terkait
> pada area data c6:e10
>
> Formula di range hasil G6 : (berdasar nilai G2)
> =Index( c$6:e$10 , g2 , Match( "?*" , Index( c$6:e$10 , g2 , 0 ) , 0 ) )
>
> Formula di range hasil K6 : (pakai formula G6 tapi disesuaikan rujukan G2
> ke kolom i, yaitu i6)
> =Index( c$6:e$10 , i6 , Match( "?*" , Index( c$6:e$10 , i6 , 0 ) , 0 ) )
>
> lalu copy formula K6 ke bawah sampai K10
>
> *** Jika regional setting komputer setempat adalah Indonesian, ganti
> karakter koma dalam formula menjadi titik koma
> *** Syarat dan ketentuan berlaku
>
> hmmm.... moga-moga ndak kliru imajinasinya
>
> Wassalam,
> Kid
>
>
>

>
>
>
> 2015-04-22 12:02 GMT+10:00 heru mulyono hmulyono24@gmail.com
> [belajar-excel] <belajar-excel@yahoogroups.com>:
>
>>
>>
>> Yth, Master Excel
>> Mohon Bantuan permasalahan saya,
>>
>> file terlampir
>> Terimakasih
>>
>>
>
>

Thu Apr 23, 2015 6:10 pm (PDT) . Posted by:

"prazt" praztmath

Suwun atas sarannya Mr.Kid, ane pake excel 2007, knnapa kl pake ms Calendaer 12 ga bisa ya, bisanya pakai yg 11..sekali lagi makasih.

From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: 22 April 2015 7:35
To: BeExcel
Subject: Re: [belajar-excel] menampilkan list tanggal pada cell excel 2007

Wa'alaikumussalam wr wb

Tambahkan referensi library ke MSCAL.ocx di VBE dengan menu Tools -> references -> cari MS Calendar blabla -> centang OK

Wassalamu'alaikum wr wb

Kid

2015-04-18 12:48 GMT+10:00 'prazt' praztmath@gmail.com [belajar-excel] <belajar-excel@yahoogroups.com>:

Assalamu'alikum..

Dear rekan semua..mohon bantuannya gimana script yang benar untuk menampilkan list tanggal (kalender) pada cell excel 2007 seperti yang sudah dibahas oleh mr.HK pada http://milis-belajar-excel.1048464.n5.nabble.com/images/icon_attachment.gifCalendar Control 2010.xlsm (33K) Download Attachment <http://milis-belajar-excel.1048464.n5.nabble.com/attachment/5719946/0/Calendar%20Control%202010.xlsm> ,saya coba copy paste script tersebut di excel 2007 kok error alias debug ya padahal kalau saya buka langsung hasil downlodnya bisa jalan. Mohon pencerahannya para suhu. Terimakasih sebelumnya..

Wassalamu'alaikum..

Thu Apr 23, 2015 10:17 pm (PDT) . Posted by:

"Zerlinda Seismica" seismica

Assalamualaikum wrwb
Mohon bantuan lagi...Adakah formula di conditional formatting untuk menampilkan warna sesuai dengan kriteria tertentu seperti terlampir...
semoga para master diberi kemudahan aamiin...
WassalamSeimica

Thu Apr 23, 2015 10:50 pm (PDT) . Posted by:

"uharyanto" uharyanto@ymail.com

Coba ini : =IF(COUNTA($A2:$D2)>0,1,0)

tks

Salam,
uharyanto

On 24/04/2015 9:34 AM, Zerlinda Seismica seismica@yahoo.com
[belajar-excel] wrote:
> Assalamualaikum wrwb
>
> Mohon bantuan lagi...
> Adakah formula di conditional formatting untuk menampilkan warna
> sesuai dengan kriteria tertentu seperti terlampir...
> semoga para master diberi kemudahan aamiin...
>
> Wassalam
> Seimica
>
>

Thu Apr 23, 2015 11:59 pm (PDT) . Posted by:

"Andrie -" sioean2

Use a formula to determine which cells to format :=COUNTA($A2:$D2)

format cells - fill - red
From: "Zerlinda Seismica seismica@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Friday, April 24, 2015 9:34 AM
Subject: [belajar-excel] Formula Menampilkan Warna dengan Conditional Formatting [1 Attachment]

  Assalamualaikum wrwb
Mohon bantuan lagi...Adakah formula di conditional formatting untuk menampilkan warna sesuai dengan kriteria tertentu seperti terlampir...
semoga para master diberi kemudahan aamiin...
WassalamSeimica

#yiv5921679553 #yiv5921679553 -- #yiv5921679553ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5921679553 #yiv5921679553ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5921679553 #yiv5921679553ygrp-mkp #yiv5921679553hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5921679553 #yiv5921679553ygrp-mkp #yiv5921679553ads {margin-bottom:10px;}#yiv5921679553 #yiv5921679553ygrp-mkp .yiv5921679553ad {padding:0 0;}#yiv5921679553 #yiv5921679553ygrp-mkp .yiv5921679553ad p {margin:0;}#yiv5921679553 #yiv5921679553ygrp-mkp .yiv5921679553ad a {color:#0000ff;text-decoration:none;}#yiv5921679553 #yiv5921679553ygrp-sponsor #yiv5921679553ygrp-lc {font-family:Arial;}#yiv5921679553 #yiv5921679553ygrp-sponsor #yiv5921679553ygrp-lc #yiv5921679553hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5921679553 #yiv5921679553ygrp-sponsor #yiv5921679553ygrp-lc .yiv5921679553ad {margin-bottom:10px;padding:0 0;}#yiv5921679553 #yiv5921679553actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5921679553 #yiv5921679553activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5921679553 #yiv5921679553activity span {font-weight:700;}#yiv5921679553 #yiv5921679553activity span:first-child {text-transform:uppercase;}#yiv5921679553 #yiv5921679553activity span a {color:#5085b6;text-decoration:none;}#yiv5921679553 #yiv5921679553activity span span {color:#ff7900;}#yiv5921679553 #yiv5921679553activity span .yiv5921679553underline {text-decoration:underline;}#yiv5921679553 .yiv5921679553attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv5921679553 .yiv5921679553attach div a {text-decoration:none;}#yiv5921679553 .yiv5921679553attach img {border:none;padding-right:5px;}#yiv5921679553 .yiv5921679553attach label {display:block;margin-bottom:5px;}#yiv5921679553 .yiv5921679553attach label a {text-decoration:none;}#yiv5921679553 blockquote {margin:0 0 0 4px;}#yiv5921679553 .yiv5921679553bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv5921679553 .yiv5921679553bold a {text-decoration:none;}#yiv5921679553 dd.yiv5921679553last p a {font-family:Verdana;font-weight:700;}#yiv5921679553 dd.yiv5921679553last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5921679553 dd.yiv5921679553last p span.yiv5921679553yshortcuts {margin-right:0;}#yiv5921679553 div.yiv5921679553attach-table div div a {text-decoration:none;}#yiv5921679553 div.yiv5921679553attach-table {width:400px;}#yiv5921679553 div.yiv5921679553file-title a, #yiv5921679553 div.yiv5921679553file-title a:active, #yiv5921679553 div.yiv5921679553file-title a:hover, #yiv5921679553 div.yiv5921679553file-title a:visited {text-decoration:none;}#yiv5921679553 div.yiv5921679553photo-title a, #yiv5921679553 div.yiv5921679553photo-title a:active, #yiv5921679553 div.yiv5921679553photo-title a:hover, #yiv5921679553 div.yiv5921679553photo-title a:visited {text-decoration:none;}#yiv5921679553 div#yiv5921679553ygrp-mlmsg #yiv5921679553ygrp-msg p a span.yiv5921679553yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5921679553 .yiv5921679553green {color:#628c2a;}#yiv5921679553 .yiv5921679553MsoNormal {margin:0 0 0 0;}#yiv5921679553 o {font-size:0;}#yiv5921679553 #yiv5921679553photos div {float:left;width:72px;}#yiv5921679553 #yiv5921679553photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv5921679553 #yiv5921679553photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5921679553 #yiv5921679553reco-category {font-size:77%;}#yiv5921679553 #yiv5921679553reco-desc {font-size:77%;}#yiv5921679553 .yiv5921679553replbq {margin:4px;}#yiv5921679553 #yiv5921679553ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv5921679553 #yiv5921679553ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5921679553 #yiv5921679553ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5921679553 #yiv5921679553ygrp-mlmsg select, #yiv5921679553 input, #yiv5921679553 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv5921679553 #yiv5921679553ygrp-mlmsg pre, #yiv5921679553 code {font:115% monospace;}#yiv5921679553 #yiv5921679553ygrp-mlmsg * {line-height:1.22em;}#yiv5921679553 #yiv5921679553ygrp-mlmsg #yiv5921679553logo {padding-bottom:10px;}#yiv5921679553 #yiv5921679553ygrp-msg p a {font-family:Verdana;}#yiv5921679553 #yiv5921679553ygrp-msg p#yiv5921679553attach-count span {color:#1E66AE;font-weight:700;}#yiv5921679553 #yiv5921679553ygrp-reco #yiv5921679553reco-head {color:#ff7900;font-weight:700;}#yiv5921679553 #yiv5921679553ygrp-reco {margin-bottom:20px;padding:0px;}#yiv5921679553 #yiv5921679553ygrp-sponsor #yiv5921679553ov li a {font-size:130%;text-decoration:none;}#yiv5921679553 #yiv5921679553ygrp-sponsor #yiv5921679553ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv5921679553 #yiv5921679553ygrp-sponsor #yiv5921679553ov ul {margin:0;padding:0 0 0 8px;}#yiv5921679553 #yiv5921679553ygrp-text {font-family:Georgia;}#yiv5921679553 #yiv5921679553ygrp-text p {margin:0 0 1em 0;}#yiv5921679553 #yiv5921679553ygrp-text tt {font-size:120%;}#yiv5921679553 #yiv5921679553ygrp-vital ul li:last-child {border-right:none !important;}#yiv5921679553

Thu Apr 23, 2015 11:59 pm (PDT) . Posted by:

"Andrie -" sioean2

Jika yang mau dieksekusi hanya pada huruf "A" saja dalam satu baris=COUNTIF($A2:$D2,"A")

From: "Zerlinda Seismica seismica@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Friday, April 24, 2015 9:34 AM
Subject: [belajar-excel] Formula Menampilkan Warna dengan Conditional Formatting [1 Attachment]

  Assalamualaikum wrwb
Mohon bantuan lagi...Adakah formula di conditional formatting untuk menampilkan warna sesuai dengan kriteria tertentu seperti terlampir...
semoga para master diberi kemudahan aamiin...
WassalamSeimica

#yiv5921679553 #yiv5921679553 -- #yiv5921679553ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5921679553 #yiv5921679553ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5921679553 #yiv5921679553ygrp-mkp #yiv5921679553hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5921679553 #yiv5921679553ygrp-mkp #yiv5921679553ads {margin-bottom:10px;}#yiv5921679553 #yiv5921679553ygrp-mkp .yiv5921679553ad {padding:0 0;}#yiv5921679553 #yiv5921679553ygrp-mkp .yiv5921679553ad p {margin:0;}#yiv5921679553 #yiv5921679553ygrp-mkp .yiv5921679553ad a {color:#0000ff;text-decoration:none;}#yiv5921679553 #yiv5921679553ygrp-sponsor #yiv5921679553ygrp-lc {font-family:Arial;}#yiv5921679553 #yiv5921679553ygrp-sponsor #yiv5921679553ygrp-lc #yiv5921679553hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5921679553 #yiv5921679553ygrp-sponsor #yiv5921679553ygrp-lc .yiv5921679553ad {margin-bottom:10px;padding:0 0;}#yiv5921679553 #yiv5921679553actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5921679553 #yiv5921679553activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5921679553 #yiv5921679553activity span {font-weight:700;}#yiv5921679553 #yiv5921679553activity span:first-child {text-transform:uppercase;}#yiv5921679553 #yiv5921679553activity span a {color:#5085b6;text-decoration:none;}#yiv5921679553 #yiv5921679553activity span span {color:#ff7900;}#yiv5921679553 #yiv5921679553activity span .yiv5921679553underline {text-decoration:underline;}#yiv5921679553 .yiv5921679553attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv5921679553 .yiv5921679553attach div a {text-decoration:none;}#yiv5921679553 .yiv5921679553attach img {border:none;padding-right:5px;}#yiv5921679553 .yiv5921679553attach label {display:block;margin-bottom:5px;}#yiv5921679553 .yiv5921679553attach label a {text-decoration:none;}#yiv5921679553 blockquote {margin:0 0 0 4px;}#yiv5921679553 .yiv5921679553bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv5921679553 .yiv5921679553bold a {text-decoration:none;}#yiv5921679553 dd.yiv5921679553last p a {font-family:Verdana;font-weight:700;}#yiv5921679553 dd.yiv5921679553last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5921679553 dd.yiv5921679553last p span.yiv5921679553yshortcuts {margin-right:0;}#yiv5921679553 div.yiv5921679553attach-table div div a {text-decoration:none;}#yiv5921679553 div.yiv5921679553attach-table {width:400px;}#yiv5921679553 div.yiv5921679553file-title a, #yiv5921679553 div.yiv5921679553file-title a:active, #yiv5921679553 div.yiv5921679553file-title a:hover, #yiv5921679553 div.yiv5921679553file-title a:visited {text-decoration:none;}#yiv5921679553 div.yiv5921679553photo-title a, #yiv5921679553 div.yiv5921679553photo-title a:active, #yiv5921679553 div.yiv5921679553photo-title a:hover, #yiv5921679553 div.yiv5921679553photo-title a:visited {text-decoration:none;}#yiv5921679553 div#yiv5921679553ygrp-mlmsg #yiv5921679553ygrp-msg p a span.yiv5921679553yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5921679553 .yiv5921679553green {color:#628c2a;}#yiv5921679553 .yiv5921679553MsoNormal {margin:0 0 0 0;}#yiv5921679553 o {font-size:0;}#yiv5921679553 #yiv5921679553photos div {float:left;width:72px;}#yiv5921679553 #yiv5921679553photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv5921679553 #yiv5921679553photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5921679553 #yiv5921679553reco-category {font-size:77%;}#yiv5921679553 #yiv5921679553reco-desc {font-size:77%;}#yiv5921679553 .yiv5921679553replbq {margin:4px;}#yiv5921679553 #yiv5921679553ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv5921679553 #yiv5921679553ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5921679553 #yiv5921679553ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5921679553 #yiv5921679553ygrp-mlmsg select, #yiv5921679553 input, #yiv5921679553 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv5921679553 #yiv5921679553ygrp-mlmsg pre, #yiv5921679553 code {font:115% monospace;}#yiv5921679553 #yiv5921679553ygrp-mlmsg * {line-height:1.22em;}#yiv5921679553 #yiv5921679553ygrp-mlmsg #yiv5921679553logo {padding-bottom:10px;}#yiv5921679553 #yiv5921679553ygrp-msg p a {font-family:Verdana;}#yiv5921679553 #yiv5921679553ygrp-msg p#yiv5921679553attach-count span {color:#1E66AE;font-weight:700;}#yiv5921679553 #yiv5921679553ygrp-reco #yiv5921679553reco-head {color:#ff7900;font-weight:700;}#yiv5921679553 #yiv5921679553ygrp-reco {margin-bottom:20px;padding:0px;}#yiv5921679553 #yiv5921679553ygrp-sponsor #yiv5921679553ov li a {font-size:130%;text-decoration:none;}#yiv5921679553 #yiv5921679553ygrp-sponsor #yiv5921679553ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv5921679553 #yiv5921679553ygrp-sponsor #yiv5921679553ov ul {margin:0;padding:0 0 0 8px;}#yiv5921679553 #yiv5921679553ygrp-text {font-family:Georgia;}#yiv5921679553 #yiv5921679553ygrp-text p {margin:0 0 1em 0;}#yiv5921679553 #yiv5921679553ygrp-text tt {font-size:120%;}#yiv5921679553 #yiv5921679553ygrp-vital ul li:last-child {border-right:none !important;}#yiv5921679553

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

Posting Komentar