Re: [belajar-excel] Formula SMALL IF error ( muncul #N/A ) [1 Attachment]

Sat, 21 Feb 2015 04:45:07 -0800 

Wah, dah clear permasalahannya..




Salam,
Rudi Anto
--------------------------------------------
On Fri, 2/20/15, Rudi Anto [email protected] [belajar-excel] 
<[email protected]> wrote:


 Subject: [belajar-excel] Formula SMALL IF error ( muncul #N/A ) [1 Attachment]
 To: [email protected]
 Date: Friday, February 20, 2015, 7:09 PM


  


 







       Salam untuk anggota milis Belajar-excel,



 Berikut saya lampirkan file excel dengan formula SMALL(IF
 yang error,

 Singkat cerita error terjadi ketika saya pilih tanggal akhir
 dari transaksi,

 ambil contoh ketika tanggal terakhir sampai tanggal 7 (
 seperti di sheet utility U3 )

 maka array formula yang dihasilkan di sheet helper akan
 berubah menjadi #N/A,



 Semoga file terlampir bisa membantu menyampaikan kasus yang
 saya alami.

 Terima kasih sebelumnya atas bantuannya.



 Salam,

 Rudi Anto









 #yiv5003917243 #yiv5003917243 --
   #yiv5003917243ygrp-mkp {
 border:1px solid #d8d8d8;font-family:Arial;margin:10px
 0;padding:0 10px;}

 #yiv5003917243 #yiv5003917243ygrp-mkp hr {
 border:1px solid #d8d8d8;}

 #yiv5003917243 #yiv5003917243ygrp-mkp #yiv5003917243hd {
 color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
 0;}

 #yiv5003917243 #yiv5003917243ygrp-mkp #yiv5003917243ads {
 margin-bottom:10px;}

 #yiv5003917243 #yiv5003917243ygrp-mkp .yiv5003917243ad {
 padding:0 0;}

 #yiv5003917243 #yiv5003917243ygrp-mkp .yiv5003917243ad p {
 margin:0;}

 #yiv5003917243 #yiv5003917243ygrp-mkp .yiv5003917243ad a {
 color:#0000ff;text-decoration:none;}
 #yiv5003917243 #yiv5003917243ygrp-sponsor
 #yiv5003917243ygrp-lc {
 font-family:Arial;}

 #yiv5003917243 #yiv5003917243ygrp-sponsor
 #yiv5003917243ygrp-lc #yiv5003917243hd {
 margin:10px
 0px;font-weight:700;font-size:78%;line-height:122%;}

 #yiv5003917243 #yiv5003917243ygrp-sponsor
 #yiv5003917243ygrp-lc .yiv5003917243ad {
 margin-bottom:10px;padding:0 0;}

 #yiv5003917243 #yiv5003917243actions {
 font-family:Verdana;font-size:11px;padding:10px 0;}

 #yiv5003917243 #yiv5003917243activity {
 
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

 #yiv5003917243 #yiv5003917243activity span {
 font-weight:700;}

 #yiv5003917243 #yiv5003917243activity span:first-child {
 text-transform:uppercase;}

 #yiv5003917243 #yiv5003917243activity span a {
 color:#5085b6;text-decoration:none;}

 #yiv5003917243 #yiv5003917243activity span span {
 color:#ff7900;}

 #yiv5003917243 #yiv5003917243activity span
 .yiv5003917243underline {
 text-decoration:underline;}

 #yiv5003917243 .yiv5003917243attach {
 clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
 0;width:400px;}

 #yiv5003917243 .yiv5003917243attach div a {
 text-decoration:none;}

 #yiv5003917243 .yiv5003917243attach img {
 border:none;padding-right:5px;}

 #yiv5003917243 .yiv5003917243attach label {
 display:block;margin-bottom:5px;}

 #yiv5003917243 .yiv5003917243attach label a {
 text-decoration:none;}

 #yiv5003917243 blockquote {
 margin:0 0 0 4px;}

 #yiv5003917243 .yiv5003917243bold {
 font-family:Arial;font-size:13px;font-weight:700;}

 #yiv5003917243 .yiv5003917243bold a {
 text-decoration:none;}
 

 #yiv5003917243 dd.yiv5003917243last p a {
 font-family:Verdana;font-weight:700;}

 #yiv5003917243 dd.yiv5003917243last p span {
 margin-right:10px;font-family:Verdana;font-weight:700;}

 #yiv5003917243 dd.yiv5003917243last p
 span.yiv5003917243yshortcuts {
 margin-right:0;}

 #yiv5003917243 div.yiv5003917243attach-table div div a {
 text-decoration:none;}

 #yiv5003917243 div.yiv5003917243attach-table {
 width:400px;}

 #yiv5003917243 div.yiv5003917243file-title a, #yiv5003917243
 div.yiv5003917243file-title a:active, #yiv5003917243
 div.yiv5003917243file-title a:hover, #yiv5003917243
 div.yiv5003917243file-title a:visited {
 text-decoration:none;}

 #yiv5003917243 div.yiv5003917243photo-title a,
 #yiv5003917243 div.yiv5003917243photo-title a:active,
 #yiv5003917243 div.yiv5003917243photo-title a:hover,
 #yiv5003917243 div.yiv5003917243photo-title a:visited {
 text-decoration:none;}

 #yiv5003917243 div#yiv5003917243ygrp-mlmsg
 #yiv5003917243ygrp-msg p a span.yiv5003917243yshortcuts {
 font-family:Verdana;font-size:10px;font-weight:normal;}

 #yiv5003917243 .yiv5003917243green {
 color:#628c2a;}

 #yiv5003917243 .yiv5003917243MsoNormal {
 margin:0 0 0 0;}

 #yiv5003917243 o {
 font-size:0;}

 #yiv5003917243 #yiv5003917243photos div {
 float:left;width:72px;}

 #yiv5003917243 #yiv5003917243photos div div {
 border:1px solid
 #666666;height:62px;overflow:hidden;width:62px;}

 #yiv5003917243 #yiv5003917243photos div label {
 
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

 #yiv5003917243 #yiv5003917243reco-category {
 font-size:77%;}

 #yiv5003917243 #yiv5003917243reco-desc {
 font-size:77%;}

 #yiv5003917243 .yiv5003917243replbq {
 margin:4px;}

 #yiv5003917243 #yiv5003917243ygrp-actbar div a:first-child {

 margin-right:2px;padding-right:5px;}

 #yiv5003917243 #yiv5003917243ygrp-mlmsg {
 font-size:13px;font-family:Arial, helvetica, clean,
 sans-serif;}


 #yiv5003917243 #yiv5003917243ygrp-mlmsg table {
 font-size:inherit;font:100%;}

 #yiv5003917243 #yiv5003917243ygrp-mlmsg select,
 #yiv5003917243 input, #yiv5003917243 textarea {
 font:99% Arial, Helvetica, clean, sans-serif;}

 #yiv5003917243 #yiv5003917243ygrp-mlmsg pre, #yiv5003917243
 code {
 font:115% monospace;}

 #yiv5003917243 #yiv5003917243ygrp-mlmsg * {
 line-height:1.22em;}

 #yiv5003917243 #yiv5003917243ygrp-mlmsg #yiv5003917243logo {
 padding-bottom:10px;}


 #yiv5003917243 #yiv5003917243ygrp-msg p a {
 font-family:Verdana;}

 #yiv5003917243 #yiv5003917243ygrp-msg
 p#yiv5003917243attach-count span {
 color:#1E66AE;font-weight:700;}

 #yiv5003917243 #yiv5003917243ygrp-reco
 #yiv5003917243reco-head {
 color:#ff7900;font-weight:700;}

 #yiv5003917243 #yiv5003917243ygrp-reco {
 margin-bottom:20px;padding:0px;}

 #yiv5003917243 #yiv5003917243ygrp-sponsor #yiv5003917243ov
 li a {
 font-size:130%;text-decoration:none;}

 #yiv5003917243 #yiv5003917243ygrp-sponsor #yiv5003917243ov
 li {
 font-size:77%;list-style-type:square;padding:6px 0;}

 #yiv5003917243 #yiv5003917243ygrp-sponsor #yiv5003917243ov
 ul {
 margin:0;padding:0 0 0 8px;}

 #yiv5003917243 #yiv5003917243ygrp-text {
 font-family:Georgia;}

 #yiv5003917243 #yiv5003917243ygrp-text p {
 margin:0 0 1em 0;}

 #yiv5003917243 #yiv5003917243ygrp-text tt {
 font-size:120%;}

 #yiv5003917243 #yiv5003917243ygrp-vital ul li:last-child {
 border-right:none !important;
 }
 #yiv5003917243

Attachment: re_SIMPen.xlsm
Description: application/download

Kirim email ke