[belajar-excel] perhitungan nilai average, min max, stdev [1 Attachment]

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

[belajar-excel] perhitungan nilai average, min max, stdev [1 Attachment]

Milis Belajar Excel mailing list
Dear all
mohon bantuan terkait perhitungan average, min, max , stdev, dimana kategori per tanggal, misal apabila ingin mengetahui average dari tanggal sekian ke sekian langsung otomatis perhitungan average dari tanggal yg ditentukan, untuk lebih jelas nya dilampiran..terima kasih


Dikirim dari Yahoo Mail di Android

Searching pencarian data.xlsx (100K) Download Attachment
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [belajar-excel] perhitungan nilai average, min max, stdev

Milis Belajar Excel mailing list

السَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ
Semangat pagi,.

hmmm,... coba di explore menggunakan rumus indirect pak.
Sepertinya sih memungkinkan.



وَالسَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ

Warm Regards,

On 15/05/2017 11:21, '[hidden email]'
[hidden email] [belajar-excel] wrote:

>
> Dear all
>
>
> mohon bantuan terkait perhitungan average, min, max , stdev, dimana
> kategori per tanggal, misal apabila ingin mengetahui average dari
> tanggal sekian ke sekian langsung otomatis perhitungan average dari
> tanggal yg ditentukan, untuk lebih jelas nya dilampiran..terima kasih
>
> Dikirim dari Yahoo Mail di Android
> <https://overview.mail.yahoo.com/mobile/?.src=Android>
>

Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [belajar-excel] perhitungan nilai average, min max, stdev [1 Attachment]

Milis Belajar Excel mailing list

السَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ
Semangat pagi,.

Lupa Attachmentnya


وَالسَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ

Warm Regards,

On 15/05/2017 16:02, Heri Pamungkas ( Gmail ) wrote:

>
> السَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ
> Semangat pagi,.
>
> hmmm,... coba di explore menggunakan rumus indirect pak.
> Sepertinya sih memungkinkan.
>
>
>
> وَالسَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ
>
> Warm Regards,
> On 15/05/2017 11:21, '[hidden email]'
> [hidden email] [belajar-excel] wrote:
>>
>> Dear all
>>
>>
>> mohon bantuan terkait perhitungan average, min, max , stdev, dimana
>> kategori per tanggal, misal apabila ingin mengetahui average dari
>> tanggal sekian ke sekian langsung otomatis perhitungan average dari
>> tanggal yg ditentukan, untuk lebih jelas nya dilampiran..terima kasih
>>
>> Dikirim dari Yahoo Mail di Android
>> <https://overview.mail.yahoo.com/mobile/?.src=Android>
>>
>


Searching pencarian data - Edited Heri.xlsx (98K) Download Attachment
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Bls: Re: [belajar-excel] perhitungan nilai average, min max, stdev

Milis Belajar Excel mailing list
Terima kasih mr.heri atas bantuannya..


Dikirim dari Yahoo Mail di Android


  Pada Sen, 15 Mei 2017 pada 16:21, 'Heri Pamungkas ( Gmail )' [hidden email] [belajar-excel]<[hidden email]> menulis:    


السَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ
Semangat pagi,.


Lupa Attachmentnya




وَالسَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ


Warm Regards, On 15/05/2017 16:02, Heri Pamungkas ( Gmail ) wrote:


 السَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ
Semangat pagi,.


hmmm,... coba di explore menggunakan rumus indirect pak.
Sepertinya sih memungkinkan.






وَالسَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ


Warm Regards, On 15/05/2017 11:21, '[hidden email]' [hidden email] [belajar-excel] wrote:

  
Dear all

  mohon bantuan terkait perhitungan average, min, max , stdev, dimana kategori per tanggal, misal apabila ingin mengetahui average dari tanggal sekian ke sekian langsung otomatis perhitungan average dari tanggal yg ditentukan, untuk lebih jelas nya dilampiran..terima  kasih

 Dikirim dari Yahoo Mail di Android



  #yiv7446124089 #yiv7446124089 -- #yiv7446124089ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7446124089 #yiv7446124089ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7446124089 #yiv7446124089ygrp-mkp #yiv7446124089hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7446124089 #yiv7446124089ygrp-mkp #yiv7446124089ads {margin-bottom:10px;}#yiv7446124089 #yiv7446124089ygrp-mkp .yiv7446124089ad {padding:0 0;}#yiv7446124089 #yiv7446124089ygrp-mkp .yiv7446124089ad p {margin:0;}#yiv7446124089 #yiv7446124089ygrp-mkp .yiv7446124089ad a {color:#0000ff;text-decoration:none;}#yiv7446124089 #yiv7446124089ygrp-sponsor #yiv7446124089ygrp-lc {font-family:Arial;}#yiv7446124089 #yiv7446124089ygrp-sponsor #yiv7446124089ygrp-lc #yiv7446124089hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7446124089 #yiv7446124089ygrp-sponsor #yiv7446124089ygrp-lc .yiv7446124089ad {margin-bottom:10px;padding:0 0;}#yiv7446124089 #yiv7446124089actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7446124089 #yiv7446124089activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7446124089 #yiv7446124089activity span {font-weight:700;}#yiv7446124089 #yiv7446124089activity span:first-child {text-transform:uppercase;}#yiv7446124089 #yiv7446124089activity span a {color:#5085b6;text-decoration:none;}#yiv7446124089 #yiv7446124089activity span span {color:#ff7900;}#yiv7446124089 #yiv7446124089activity span .yiv7446124089underline {text-decoration:underline;}#yiv7446124089 .yiv7446124089attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7446124089 .yiv7446124089attach div a {text-decoration:none;}#yiv7446124089 .yiv7446124089attach img {border:none;padding-right:5px;}#yiv7446124089 .yiv7446124089attach label {display:block;margin-bottom:5px;}#yiv7446124089 .yiv7446124089attach label a {text-decoration:none;}#yiv7446124089 blockquote {margin:0 0 0 4px;}#yiv7446124089 .yiv7446124089bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7446124089 .yiv7446124089bold a {text-decoration:none;}#yiv7446124089 dd.yiv7446124089last p a {font-family:Verdana;font-weight:700;}#yiv7446124089 dd.yiv7446124089last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7446124089 dd.yiv7446124089last p span.yiv7446124089yshortcuts {margin-right:0;}#yiv7446124089 div.yiv7446124089attach-table div div a {text-decoration:none;}#yiv7446124089 div.yiv7446124089attach-table {width:400px;}#yiv7446124089 div.yiv7446124089file-title a, #yiv7446124089 div.yiv7446124089file-title a:active, #yiv7446124089 div.yiv7446124089file-title a:hover, #yiv7446124089 div.yiv7446124089file-title a:visited {text-decoration:none;}#yiv7446124089 div.yiv7446124089photo-title a, #yiv7446124089 div.yiv7446124089photo-title a:active, #yiv7446124089 div.yiv7446124089photo-title a:hover, #yiv7446124089 div.yiv7446124089photo-title a:visited {text-decoration:none;}#yiv7446124089 div#yiv7446124089ygrp-mlmsg #yiv7446124089ygrp-msg p a span.yiv7446124089yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7446124089 .yiv7446124089green {color:#628c2a;}#yiv7446124089 .yiv7446124089MsoNormal {margin:0 0 0 0;}#yiv7446124089 o {font-size:0;}#yiv7446124089 #yiv7446124089photos div {float:left;width:72px;}#yiv7446124089 #yiv7446124089photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv7446124089 #yiv7446124089photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7446124089 #yiv7446124089reco-category {font-size:77%;}#yiv7446124089 #yiv7446124089reco-desc {font-size:77%;}#yiv7446124089 .yiv7446124089replbq {margin:4px;}#yiv7446124089 #yiv7446124089ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv7446124089 #yiv7446124089ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7446124089 #yiv7446124089ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7446124089 #yiv7446124089ygrp-mlmsg select, #yiv7446124089 input, #yiv7446124089 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv7446124089 #yiv7446124089ygrp-mlmsg pre, #yiv7446124089 code {font:115% monospace;}#yiv7446124089 #yiv7446124089ygrp-mlmsg * {line-height:1.22em;}#yiv7446124089 #yiv7446124089ygrp-mlmsg #yiv7446124089logo {padding-bottom:10px;}#yiv7446124089 #yiv7446124089ygrp-msg p a {font-family:Verdana;}#yiv7446124089 #yiv7446124089ygrp-msg p#yiv7446124089attach-count span {color:#1E66AE;font-weight:700;}#yiv7446124089 #yiv7446124089ygrp-reco #yiv7446124089reco-head {color:#ff7900;font-weight:700;}#yiv7446124089 #yiv7446124089ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7446124089 #yiv7446124089ygrp-sponsor #yiv7446124089ov li a {font-size:130%;text-decoration:none;}#yiv7446124089 #yiv7446124089ygrp-sponsor #yiv7446124089ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7446124089 #yiv7446124089ygrp-sponsor #yiv7446124089ov ul {margin:0;padding:0 0 0 8px;}#yiv7446124089 #yiv7446124089ygrp-text {font-family:Georgia;}#yiv7446124089 #yiv7446124089ygrp-text p {margin:0 0 1em 0;}#yiv7446124089 #yiv7446124089ygrp-text tt {font-size:120%;}#yiv7446124089 #yiv7446124089ygrp-vital ul li:last-child {border-right:none !important;}#yiv7446124089
Loading...