Senin, 22 Desember 2014

]] XL-mania [[ Digest Number 2781

15 Messages

Digest #2781
1a
Re: Rumus Excel tidak jalan [1 Attachment] by "Sumartin, Sumartin" martin_1304
2a
Re: Penyebab if Bertingkat eror [1 Attachment] by "Sumartin, Sumartin" martin_1304
2b
4a
7
8
Excel 2010 by "Deddy Rachmad" deddyird
9
Multiple kriteria by "Agus Suyanto"
10
11
Membuat List sesuai apa yang di inginkan by "Eko Ludiono" waneko989@ymail.com

Messages

Mon Dec 22, 2014 9:37 pm (PST) . Posted by:

"Sumartin, Sumartin" martin_1304

Mas Androni,

Itu hanya masalah di format cell,
Cukup dengan select all cell/sheet, klick kanan akan muncul menu format
cell, pilih format cell dan pilih General, kemudian klick ok.
Setelah itu refresh dengan tekan tombol F4.

Semoga membantu
On Dec 12, 2014 4:38 PM, "androni androni androni_sg@yahoo.com [XL-mania]" <
XL-mania@yahoogroups.com> wrote:

>
>
> Dear pakar excel,
>
> Saya ingin menggunakan rumus di lembar kerja excel saya, tapi rumus tidak
> berfungsi seperti file terlampir.
>
> Mohon bantuan rekan sekalian,

>
> Terimakasih sebelumnya
>
> Best Regards,
> Androni Susanto
>
>

Mon Dec 22, 2014 9:39 pm (PST) . Posted by:

"Bagus" bagus4bls

Pak Androni;

Mungkin karena pada rumusnya type datanya text.
Coba block F5:G5 lalu tekan Ctrl+1
Pada tab Number, ganti kategory text menjadi Number, lalu OK
tekan F2 lalu Enter

Wassalam

~ Bagus ~

----- Original Message -----
From: androni androni androni_sg@yahoo.com [XL-mania]
To: XL-mania@yahoogroups.com
Sent: Wednesday, November 26, 2014 4:37 PM
Subject: ]] XL-mania [[ Rumus Excel tidak jalan [1 Attachment]

Dear pakar excel,

Saya ingin menggunakan rumus di lembar kerja excel saya, tapi rumus tidak berfungsi seperti file terlampir.

Mohon bantuan rekan sekalian,

Terimakasih sebelumnya

Best Regards,
Androni Susanto

Mon Dec 22, 2014 9:37 pm (PST) . Posted by:

"Sumartin, Sumartin" martin_1304

Perbaiki formulanya dengan menambahkan sum;
=if(sum(G9:J9)>0,sum(k9:n9)-i9,if(sum(g9:j9)<=0,n9*1))

Semoga membantu
On Dec 12, 2014 5:08 PM, "Ari Mike arimike@ymail.com [XL-mania]" <
XL-mania@yahoogroups.com> wrote:

>
>
> Rekan - rekan
> saya ingin bertanya solusi formula yang saya lampirkan
>
> Regards
> Arimike
>
>

Mon Dec 22, 2014 9:37 pm (PST) . Posted by:

"HERIS PAMUNTJAR" heris2001

Begini sdr. Arimike ....
rumus semula di O9  adalah   =IF(G9:J9>0;SUM(K9:N9)-I9;IF(G9:J9<=0 ; N9*1))
kalau mengikuti logika di atas, rumus di O9 seharusnya sbb
 =IF(SUM(G9:J9)>0;SUM(K9:N9)-I9;N9)

pertanyaan !   mengapa rumus di O10 kok jadi SUM .. ( sementara mungkin )

On Friday, December 12, 2014 5:08 PM, "Ari Mike arimike@ymail.com [XL-mania]" <XL-mania@yahoogroups.com> wrote:


  Rekan - rekan
saya ingin bertanya solusi formula yang saya lampirkan
RegardsArimike
#yiv2504229334 #yiv2504229334 -- #yiv2504229334ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2504229334 #yiv2504229334ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2504229334 #yiv2504229334ygrp-mkp #yiv2504229334hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2504229334 #yiv2504229334ygrp-mkp #yiv2504229334ads {margin-bottom:10px;}#yiv2504229334 #yiv2504229334ygrp-mkp .yiv2504229334ad {padding:0 0;}#yiv2504229334 #yiv2504229334ygrp-mkp .yiv2504229334ad p {margin:0;}#yiv2504229334 #yiv2504229334ygrp-mkp .yiv2504229334ad a {color:#0000ff;text-decoration:none;}#yiv2504229334 #yiv2504229334ygrp-sponsor #yiv2504229334ygrp-lc {font-family:Arial;}#yiv2504229334 #yiv2504229334ygrp-sponsor #yiv2504229334ygrp-lc #yiv2504229334hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2504229334 #yiv2504229334ygrp-sponsor #yiv2504229334ygrp-lc .yiv2504229334ad {margin-bottom:10px;padding:0 0;}#yiv2504229334 #yiv2504229334actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2504229334 #yiv2504229334activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2504229334 #yiv2504229334activity span {font-weight:700;}#yiv2504229334 #yiv2504229334activity span:first-child {text-transform:uppercase;}#yiv2504229334 #yiv2504229334activity span a {color:#5085b6;text-decoration:none;}#yiv2504229334 #yiv2504229334activity span span {color:#ff7900;}#yiv2504229334 #yiv2504229334activity span .yiv2504229334underline {text-decoration:underline;}#yiv2504229334 .yiv2504229334attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2504229334 .yiv2504229334attach div a {text-decoration:none;}#yiv2504229334 .yiv2504229334attach img {border:none;padding-right:5px;}#yiv2504229334 .yiv2504229334attach label {display:block;margin-bottom:5px;}#yiv2504229334 .yiv2504229334attach label a {text-decoration:none;}#yiv2504229334 blockquote {margin:0 0 0 4px;}#yiv2504229334 .yiv2504229334bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2504229334 .yiv2504229334bold a {text-decoration:none;}#yiv2504229334 dd.yiv2504229334last p a {font-family:Verdana;font-weight:700;}#yiv2504229334 dd.yiv2504229334last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2504229334 dd.yiv2504229334last p span.yiv2504229334yshortcuts {margin-right:0;}#yiv2504229334 div.yiv2504229334attach-table div div a {text-decoration:none;}#yiv2504229334 div.yiv2504229334attach-table {width:400px;}#yiv2504229334 div.yiv2504229334file-title a, #yiv2504229334 div.yiv2504229334file-title a:active, #yiv2504229334 div.yiv2504229334file-title a:hover, #yiv2504229334 div.yiv2504229334file-title a:visited {text-decoration:none;}#yiv2504229334 div.yiv2504229334photo-title a, #yiv2504229334 div.yiv2504229334photo-title a:active, #yiv2504229334 div.yiv2504229334photo-title a:hover, #yiv2504229334 div.yiv2504229334photo-title a:visited {text-decoration:none;}#yiv2504229334 div#yiv2504229334ygrp-mlmsg #yiv2504229334ygrp-msg p a span.yiv2504229334yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2504229334 .yiv2504229334green {color:#628c2a;}#yiv2504229334 .yiv2504229334MsoNormal {margin:0 0 0 0;}#yiv2504229334 o {font-size:0;}#yiv2504229334 #yiv2504229334photos div {float:left;width:72px;}#yiv2504229334 #yiv2504229334photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv2504229334 #yiv2504229334photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2504229334 #yiv2504229334reco-category {font-size:77%;}#yiv2504229334 #yiv2504229334reco-desc {font-size:77%;}#yiv2504229334 .yiv2504229334replbq {margin:4px;}#yiv2504229334 #yiv2504229334ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2504229334 #yiv2504229334ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2504229334 #yiv2504229334ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2504229334 #yiv2504229334ygrp-mlmsg select, #yiv2504229334 input, #yiv2504229334 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2504229334 #yiv2504229334ygrp-mlmsg pre, #yiv2504229334 code {font:115% monospace;}#yiv2504229334 #yiv2504229334ygrp-mlmsg * {line-height:1.22em;}#yiv2504229334 #yiv2504229334ygrp-mlmsg #yiv2504229334logo {padding-bottom:10px;}#yiv2504229334 #yiv2504229334ygrp-msg p a {font-family:Verdana;}#yiv2504229334 #yiv2504229334ygrp-msg p#yiv2504229334attach-count span {color:#1E66AE;font-weight:700;}#yiv2504229334 #yiv2504229334ygrp-reco #yiv2504229334reco-head {color:#ff7900;font-weight:700;}#yiv2504229334 #yiv2504229334ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2504229334 #yiv2504229334ygrp-sponsor #yiv2504229334ov li a {font-size:130%;text-decoration:none;}#yiv2504229334 #yiv2504229334ygrp-sponsor #yiv2504229334ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2504229334 #yiv2504229334ygrp-sponsor #yiv2504229334ov ul {margin:0;padding:0 0 0 8px;}#yiv2504229334 #yiv2504229334ygrp-text {font-family:Georgia;}#yiv2504229334 #yiv2504229334ygrp-text p {margin:0 0 1em 0;}#yiv2504229334 #yiv2504229334ygrp-text tt {font-size:120%;}#yiv2504229334 #yiv2504229334ygrp-vital ul li:last-child {border-right:none !important;}#yiv2504229334

Mon Dec 22, 2014 9:40 pm (PST) . Posted by:

"Iwan Setiawan"

=IF(SUM(G9:J9)>0;SUM(K9:N9)-I9;IF(SUM(G9:J9)<=0;N9*1))

From: XL-mania@yahoogroups.com [mailto:XL-mania@yahoogroups.com]
Sent: 04 Desember 2014 23:24
To: XL-mania@yahoogroups.com
Subject: ]] XL-mania [[ Penyebab if Bertingkat eror [1 Attachment]


Rekan - rekan
saya ingin bertanya solusi formula yang saya lampirkan

Regards
Arimike

Mon Dec 22, 2014 9:41 pm (PST) . Posted by:

"rhonal iron" iron_sagit

Coba menggunakan fungsi CSE (Ctrl,Shitf dan Enter) Pak, karena kondisinya menggunakan data range. { =IF(G9:J9>0,SUM(K9:N9)-I9,IF(G9:J9<=0,N9*1))} atau  ditambahkan sum pada rumusnya: =IF(sum(G9:J9)>0,SUM(K9:N9)-I9,IF(sum(G9:J9)<=0,N9*1)))Semoga bisa membantu.   Best Regards,iron

On Friday, December 12, 2014 5:13 PM, "Ari Mike arimike@ymail.com [XL-mania]" <XL-mania@yahoogroups.com> wrote:


  Rekan - rekan
saya ingin bertanya solusi formula yang saya lampirkan
RegardsArimike
#yiv3630367345 #yiv3630367345 -- #yiv3630367345ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3630367345 #yiv3630367345ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3630367345 #yiv3630367345ygrp-mkp #yiv3630367345hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3630367345 #yiv3630367345ygrp-mkp #yiv3630367345ads {margin-bottom:10px;}#yiv3630367345 #yiv3630367345ygrp-mkp .yiv3630367345ad {padding:0 0;}#yiv3630367345 #yiv3630367345ygrp-mkp .yiv3630367345ad p {margin:0;}#yiv3630367345 #yiv3630367345ygrp-mkp .yiv3630367345ad a {color:#0000ff;text-decoration:none;}#yiv3630367345 #yiv3630367345ygrp-sponsor #yiv3630367345ygrp-lc {font-family:Arial;}#yiv3630367345 #yiv3630367345ygrp-sponsor #yiv3630367345ygrp-lc #yiv3630367345hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3630367345 #yiv3630367345ygrp-sponsor #yiv3630367345ygrp-lc .yiv3630367345ad {margin-bottom:10px;padding:0 0;}#yiv3630367345 #yiv3630367345actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3630367345 #yiv3630367345activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3630367345 #yiv3630367345activity span {font-weight:700;}#yiv3630367345 #yiv3630367345activity span:first-child {text-transform:uppercase;}#yiv3630367345 #yiv3630367345activity span a {color:#5085b6;text-decoration:none;}#yiv3630367345 #yiv3630367345activity span span {color:#ff7900;}#yiv3630367345 #yiv3630367345activity span .yiv3630367345underline {text-decoration:underline;}#yiv3630367345 .yiv3630367345attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3630367345 .yiv3630367345attach div a {text-decoration:none;}#yiv3630367345 .yiv3630367345attach img {border:none;padding-right:5px;}#yiv3630367345 .yiv3630367345attach label {display:block;margin-bottom:5px;}#yiv3630367345 .yiv3630367345attach label a {text-decoration:none;}#yiv3630367345 blockquote {margin:0 0 0 4px;}#yiv3630367345 .yiv3630367345bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3630367345 .yiv3630367345bold a {text-decoration:none;}#yiv3630367345 dd.yiv3630367345last p a {font-family:Verdana;font-weight:700;}#yiv3630367345 dd.yiv3630367345last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3630367345 dd.yiv3630367345last p span.yiv3630367345yshortcuts {margin-right:0;}#yiv3630367345 div.yiv3630367345attach-table div div a {text-decoration:none;}#yiv3630367345 div.yiv3630367345attach-table {width:400px;}#yiv3630367345 div.yiv3630367345file-title a, #yiv3630367345 div.yiv3630367345file-title a:active, #yiv3630367345 div.yiv3630367345file-title a:hover, #yiv3630367345 div.yiv3630367345file-title a:visited {text-decoration:none;}#yiv3630367345 div.yiv3630367345photo-title a, #yiv3630367345 div.yiv3630367345photo-title a:active, #yiv3630367345 div.yiv3630367345photo-title a:hover, #yiv3630367345 div.yiv3630367345photo-title a:visited {text-decoration:none;}#yiv3630367345 div#yiv3630367345ygrp-mlmsg #yiv3630367345ygrp-msg p a span.yiv3630367345yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3630367345 .yiv3630367345green {color:#628c2a;}#yiv3630367345 .yiv3630367345MsoNormal {margin:0 0 0 0;}#yiv3630367345 o {font-size:0;}#yiv3630367345 #yiv3630367345photos div {float:left;width:72px;}#yiv3630367345 #yiv3630367345photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv3630367345 #yiv3630367345photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3630367345 #yiv3630367345reco-category {font-size:77%;}#yiv3630367345 #yiv3630367345reco-desc {font-size:77%;}#yiv3630367345 .yiv3630367345replbq {margin:4px;}#yiv3630367345 #yiv3630367345ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3630367345 #yiv3630367345ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3630367345 #yiv3630367345ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3630367345 #yiv3630367345ygrp-mlmsg select, #yiv3630367345 input, #yiv3630367345 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3630367345 #yiv3630367345ygrp-mlmsg pre, #yiv3630367345 code {font:115% monospace;}#yiv3630367345 #yiv3630367345ygrp-mlmsg * {line-height:1.22em;}#yiv3630367345 #yiv3630367345ygrp-mlmsg #yiv3630367345logo {padding-bottom:10px;}#yiv3630367345 #yiv3630367345ygrp-msg p a {font-family:Verdana;}#yiv3630367345 #yiv3630367345ygrp-msg p#yiv3630367345attach-count span {color:#1E66AE;font-weight:700;}#yiv3630367345 #yiv3630367345ygrp-reco #yiv3630367345reco-head {color:#ff7900;font-weight:700;}#yiv3630367345 #yiv3630367345ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3630367345 #yiv3630367345ygrp-sponsor #yiv3630367345ov li a {font-size:130%;text-decoration:none;}#yiv3630367345 #yiv3630367345ygrp-sponsor #yiv3630367345ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3630367345 #yiv3630367345ygrp-sponsor #yiv3630367345ov ul {margin:0;padding:0 0 0 8px;}#yiv3630367345 #yiv3630367345ygrp-text {font-family:Georgia;}#yiv3630367345 #yiv3630367345ygrp-text p {margin:0 0 1em 0;}#yiv3630367345 #yiv3630367345ygrp-text tt {font-size:120%;}#yiv3630367345 #yiv3630367345ygrp-vital ul li:last-child {border-right:none !important;}#yiv3630367345

Mon Dec 22, 2014 9:37 pm (PST) . Posted by:

"Maulwy Shahran" awys666

Dear All,

Formula di E3: =if(c3<0,"STOCK KURANG", "STOCK OK")

Copy ke bawah

Salam,

From: XL-mania@yahoogroups.com [mailto:XL-mania@yahoogroups.com]
Sent: Friday, December 05, 2014 9:44 AM
To: XL-mania@yahoogroups.com
Subject: ]] XL-mania [[ Satu lokasi kurang, maka SKU di beberapa lokasi akan ada signal kurang [1 Attachment]

Selamat pagi Guru's

Mohon bantuannya untuk formula yang mana Jika ada stock yang minus di salah satu lokasi , maka di kolom remark akan ada message " stock kurang"

Thanks a lot.

Regards,

Setyo

Mon Dec 22, 2014 9:38 pm (PST) . Posted by:

"HERIS PAMUNTJAR" heris2001

Sdr. Herlambang,   gunakan Conditonal Formatting untuk setiap kelompok rata-rata


On Friday, December 12, 2014 4:38 PM, "Herlambang Wibowo hwibowo81@yahoo.com [XL-mania]" <XL-mania@yahoogroups.com> wrote:


  Mohon bantuannnya master,
bagaimana caranya agar nilai2 yang kembar (berwarna kuning) tersebut bisa di bedakan tanpa nilai dibelakang koma (pembulatan)
Karena nilai pokok yang besar bila di rata2 dan di bulatkan menjadi sama dengan yang nilai pokoknya kecil.
Apa tidak bisa di ubah menjadi 14,15, 16 ?
Terima kasih bantuannya... #yiv2311890132 #yiv2311890132 -- #yiv2311890132ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2311890132 #yiv2311890132ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2311890132 #yiv2311890132ygrp-mkp #yiv2311890132hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2311890132 #yiv2311890132ygrp-mkp #yiv2311890132ads {margin-bottom:10px;}#yiv2311890132 #yiv2311890132ygrp-mkp .yiv2311890132ad {padding:0 0;}#yiv2311890132 #yiv2311890132ygrp-mkp .yiv2311890132ad p {margin:0;}#yiv2311890132 #yiv2311890132ygrp-mkp .yiv2311890132ad a {color:#0000ff;text-decoration:none;}#yiv2311890132 #yiv2311890132ygrp-sponsor #yiv2311890132ygrp-lc {font-family:Arial;}#yiv2311890132 #yiv2311890132ygrp-sponsor #yiv2311890132ygrp-lc #yiv2311890132hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2311890132 #yiv2311890132ygrp-sponsor #yiv2311890132ygrp-lc .yiv2311890132ad {margin-bottom:10px;padding:0 0;}#yiv2311890132 #yiv2311890132actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2311890132 #yiv2311890132activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2311890132 #yiv2311890132activity span {font-weight:700;}#yiv2311890132 #yiv2311890132activity span:first-child {text-transform:uppercase;}#yiv2311890132 #yiv2311890132activity span a {color:#5085b6;text-decoration:none;}#yiv2311890132 #yiv2311890132activity span span {color:#ff7900;}#yiv2311890132 #yiv2311890132activity span .yiv2311890132underline {text-decoration:underline;}#yiv2311890132 .yiv2311890132attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2311890132 .yiv2311890132attach div a {text-decoration:none;}#yiv2311890132 .yiv2311890132attach img {border:none;padding-right:5px;}#yiv2311890132 .yiv2311890132attach label {display:block;margin-bottom:5px;}#yiv2311890132 .yiv2311890132attach label a {text-decoration:none;}#yiv2311890132 blockquote {margin:0 0 0 4px;}#yiv2311890132 .yiv2311890132bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2311890132 .yiv2311890132bold a {text-decoration:none;}#yiv2311890132 dd.yiv2311890132last p a {font-family:Verdana;font-weight:700;}#yiv2311890132 dd.yiv2311890132last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2311890132 dd.yiv2311890132last p span.yiv2311890132yshortcuts {margin-right:0;}#yiv2311890132 div.yiv2311890132attach-table div div a {text-decoration:none;}#yiv2311890132 div.yiv2311890132attach-table {width:400px;}#yiv2311890132 div.yiv2311890132file-title a, #yiv2311890132 div.yiv2311890132file-title a:active, #yiv2311890132 div.yiv2311890132file-title a:hover, #yiv2311890132 div.yiv2311890132file-title a:visited {text-decoration:none;}#yiv2311890132 div.yiv2311890132photo-title a, #yiv2311890132 div.yiv2311890132photo-title a:active, #yiv2311890132 div.yiv2311890132photo-title a:hover, #yiv2311890132 div.yiv2311890132photo-title a:visited {text-decoration:none;}#yiv2311890132 div#yiv2311890132ygrp-mlmsg #yiv2311890132ygrp-msg p a span.yiv2311890132yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2311890132 .yiv2311890132green {color:#628c2a;}#yiv2311890132 .yiv2311890132MsoNormal {margin:0 0 0 0;}#yiv2311890132 o {font-size:0;}#yiv2311890132 #yiv2311890132photos div {float:left;width:72px;}#yiv2311890132 #yiv2311890132photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv2311890132 #yiv2311890132photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2311890132 #yiv2311890132reco-category {font-size:77%;}#yiv2311890132 #yiv2311890132reco-desc {font-size:77%;}#yiv2311890132 .yiv2311890132replbq {margin:4px;}#yiv2311890132 #yiv2311890132ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2311890132 #yiv2311890132ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2311890132 #yiv2311890132ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2311890132 #yiv2311890132ygrp-mlmsg select, #yiv2311890132 input, #yiv2311890132 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2311890132 #yiv2311890132ygrp-mlmsg pre, #yiv2311890132 code {font:115% monospace;}#yiv2311890132 #yiv2311890132ygrp-mlmsg * {line-height:1.22em;}#yiv2311890132 #yiv2311890132ygrp-mlmsg #yiv2311890132logo {padding-bottom:10px;}#yiv2311890132 #yiv2311890132ygrp-msg p a {font-family:Verdana;}#yiv2311890132 #yiv2311890132ygrp-msg p#yiv2311890132attach-count span {color:#1E66AE;font-weight:700;}#yiv2311890132 #yiv2311890132ygrp-reco #yiv2311890132reco-head {color:#ff7900;font-weight:700;}#yiv2311890132 #yiv2311890132ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2311890132 #yiv2311890132ygrp-sponsor #yiv2311890132ov li a {font-size:130%;text-decoration:none;}#yiv2311890132 #yiv2311890132ygrp-sponsor #yiv2311890132ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2311890132 #yiv2311890132ygrp-sponsor #yiv2311890132ov ul {margin:0;padding:0 0 0 8px;}#yiv2311890132 #yiv2311890132ygrp-text {font-family:Georgia;}#yiv2311890132 #yiv2311890132ygrp-text p {margin:0 0 1em 0;}#yiv2311890132 #yiv2311890132ygrp-text tt {font-size:120%;}#yiv2311890132 #yiv2311890132ygrp-vital ul li:last-child {border-right:none !important;}#yiv2311890132

Mon Dec 22, 2014 9:38 pm (PST) . Posted by:

"Bagus" bagus4bls

Pak Joko;

Coba begini, Array formula ya..
=IFERROR(SMALL(IF($A$2:$A$14=$D$1,ROW($A$2:$A$14)-ROW($A$1)),ROW(1:1)),"")

Copas kebawah

Wassalam

~ Bagus ~

----- Original Message -----
From: joko Pramono joko_pramono_sap@yahoo.co.id [XL-mania]
To: XL-mania@yahoogroups.com
Sent: Thursday, December 11, 2014 8:32 PM
Subject: ]] XL-mania [[ Mengurai data unik dengan kriteria [1 Attachment]

Dear Para Suhu

Mohon bantuan untuk Mengurai data unik dengan kriteria pada suatu table.. Saya sudah coba dengan rumus array namun harus melaui beberapa step, namunbila formula array digabungkan hasilnya blank.

Mohon pencerahan.

File terlampir

Regards,

joko

Mon Dec 22, 2014 9:39 pm (PST) . Posted by:

"Heri Askot Eko K5" heri_k5

To Androni Susanto

Sepertinya format number pada lembar kerja anda sebagian besar menggunakan format text, sehingga excel membaca rumusnya sebagai tulisan. Untuk memperbaikinya :1. Block semua cell (Ctrl+A)2. Klik kanan, lalu pilih "Format Cells",
3. Kemudian pada sheet "Number" pilih "Accounting", tidak lupa menggani angka "2" menjadi "0" pada jendela "Decimal places".4. Klik Ok

Sedangkan untuk kolom F2 s/d F4 (yang masih ada tanda hijau pada kiri atas cellnya) yg perlu dilakukan adalah :1. Block cell F2 s/d F4,
2. Klik tanda seru/"!" (warna orange) yang terdapat pada pojok kiri atas cells yang di block
3. Kemudian pilih "Convert to number"
Selanjutnya hapus rumus yang sebelumnya dibuat pada cells F5 dan buat ulang rumus baru yang sama.
Demikan, salamHeri

Pada Jumat, 12 Desember 2014 16:39, "androni androni androni_sg@yahoo.com [XL-mania]" <XL-mania@yahoogroups.com> menulis:


  Dear pakar excel,
Saya ingin menggunakan rumus di lembar kerja excel saya, tapi rumus tidak berfungsi seperti file terlampir.
Mohon bantuan rekan sekalian,
Terimakasih sebelumnya
 Best Regards,
Androni Susanto
#yiv6725630320 #yiv6725630320 -- #yiv6725630320ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6725630320 #yiv6725630320ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6725630320 #yiv6725630320ygrp-mkp #yiv6725630320hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv6725630320 #yiv6725630320ygrp-mkp #yiv6725630320ads {margin-bottom:10px;}#yiv6725630320 #yiv6725630320ygrp-mkp .yiv6725630320ad {padding:0 0;}#yiv6725630320 #yiv6725630320ygrp-mkp .yiv6725630320ad p {margin:0;}#yiv6725630320 #yiv6725630320ygrp-mkp .yiv6725630320ad a {color:#0000ff;text-decoration:none;}#yiv6725630320 #yiv6725630320ygrp-sponsor #yiv6725630320ygrp-lc {font-family:Arial;}#yiv6725630320 #yiv6725630320ygrp-sponsor #yiv6725630320ygrp-lc #yiv6725630320hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6725630320 #yiv6725630320ygrp-sponsor #yiv6725630320ygrp-lc .yiv6725630320ad {margin-bottom:10px;padding:0 0;}#yiv6725630320 #yiv6725630320actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6725630320 #yiv6725630320activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6725630320 #yiv6725630320activity span {font-weight:700;}#yiv6725630320 #yiv6725630320activity span:first-child {text-transform:uppercase;}#yiv6725630320 #yiv6725630320activity span a {color:#5085b6;text-decoration:none;}#yiv6725630320 #yiv6725630320activity span span {color:#ff7900;}#yiv6725630320 #yiv6725630320activity span .yiv6725630320underline {text-decoration:underline;}#yiv6725630320 .yiv6725630320attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv6725630320 .yiv6725630320attach div a {text-decoration:none;}#yiv6725630320 .yiv6725630320attach img {border:none;padding-right:5px;}#yiv6725630320 .yiv6725630320attach label {display:block;margin-bottom:5px;}#yiv6725630320 .yiv6725630320attach label a {text-decoration:none;}#yiv6725630320 blockquote {margin:0 0 0 4px;}#yiv6725630320 .yiv6725630320bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv6725630320 .yiv6725630320bold a {text-decoration:none;}#yiv6725630320 dd.yiv6725630320last p a {font-family:Verdana;font-weight:700;}#yiv6725630320 dd.yiv6725630320last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6725630320 dd.yiv6725630320last p span.yiv6725630320yshortcuts {margin-right:0;}#yiv6725630320 div.yiv6725630320attach-table div div a {text-decoration:none;}#yiv6725630320 div.yiv6725630320attach-table {width:400px;}#yiv6725630320 div.yiv6725630320file-title a, #yiv6725630320 div.yiv6725630320file-title a:active, #yiv6725630320 div.yiv6725630320file-title a:hover, #yiv6725630320 div.yiv6725630320file-title a:visited {text-decoration:none;}#yiv6725630320 div.yiv6725630320photo-title a, #yiv6725630320 div.yiv6725630320photo-title a:active, #yiv6725630320 div.yiv6725630320photo-title a:hover, #yiv6725630320 div.yiv6725630320photo-title a:visited {text-decoration:none;}#yiv6725630320 div#yiv6725630320ygrp-mlmsg #yiv6725630320ygrp-msg p a span.yiv6725630320yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6725630320 .yiv6725630320green {color:#628c2a;}#yiv6725630320 .yiv6725630320MsoNormal {margin:0 0 0 0;}#yiv6725630320 o {font-size:0;}#yiv6725630320 #yiv6725630320photos div {float:left;width:72px;}#yiv6725630320 #yiv6725630320photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv6725630320 #yiv6725630320photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6725630320 #yiv6725630320reco-category {font-size:77%;}#yiv6725630320 #yiv6725630320reco-desc {font-size:77%;}#yiv6725630320 .yiv6725630320replbq {margin:4px;}#yiv6725630320 #yiv6725630320ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv6725630320 #yiv6725630320ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6725630320 #yiv6725630320ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6725630320 #yiv6725630320ygrp-mlmsg select, #yiv6725630320 input, #yiv6725630320 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv6725630320 #yiv6725630320ygrp-mlmsg pre, #yiv6725630320 code {font:115% monospace;}#yiv6725630320 #yiv6725630320ygrp-mlmsg * {line-height:1.22em;}#yiv6725630320 #yiv6725630320ygrp-mlmsg #yiv6725630320logo {padding-bottom:10px;}#yiv6725630320 #yiv6725630320ygrp-msg p a {font-family:Verdana;}#yiv6725630320 #yiv6725630320ygrp-msg p#yiv6725630320attach-count span {color:#1E66AE;font-weight:700;}#yiv6725630320 #yiv6725630320ygrp-reco #yiv6725630320reco-head {color:#ff7900;font-weight:700;}#yiv6725630320 #yiv6725630320ygrp-reco {margin-bottom:20px;padding:0px;}#yiv6725630320 #yiv6725630320ygrp-sponsor #yiv6725630320ov li a {font-size:130%;text-decoration:none;}#yiv6725630320 #yiv6725630320ygrp-sponsor #yiv6725630320ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv6725630320 #yiv6725630320ygrp-sponsor #yiv6725630320ov ul {margin:0;padding:0 0 0 8px;}#yiv6725630320 #yiv6725630320ygrp-text {font-family:Georgia;}#yiv6725630320 #yiv6725630320ygrp-text p {margin:0 0 1em 0;}#yiv6725630320 #yiv6725630320ygrp-text tt {font-size:120%;}#yiv6725630320 #yiv6725630320ygrp-vital ul li:last-child {border-right:none !important;}#yiv6725630320

Mon Dec 22, 2014 9:39 pm (PST) . Posted by:

triono_ea

Yth. Para Sahabat XL-mania


Mohon pencerahan untuk kasus yang saya hadapi, misal hasil dari suatu penjumlahan, dapatkah kita mencari dari hasil penjumlahan nilai yang mana dari beberapa nilai yang ada (kasus terlampir)



Demikian atas bantuan Sahabat smua saya ucapkan terima kasih.


Salam,
Trie

Mon Dec 22, 2014 9:39 pm (PST) . Posted by:

"Deddy Rachmad" deddyird

Salam pakar2 Excel.Saya baru menggunakan excel 2010.Saya mau meng insert spin button tetapi selalu tidak bisa dan message nya adalah "Cannot insert Object "
Mohon bantuan nya, apakah ada yang harus di setting ? bagaimana caranya.
Terimakasih.

Mon Dec 22, 2014 9:40 pm (PST) . Posted by:

"Agus Suyanto"

Dear pakar excel,

Mohon bantuannya untuk menghitung dengan beberapa criteria seperti pada lampiran berikut.

Terima kasih atas bantuannya.

Rgds,

Agus

Mon Dec 22, 2014 9:41 pm (PST) . Posted by:

"Eko Nurcahyanto"

Dear Suhu exel,

Mohon bantuan formula terlampir.

Terimakasih,

ECho

Mon Dec 22, 2014 9:41 pm (PST) . Posted by:

"Eko Ludiono" waneko989@ymail.com

Dear Temans,
Mohon bantuanya para suhu suhu excel,

Thx,

 
:: XL-mania ::::::::::::::::::::
Momods sekarang jualan tas di www.flirtypoodle.com ha ha ha....
:: ------------- ::::::::::::::::::::
DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, pembicaraan pribadi, one line message,  melecehkan,  tidak sopan.
:: ------------- ::::::::::::::::::::
Buat subjek yang kreatif, jangan : &quot;tanya&quot;, &quot;help&quot;, &quot;mohon bantu&quot;
Usahakan besar attachment &lt; 200 kb. Gunakan  winzip  jika  perlu.
:: ------------- ::::::::::::::::::::
Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke
XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari
http://groups.yahoo.com/group/XL-mania/files/Promotion/         
:: ------------- ::::::::::::::::::::
Berikan testimoni di : 
http://www.xl-mania.com/2008/06/testimoni-xl-mania.html        
:: ------------- ::::::::::::::::::::
Message lama ada di :
http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id]
http://www.mail-archive.com/xl-mania@yahoogroups.com

Tidak ada komentar:

Poskan Komentar