Sipp...Makasih semuanya....two thumb for mr kid and Dede Master..
"Arigatou gozaimasu"
Luddy Subiyandoko
Pada Rabu, 4 Maret 2015 13:18, "'Mr. Kid' [email protected]
[belajar-excel]" <[email protected]> menulis:
Pinjem formulanya om DD, yang bunyinya :
=IF(MIN(B3:C5)=0;MIN(B3:C5)+1;MIN(B3:C5))
Pak Lubby,
Coba array formula : (tulis formula ini di cell hasil)
=min( IF(B3:C5<>0,B3:C5) )
lalu tekan CTRL SHIFT ENTER bersamaan
*** jika regional setting komputer setempat adalah Indonesian, maka ganti
karakter koma menjadi titik koma
Coretan tentang array formula bisa dilihat disini.
Wassalam,
Kid.
On Wed, Mar 4, 2015 at 5:08 PM, Dede [email protected]
[belajar-excel] <[email protected]> wrote:
DearMr Luddy, Gimanakalau coba formula ini
:=IF(MIN(B3:C5)=0;MIN(B3:C5)+1;MIN(B3:C5)) Slam,DD From: luddy
[email protected]
[belajar-excel][mailto:[email protected]]
Sent: 04 Maret 2015 08:30
To: [email protected]
Subject: [belajar-excel] Min mengabaikan nilai "0" Dear Master excelMOhon
bantuannya ya...mencari nilai min tapi mengabaikan nilai"0"Saya pernah liat
postingan di xl mania kl gak salah, akan tetapifile attachment tidak ada
sehinggasaya agak bingung mohon pencerahannya "Arigatou gozaimasu"
Luddy Subiyandoko 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.
#yiv3163671484 #yiv3163671484 -- #yiv3163671484ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3163671484
#yiv3163671484ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3163671484
#yiv3163671484ygrp-mkp #yiv3163671484hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv3163671484 #yiv3163671484ygrp-mkp #yiv3163671484ads
{margin-bottom:10px;}#yiv3163671484 #yiv3163671484ygrp-mkp .yiv3163671484ad
{padding:0 0;}#yiv3163671484 #yiv3163671484ygrp-mkp .yiv3163671484ad p
{margin:0;}#yiv3163671484 #yiv3163671484ygrp-mkp .yiv3163671484ad a
{color:#0000ff;text-decoration:none;}#yiv3163671484 #yiv3163671484ygrp-sponsor
#yiv3163671484ygrp-lc {font-family:Arial;}#yiv3163671484
#yiv3163671484ygrp-sponsor #yiv3163671484ygrp-lc #yiv3163671484hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3163671484
#yiv3163671484ygrp-sponsor #yiv3163671484ygrp-lc .yiv3163671484ad
{margin-bottom:10px;padding:0 0;}#yiv3163671484 #yiv3163671484actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3163671484
#yiv3163671484activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3163671484
#yiv3163671484activity span {font-weight:700;}#yiv3163671484
#yiv3163671484activity span:first-child
{text-transform:uppercase;}#yiv3163671484 #yiv3163671484activity span a
{color:#5085b6;text-decoration:none;}#yiv3163671484 #yiv3163671484activity span
span {color:#ff7900;}#yiv3163671484 #yiv3163671484activity span
.yiv3163671484underline {text-decoration:underline;}#yiv3163671484
.yiv3163671484attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv3163671484 .yiv3163671484attach div a
{text-decoration:none;}#yiv3163671484 .yiv3163671484attach img
{border:none;padding-right:5px;}#yiv3163671484 .yiv3163671484attach label
{display:block;margin-bottom:5px;}#yiv3163671484 .yiv3163671484attach label a
{text-decoration:none;}#yiv3163671484 blockquote {margin:0 0 0
4px;}#yiv3163671484 .yiv3163671484bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv3163671484
.yiv3163671484bold a {text-decoration:none;}#yiv3163671484 dd.yiv3163671484last
p a {font-family:Verdana;font-weight:700;}#yiv3163671484 dd.yiv3163671484last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3163671484
dd.yiv3163671484last p span.yiv3163671484yshortcuts
{margin-right:0;}#yiv3163671484 div.yiv3163671484attach-table div div a
{text-decoration:none;}#yiv3163671484 div.yiv3163671484attach-table
{width:400px;}#yiv3163671484 div.yiv3163671484file-title a, #yiv3163671484
div.yiv3163671484file-title a:active, #yiv3163671484
div.yiv3163671484file-title a:hover, #yiv3163671484 div.yiv3163671484file-title
a:visited {text-decoration:none;}#yiv3163671484 div.yiv3163671484photo-title a,
#yiv3163671484 div.yiv3163671484photo-title a:active, #yiv3163671484
div.yiv3163671484photo-title a:hover, #yiv3163671484
div.yiv3163671484photo-title a:visited {text-decoration:none;}#yiv3163671484
div#yiv3163671484ygrp-mlmsg #yiv3163671484ygrp-msg p a
span.yiv3163671484yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3163671484
.yiv3163671484green {color:#628c2a;}#yiv3163671484 .yiv3163671484MsoNormal
{margin:0 0 0 0;}#yiv3163671484 o {font-size:0;}#yiv3163671484
#yiv3163671484photos div {float:left;width:72px;}#yiv3163671484
#yiv3163671484photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv3163671484
#yiv3163671484photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3163671484
#yiv3163671484reco-category {font-size:77%;}#yiv3163671484
#yiv3163671484reco-desc {font-size:77%;}#yiv3163671484 .yiv3163671484replbq
{margin:4px;}#yiv3163671484 #yiv3163671484ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv3163671484 #yiv3163671484ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3163671484
#yiv3163671484ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3163671484
#yiv3163671484ygrp-mlmsg select, #yiv3163671484 input, #yiv3163671484 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv3163671484
#yiv3163671484ygrp-mlmsg pre, #yiv3163671484 code {font:115%
monospace;}#yiv3163671484 #yiv3163671484ygrp-mlmsg *
{line-height:1.22em;}#yiv3163671484 #yiv3163671484ygrp-mlmsg #yiv3163671484logo
{padding-bottom:10px;}#yiv3163671484 #yiv3163671484ygrp-msg p a
{font-family:Verdana;}#yiv3163671484 #yiv3163671484ygrp-msg
p#yiv3163671484attach-count span {color:#1E66AE;font-weight:700;}#yiv3163671484
#yiv3163671484ygrp-reco #yiv3163671484reco-head
{color:#ff7900;font-weight:700;}#yiv3163671484 #yiv3163671484ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv3163671484 #yiv3163671484ygrp-sponsor
#yiv3163671484ov li a {font-size:130%;text-decoration:none;}#yiv3163671484
#yiv3163671484ygrp-sponsor #yiv3163671484ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv3163671484
#yiv3163671484ygrp-sponsor #yiv3163671484ov ul {margin:0;padding:0 0 0
8px;}#yiv3163671484 #yiv3163671484ygrp-text
{font-family:Georgia;}#yiv3163671484 #yiv3163671484ygrp-text p {margin:0 0 1em
0;}#yiv3163671484 #yiv3163671484ygrp-text tt {font-size:120%;}#yiv3163671484
#yiv3163671484ygrp-vital ul li:last-child {border-right:none
!important;}#yiv3163671484
