[belajar-excel] data dengan criteria code no (sama dang berulang) [1 Attachment]

classic Classic list List threaded Threaded
9 messages Options
Reply | Threaded
Open this post in threaded view
|

[belajar-excel] data dengan criteria code no (sama dang berulang) [1 Attachment]

HAIRUL ALAM
Salam Para Master
seperti data terlampirBagaimana caranya agar hasil sheet "hasil2" sama dengansheet "hasil" yang diberi higligh warna biru dan nilai pada cell yang diberiwarna kuning dengan tanpa memberi tanda ( ' ) pada code no yang berulang/sama.mohon solusinya dengan RUMUS & Pivot Table
Terimakasih Banyak
Assalamualaikum
Hairul Alam

=?UTF-8?b?ZGF0YSBkZW5nYW4gY3JpdGVyaWEgY29kZSBubyAoc2FtYSBkYW5nIGJlcnVsYW5nKS54bHN4?= (374K) Download Attachment
Kid
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] data dengan criteria code no (sama dang berulang)

Kid
Administrator
=COUNTIFS(data1!H$5:H$15,$C5&"*",data1!$F$5:$F$15,">0")+COUNTIFS(data1!H$5:H$15,$C5*1,data1!$F$5:$F$15,">0")

On Thu, Oct 17, 2019 at 5:27 PM HAIRUL ALAM [hidden email]
[belajar-excel] <[hidden email]> wrote:

>
>
> Salam Para Master
>
> seperti data terlampir
> Bagaimana caranya agar hasil sheet "hasil2" sama dengan sheet "hasil"
> yang diberi higligh warna biru dan nilai pada cell yang diberi warna kuning
> dengan tanpa memberi tanda ( ' ) pada code no yang berulang/sama. mohon
> solusinya dengan RUMUS & Pivot Table
>
> Terimakasih Banyak
>
> Assalamualaikum
>
> Hairul Alam
>
>
>
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] data dengan criteria code no (sama dang berulang) [1 Attachment]

HAIRUL ALAM
 Salam Mr.Kid
Maaf
Hasil yang diinginkan tidak sama di sheet "hasil1" nilai pada R11 id no 07 misalnya = 4 namun di sheet "hasil2" nilai R11 = 56 id no 07
TerimakasihAssalamualaikum
    Pada Jumat, 18 Oktober 2019 08.58.41 WIB, 'Mr. Kid' [hidden email] [belajar-excel] <[hidden email]> menulis:

  

=COUNTIFS(data1!H$5:H$15,$C5&"*",data1!$F$5:$F$15,">0")+COUNTIFS(data1!H$5:H$15,$C5*1,data1!$F$5:$F$15,">0")

On Thu, Oct 17, 2019 at 5:27 PM HAIRUL ALAM [hidden email] [belajar-excel] <[hidden email]> wrote:

  

Salam Para Master
seperti data terlampirBagaimana caranya agar hasil sheet "hasil2" sama dengansheet "hasil" yang diberi higligh warna biru dan nilai pada cell yang diberiwarna kuning dengan tanpa memberi tanda ( ' ) pada code no yang berulang/sama.mohon solusinya dengan RUMUS & Pivot Table
Terimakasih Banyak
Assalamualaikum
Hairul Alam



  #yiv1509414243 #yiv1509414243 -- #yiv1509414243ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1509414243 #yiv1509414243ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1509414243 #yiv1509414243ygrp-mkp #yiv1509414243hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv1509414243 #yiv1509414243ygrp-mkp #yiv1509414243ads {margin-bottom:10px;}#yiv1509414243 #yiv1509414243ygrp-mkp .yiv1509414243ad {padding:0 0;}#yiv1509414243 #yiv1509414243ygrp-mkp .yiv1509414243ad p {margin:0;}#yiv1509414243 #yiv1509414243ygrp-mkp .yiv1509414243ad a {color:#0000ff;text-decoration:none;}#yiv1509414243 #yiv1509414243ygrp-sponsor #yiv1509414243ygrp-lc {font-family:Arial;}#yiv1509414243 #yiv1509414243ygrp-sponsor #yiv1509414243ygrp-lc #yiv1509414243hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1509414243 #yiv1509414243ygrp-sponsor #yiv1509414243ygrp-lc .yiv1509414243ad {margin-bottom:10px;padding:0 0;}#yiv1509414243 #yiv1509414243actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1509414243 #yiv1509414243activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1509414243 #yiv1509414243activity span {font-weight:700;}#yiv1509414243 #yiv1509414243activity span:first-child {text-transform:uppercase;}#yiv1509414243 #yiv1509414243activity span a {color:#5085b6;text-decoration:none;}#yiv1509414243 #yiv1509414243activity span span {color:#ff7900;}#yiv1509414243 #yiv1509414243activity span .yiv1509414243underline {text-decoration:underline;}#yiv1509414243 .yiv1509414243attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv1509414243 .yiv1509414243attach div a {text-decoration:none;}#yiv1509414243 .yiv1509414243attach img {border:none;padding-right:5px;}#yiv1509414243 .yiv1509414243attach label {display:block;margin-bottom:5px;}#yiv1509414243 .yiv1509414243attach label a {text-decoration:none;}#yiv1509414243 blockquote {margin:0 0 0 4px;}#yiv1509414243 .yiv1509414243bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv1509414243 .yiv1509414243bold a {text-decoration:none;}#yiv1509414243 dd.yiv1509414243last p a {font-family:Verdana;font-weight:700;}#yiv1509414243 dd.yiv1509414243last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1509414243 dd.yiv1509414243last p span.yiv1509414243yshortcuts {margin-right:0;}#yiv1509414243 div.yiv1509414243attach-table div div a {text-decoration:none;}#yiv1509414243 div.yiv1509414243attach-table {width:400px;}#yiv1509414243 div.yiv1509414243file-title a, #yiv1509414243 div.yiv1509414243file-title a:active, #yiv1509414243 div.yiv1509414243file-title a:hover, #yiv1509414243 div.yiv1509414243file-title a:visited {text-decoration:none;}#yiv1509414243 div.yiv1509414243photo-title a, #yiv1509414243 div.yiv1509414243photo-title a:active, #yiv1509414243 div.yiv1509414243photo-title a:hover, #yiv1509414243 div.yiv1509414243photo-title a:visited {text-decoration:none;}#yiv1509414243 div#yiv1509414243ygrp-mlmsg #yiv1509414243ygrp-msg p a span.yiv1509414243yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1509414243 .yiv1509414243green {color:#628c2a;}#yiv1509414243 .yiv1509414243MsoNormal {margin:0 0 0 0;}#yiv1509414243 o {font-size:0;}#yiv1509414243 #yiv1509414243photos div {float:left;width:72px;}#yiv1509414243 #yiv1509414243photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv1509414243 #yiv1509414243photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1509414243 #yiv1509414243reco-category {font-size:77%;}#yiv1509414243 #yiv1509414243reco-desc {font-size:77%;}#yiv1509414243 .yiv1509414243replbq {margin:4px;}#yiv1509414243 #yiv1509414243ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv1509414243 #yiv1509414243ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1509414243 #yiv1509414243ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1509414243 #yiv1509414243ygrp-mlmsg select, #yiv1509414243 input, #yiv1509414243 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv1509414243 #yiv1509414243ygrp-mlmsg pre, #yiv1509414243 code {font:115% monospace;}#yiv1509414243 #yiv1509414243ygrp-mlmsg * {line-height:1.22em;}#yiv1509414243 #yiv1509414243ygrp-mlmsg #yiv1509414243logo {padding-bottom:10px;}#yiv1509414243 #yiv1509414243ygrp-msg p a {font-family:Verdana;}#yiv1509414243 #yiv1509414243ygrp-msg p#yiv1509414243attach-count span {color:#1E66AE;font-weight:700;}#yiv1509414243 #yiv1509414243ygrp-reco #yiv1509414243reco-head {color:#ff7900;font-weight:700;}#yiv1509414243 #yiv1509414243ygrp-reco {margin-bottom:20px;padding:0px;}#yiv1509414243 #yiv1509414243ygrp-sponsor #yiv1509414243ov li a {font-size:130%;text-decoration:none;}#yiv1509414243 #yiv1509414243ygrp-sponsor #yiv1509414243ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv1509414243 #yiv1509414243ygrp-sponsor #yiv1509414243ov ul {margin:0;padding:0 0 0 8px;}#yiv1509414243 #yiv1509414243ygrp-text {font-family:Georgia;}#yiv1509414243 #yiv1509414243ygrp-text p {margin:0 0 1em 0;}#yiv1509414243 #yiv1509414243ygrp-text tt {font-size:120%;}#yiv1509414243 #yiv1509414243ygrp-vital ul li:last-child {border-right:none !important;}#yiv1509414243

=?UTF-8?b?aGFzaWwgZGVuZ2FuIGNyaXRlcmlhIGNvZGUgbm8geWFuZyBiZXJ1bGFuZy54bHN4?= (292K) Download Attachment
Kid
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] data dengan criteria code no (sama dang berulang)

Kid
Administrator
Yup,
Karena entry datanya tidak konsisten.
Entry data yang konsisten itu, untuk kasus Anda, begini :
entry 16 akan diketik 1 lalu 6 lalu enter.
entry 16' akan diketik 1 lalu 6 lalu ' lalu enter.

Jadi, yang tanpa ' harusnya hasil entry bertipe numerik
Sedang yang diakhiri ' akan bertipe text.







On Fri, Oct 18, 2019 at 10:28 AM HAIRUL ALAM [hidden email]
[belajar-excel] <[hidden email]> wrote:

>
>
> Salam Mr.Kid
>
> Maaf
>
> Hasil yang diinginkan tidak sama di sheet "hasil1" nilai pada R11 id no 07
> misalnya = 4 namun di sheet "hasil2" nilai R11 = 56 id no 07
>
> Terimakasih
> Assalamualaikum
>
> Pada Jumat, 18 Oktober 2019 08.58.41 WIB, 'Mr. Kid' [hidden email]
> [belajar-excel] <[hidden email]> menulis:
>
>
>
>
>
> =COUNTIFS(data1!H$5:H$15,$C5&"*",data1!$F$5:$F$15,">0")+COUNTIFS(data1!H$5:H$15,$C5*1,data1!$F$5:$F$15,">0")
>
> On Thu, Oct 17, 2019 at 5:27 PM HAIRUL ALAM [hidden email]
> [belajar-excel] <[hidden email]> wrote:
>
>
>
> Salam Para Master
>
> seperti data terlampir
> Bagaimana caranya agar hasil sheet "hasil2" sama dengan sheet "hasil"
> yang diberi higligh warna biru dan nilai pada cell yang diberi warna kuning
> dengan tanpa memberi tanda ( ' ) pada code no yang berulang/sama. mohon
> solusinya dengan RUMUS & Pivot Table
>
> Terimakasih Banyak
>
> Assalamualaikum
>
> Hairul Alam
>
>
>
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] data dengan criteria code no (sama dang berulang) [1 Attachment]

HAIRUL ALAM
 Salam Mr.Kid
Bagaimana agar hasilnya sama dengan sheet "hasil1" tapi menggunakan data dari sheet "data" dan hasil di sheet "hasil2" dengan menggunakan code no. entry numerik seperti data terlampir tapi tetap nilai yang terhitung berdasarkan code no 1 satu kali hitung saja bila diantara range H sd U terdapat code 21 misal maka walaupun range I sd U muncul lagi akan tetap dihitung 1, Terimakasih Banyak Solusinya Master ku
AssalamualaikumHairul Alam    Pada Jumat, 18 Oktober 2019 10.33.17 WIB, 'Mr. Kid' [hidden email] [belajar-excel] <[hidden email]> menulis:

  

Yup,Karena entry datanya tidak konsisten.Entry data yang konsisten itu, untuk kasus Anda, begini :entry 16 akan diketik 1 lalu 6 lalu enter.entry 16' akan diketik 1 lalu 6 lalu ' lalu enter.
Jadi, yang tanpa ' harusnya hasil entry bertipe numerikSedang yang diakhiri ' akan bertipe text.






On Fri, Oct 18, 2019 at 10:28 AM HAIRUL ALAM [hidden email] [belajar-excel] <[hidden email]> wrote:

  

 Salam Mr.Kid
Maaf
Hasil yang diinginkan tidak sama di sheet "hasil1" nilai pada R11 id no 07 misalnya = 4 namun di sheet "hasil2" nilai R11 = 56 id no 07
TerimakasihAssalamualaikum
    Pada Jumat, 18 Oktober 2019 08.58.41 WIB, 'Mr. Kid' mr.nmkid@gmail..com [belajar-excel] <[hidden email]> menulis:

  

=COUNTIFS(data1!H$5:H$15,$C5&"*",data1!$F$5:$F$15,">0")+COUNTIFS(data1!H$5:H$15,$C5*1,data1!$F$5:$F$15,">0")

On Thu, Oct 17, 2019 at 5:27 PM HAIRUL ALAM [hidden email] [belajar-excel] <[hidden email]> wrote:

  

Salam Para Master
seperti data terlampirBagaimana caranya agar hasil sheet "hasil2" sama dengansheet "hasil" yang diberi higligh warna biru dan nilai pada cell yang diberiwarna kuning dengan tanpa memberi tanda ( ' ) pada code no yang berulang/sama.mohon solusinya dengan RUMUS & Pivot Table
Terimakasih Banyak
Assalamualaikum
Hairul Alam






  #yiv9249737910 #yiv9249737910 -- #yiv9249737910ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9249737910 #yiv9249737910ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9249737910 #yiv9249737910ygrp-mkp #yiv9249737910hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv9249737910 #yiv9249737910ygrp-mkp #yiv9249737910ads {margin-bottom:10px;}#yiv9249737910 #yiv9249737910ygrp-mkp .yiv9249737910ad {padding:0 0;}#yiv9249737910 #yiv9249737910ygrp-mkp .yiv9249737910ad p {margin:0;}#yiv9249737910 #yiv9249737910ygrp-mkp .yiv9249737910ad a {color:#0000ff;text-decoration:none;}#yiv9249737910 #yiv9249737910ygrp-sponsor #yiv9249737910ygrp-lc {font-family:Arial;}#yiv9249737910 #yiv9249737910ygrp-sponsor #yiv9249737910ygrp-lc #yiv9249737910hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9249737910 #yiv9249737910ygrp-sponsor #yiv9249737910ygrp-lc .yiv9249737910ad {margin-bottom:10px;padding:0 0;}#yiv9249737910 #yiv9249737910actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9249737910 #yiv9249737910activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9249737910 #yiv9249737910activity span {font-weight:700;}#yiv9249737910 #yiv9249737910activity span:first-child {text-transform:uppercase;}#yiv9249737910 #yiv9249737910activity span a {color:#5085b6;text-decoration:none;}#yiv9249737910 #yiv9249737910activity span span {color:#ff7900;}#yiv9249737910 #yiv9249737910activity span .yiv9249737910underline {text-decoration:underline;}#yiv9249737910 .yiv9249737910attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv9249737910 .yiv9249737910attach div a {text-decoration:none;}#yiv9249737910 .yiv9249737910attach img {border:none;padding-right:5px;}#yiv9249737910 .yiv9249737910attach label {display:block;margin-bottom:5px;}#yiv9249737910 .yiv9249737910attach label a {text-decoration:none;}#yiv9249737910 blockquote {margin:0 0 0 4px;}#yiv9249737910 .yiv9249737910bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv9249737910 .yiv9249737910bold a {text-decoration:none;}#yiv9249737910 dd.yiv9249737910last p a {font-family:Verdana;font-weight:700;}#yiv9249737910 dd.yiv9249737910last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9249737910 dd.yiv9249737910last p span.yiv9249737910yshortcuts {margin-right:0;}#yiv9249737910 div.yiv9249737910attach-table div div a {text-decoration:none;}#yiv9249737910 div...yiv9249737910attach-table {width:400px;}#yiv9249737910 div.yiv9249737910file-title a, #yiv9249737910 div.yiv9249737910file-title a:active, #yiv9249737910 div.yiv9249737910file-title a:hover, #yiv9249737910 div.yiv9249737910file-title a:visited {text-decoration:none;}#yiv9249737910 div.yiv9249737910photo-title a, #yiv9249737910 div.yiv9249737910photo-title a:active, #yiv9249737910 div.yiv9249737910photo-title a:hover, #yiv9249737910 div.yiv9249737910photo-title a:visited {text-decoration:none;}#yiv9249737910 div#yiv9249737910ygrp-mlmsg #yiv9249737910ygrp-msg p a span.yiv9249737910yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9249737910 .yiv9249737910green {color:#628c2a;}#yiv9249737910 .yiv9249737910MsoNormal {margin:0 0 0 0;}#yiv9249737910 o {font-size:0;}#yiv9249737910 #yiv9249737910photos div {float:left;width:72px;}#yiv9249737910 #yiv9249737910photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv9249737910 #yiv9249737910photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9249737910 #yiv9249737910reco-category {font-size:77%;}#yiv9249737910 #yiv9249737910reco-desc {font-size:77%;}#yiv9249737910 .yiv9249737910replbq {margin:4px;}#yiv9249737910 #yiv9249737910ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv9249737910 #yiv9249737910ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9249737910 #yiv9249737910ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9249737910 #yiv9249737910ygrp-mlmsg select, #yiv9249737910 input, #yiv9249737910 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv9249737910 #yiv9249737910ygrp-mlmsg pre, #yiv9249737910 code {font:115% monospace;}#yiv9249737910 #yiv9249737910ygrp-mlmsg * {line-height:1.22em;}#yiv9249737910 #yiv9249737910ygrp-mlmsg #yiv9249737910logo {padding-bottom:10px;}#yiv9249737910 #yiv9249737910ygrp-msg p a {font-family:Verdana;}#yiv9249737910 #yiv9249737910ygrp-msg p#yiv9249737910attach-count span {color:#1E66AE;font-weight:700;}#yiv9249737910 #yiv9249737910ygrp-reco #yiv9249737910reco-head {color:#ff7900;font-weight:700;}#yiv9249737910 #yiv9249737910ygrp-reco {margin-bottom:20px;padding:0px;}#yiv9249737910 #yiv9249737910ygrp-sponsor #yiv9249737910ov li a {font-size:130%;text-decoration:none;}#yiv9249737910 #yiv9249737910ygrp-sponsor #yiv9249737910ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv9249737910 #yiv9249737910ygrp-sponsor #yiv9249737910ov ul {margin:0;padding:0 0 0 8px;}#yiv9249737910 #yiv9249737910ygrp-text {font-family:Georgia;}#yiv9249737910 #yiv9249737910ygrp-text p {margin:0 0 1em 0;}#yiv9249737910 #yiv9249737910ygrp-text tt {font-size:120%;}#yiv9249737910 #yiv9249737910ygrp-vital ul li:last-child {border-right:none !important;}#yiv9249737910

=?UTF-8?b?aGFzaWwgZGVuZ2FuIGNyaXRlcmlhIGNvZGUgbm8geWFuZyBiZXJ1bGFuZy54bHN4?= (292K) Download Attachment
Kid
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] data dengan criteria code no (sama dang berulang)

Kid
Administrator
Sertaan contoh hasil manualnya saja dulu (tanpa formula sama sekali)

On Fri, Oct 18, 2019 at 10:57 AM HAIRUL ALAM [hidden email]
[belajar-excel] <[hidden email]> wrote:

>
>
> Salam Mr.Kid
>
> Bagaimana agar hasilnya sama dengan sheet "hasil1" tapi menggunakan data
> dari sheet "data" dan hasil di sheet "hasil2" dengan menggunakan code no.
> entry numerik seperti data terlampir tapi tetap nilai yang terhitung
> berdasarkan code no 1 satu kali hitung saja bila diantara range H sd U
> terdapat code 21 misal maka walaupun range I sd U muncul lagi akan tetap
> dihitung 1, Terimakasih Banyak Solusinya Master ku
>
> Assalamualaikum
> Hairul Alam
> Pada Jumat, 18 Oktober 2019 10..33.17 WIB, 'Mr. Kid' [hidden email]
> [belajar-excel] <[hidden email]> menulis:
>
>
>
>
> Yup,
> Karena entry datanya tidak konsisten.
> Entry data yang konsisten itu, untuk kasus Anda, begini :
> entry 16 akan diketik 1 lalu 6 lalu enter.
> entry 16' akan diketik 1 lalu 6 lalu ' lalu enter.
>
> Jadi, yang tanpa ' harusnya hasil entry bertipe numerik
> Sedang yang diakhiri ' akan bertipe text.
>
>
>
>
>
>
>
> On Fri, Oct 18, 2019 at 10:28 AM HAIRUL ALAM [hidden email]
> <[hidden email]..id> [belajar-excel] <[hidden email]>
> wrote:
>
>
>
> Salam Mr.Kid
>
> Maaf
>
> Hasil yang diinginkan tidak sama di sheet "hasil1" nilai pada R11 id no 07
> misalnya = 4 namun di sheet "hasil2" nilai R11 = 56 id no 07
>
> Terimakasih
> Assalamualaikum
>
> Pada Jumat, 18 Oktober 2019 08.58.41 WIB, 'Mr. Kid' mr.nmkid@gmail...com
> <[hidden email]> [belajar-excel] <[hidden email]>
> menulis:
>
>
>
>
>
> =COUNTIFS(data1!H$5:H$15,$C5&"*",data1!$F$5:$F$15,">0")+COUNTIFS(data1!H$5:H$15,$C5*1,data1!$F$5:$F$15,">0")
>
> On Thu, Oct 17, 2019 at 5:27 PM HAIRUL ALAM [hidden email]
> [belajar-excel] <[hidden email]> wrote:
>
>
>
> Salam Para Master
>
> seperti data terlampir
> Bagaimana caranya agar hasil sheet "hasil2" sama dengan sheet "hasil"
> yang diberi higligh warna biru dan nilai pada cell yang diberi warna kuning
> dengan tanpa memberi tanda ( ' ) pada code no yang berulang/sama. mohon
> solusinya dengan RUMUS & Pivot Table
>
> Terimakasih Banyak
>
> Assalamualaikum
>
> Hairul Alam
>
>
>
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] data dengan criteria code no (sama dang berulang) [1 Attachment]

HAIRUL ALAM
 Salam Mr.Kid
data yang dimaksud terlampir
Terimakasih banyak master
Assalamualaikum
    Pada Jumat, 18 Oktober 2019 10.59.21 WIB, 'Mr. Kid' [hidden email] [belajar-excel] <[hidden email]> menulis:

  

Sertaan contoh hasil manualnya saja dulu (tanpa formula sama sekali)
On Fri, Oct 18, 2019 at 10:57 AM HAIRUL ALAM [hidden email] [belajar-excel] <[hidden email]> wrote:

  

 Salam Mr.Kid
Bagaimana agar hasilnya sama dengan sheet "hasil1" tapi menggunakan data dari sheet "data" dan hasil di sheet "hasil2" dengan menggunakan code no. entry numerik seperti data terlampir tapi tetap nilai yang terhitung berdasarkan code no 1 satu kali hitung saja bila diantara range H sd U terdapat code 21 misal maka walaupun range I sd U muncul lagi akan tetap dihitung 1, Terimakasih Banyak Solusinya Master ku
AssalamualaikumHairul Alam    Pada Jumat, 18 Oktober 2019 10..33.17 WIB, 'Mr. Kid' [hidden email] [belajar-excel] <[hidden email]> menulis:

  

Yup,Karena entry datanya tidak konsisten..Entry data yang konsisten itu, untuk kasus Anda, begini :entry 16 akan diketik 1 lalu 6 lalu enter.entry 16' akan diketik 1 lalu 6 lalu ' lalu enter.
Jadi, yang tanpa ' harusnya hasil entry bertipe numerikSedang yang diakhiri ' akan bertipe text.






On Fri, Oct 18, 2019 at 10:28 AM HAIRUL ALAM [hidden email] [belajar-excel] <[hidden email]> wrote:

  

 Salam Mr.Kid
Maaf
Hasil yang diinginkan tidak sama di sheet "hasil1" nilai pada R11 id no 07 misalnya = 4 namun di sheet "hasil2" nilai R11 = 56 id no 07
TerimakasihAssalamualaikum
    Pada Jumat, 18 Oktober 2019 08.58.41 WIB, 'Mr. Kid' mr.nmkid@gmail...com [belajar-excel] <[hidden email]> menulis:

  

=COUNTIFS(data1!H$5:H$15,$C5&"*",data1!$F$5:$F$15,">0")+COUNTIFS(data1!H$5:H$15,$C5*1,data1!$F$5:$F$15,">0")

On Thu, Oct 17, 2019 at 5:27 PM HAIRUL ALAM [hidden email] [belajar-excel] <[hidden email]> wrote:

  

Salam Para Master
seperti data terlampirBagaimana caranya agar hasil sheet "hasil2" sama dengansheet "hasil" yang diberi higligh warna biru dan nilai pada cell yang diberiwarna kuning dengan tanpa memberi tanda ( ' ) pada code no yang berulang/sama.mohon solusinya dengan RUMUS & Pivot Table
Terimakasih Banyak
Assalamualaikum
Hairul Alam









  #yiv6846826734 #yiv6846826734 -- #yiv6846826734ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6846826734 #yiv6846826734ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6846826734 #yiv6846826734ygrp-mkp #yiv6846826734hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv6846826734 #yiv6846826734ygrp-mkp #yiv6846826734ads {margin-bottom:10px;}#yiv6846826734 #yiv6846826734ygrp-mkp .yiv6846826734ad {padding:0 0;}#yiv6846826734 #yiv6846826734ygrp-mkp .yiv6846826734ad p {margin:0;}#yiv6846826734 #yiv6846826734ygrp-mkp .yiv6846826734ad a {color:#0000ff;text-decoration:none;}#yiv6846826734 #yiv6846826734ygrp-sponsor #yiv6846826734ygrp-lc {font-family:Arial;}#yiv6846826734 #yiv6846826734ygrp-sponsor #yiv6846826734ygrp-lc #yiv6846826734hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6846826734 #yiv6846826734ygrp-sponsor #yiv6846826734ygrp-lc .yiv6846826734ad {margin-bottom:10px;padding:0 0;}#yiv6846826734 #yiv6846826734actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6846826734 #yiv6846826734activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6846826734 #yiv6846826734activity span {font-weight:700;}#yiv6846826734 #yiv6846826734activity span:first-child {text-transform:uppercase;}#yiv6846826734 #yiv6846826734activity span a {color:#5085b6;text-decoration:none;}#yiv6846826734 #yiv6846826734activity span span {color:#ff7900;}#yiv6846826734 #yiv6846826734activity span .yiv6846826734underline {text-decoration:underline;}#yiv6846826734 .yiv6846826734attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv6846826734 .yiv6846826734attach div a {text-decoration:none;}#yiv6846826734 .yiv6846826734attach img {border:none;padding-right:5px;}#yiv6846826734 .yiv6846826734attach label {display:block;margin-bottom:5px;}#yiv6846826734 .yiv6846826734attach label a {text-decoration:none;}#yiv6846826734 blockquote {margin:0 0 0 4px;}#yiv6846826734 .yiv6846826734bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv6846826734 .yiv6846826734bold a {text-decoration:none;}#yiv6846826734 dd.yiv6846826734last p a {font-family:Verdana;font-weight:700;}#yiv6846826734 dd.yiv6846826734last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6846826734 dd.yiv6846826734last p span.yiv6846826734yshortcuts {margin-right:0;}#yiv6846826734 div.yiv6846826734attach-table div div a {text-decoration:none;}#yiv6846826734 div...yiv6846826734attach-table {width:400px;}#yiv6846826734 div.yiv6846826734file-title a, #yiv6846826734 div.yiv6846826734file-title a:active, #yiv6846826734 div.yiv6846826734file-title a:hover, #yiv6846826734 div.yiv6846826734file-title a:visited {text-decoration:none;}#yiv6846826734 div.yiv6846826734photo-title a, #yiv6846826734 div.yiv6846826734photo-title a:active, #yiv6846826734 div.yiv6846826734photo-title a:hover, #yiv6846826734 div.yiv6846826734photo-title a:visited {text-decoration:none;}#yiv6846826734 div#yiv6846826734ygrp-mlmsg #yiv6846826734ygrp-msg p a span.yiv6846826734yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6846826734 .yiv6846826734green {color:#628c2a;}#yiv6846826734 .yiv6846826734MsoNormal {margin:0 0 0 0;}#yiv6846826734 o {font-size:0;}#yiv6846826734 #yiv6846826734photos div {float:left;width:72px;}#yiv6846826734 #yiv6846826734photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv6846826734 #yiv6846826734photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6846826734 #yiv6846826734reco-category {font-size:77%;}#yiv6846826734 #yiv6846826734reco-desc {font-size:77%;}#yiv6846826734 .yiv6846826734replbq {margin:4px;}#yiv6846826734 #yiv6846826734ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv6846826734 #yiv6846826734ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6846826734 #yiv6846826734ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6846826734 #yiv6846826734ygrp-mlmsg select, #yiv6846826734 input, #yiv6846826734 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv6846826734 #yiv6846826734ygrp-mlmsg pre, #yiv6846826734 code {font:115% monospace;}#yiv6846826734 #yiv6846826734ygrp-mlmsg * {line-height:1.22em;}#yiv6846826734 #yiv6846826734ygrp-mlmsg #yiv6846826734logo {padding-bottom:10px;}#yiv6846826734 #yiv6846826734ygrp-msg p a {font-family:Verdana;}#yiv6846826734 #yiv6846826734ygrp-msg p#yiv6846826734attach-count span {color:#1E66AE;font-weight:700;}#yiv6846826734 #yiv6846826734ygrp-reco #yiv6846826734reco-head {color:#ff7900;font-weight:700;}#yiv6846826734 #yiv6846826734ygrp-reco {margin-bottom:20px;padding:0px;}#yiv6846826734 #yiv6846826734ygrp-sponsor #yiv6846826734ov li a {font-size:130%;text-decoration:none;}#yiv6846826734 #yiv6846826734ygrp-sponsor #yiv6846826734ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv6846826734 #yiv6846826734ygrp-sponsor #yiv6846826734ov ul {margin:0;padding:0 0 0 8px;}#yiv6846826734 #yiv6846826734ygrp-text {font-family:Georgia;}#yiv6846826734 #yiv6846826734ygrp-text p {margin:0 0 1em 0;}#yiv6846826734 #yiv6846826734ygrp-text tt {font-size:120%;}#yiv6846826734 #yiv6846826734ygrp-vital ul li:last-child {border-right:none !important;}#yiv6846826734

=?UTF-8?b?aGFzaWwgZGVuZ2FuIGNyaXRlcmlhIGNvZGUgbm8geWFuZyBiZXJ1bGFuZzIueGxzeA==?= (278K) Download Attachment
Kid
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] data dengan criteria code no (sama dang berulang)

Kid
Administrator
[image: contoh.JPG]
Begitu bukan ?



On Fri, Oct 18, 2019 at 11:09 AM HAIRUL ALAM [hidden email]
[belajar-excel] <[hidden email]> wrote:

>
>
> Salam Mr.Kid
>
> data yang dimaksud terlampir
>
> Terimakasih banyak master
>
> Assalamualaikum
>
> Pada Jumat, 18 Oktober 2019 10.59.21 WIB, 'Mr.. Kid' [hidden email]
> [belajar-excel] <[hidden email]> menulis:
>
>
>
>
> Sertaan contoh hasil manualnya saja dulu (tanpa formula sama sekali)
>
> On Fri, Oct 18, 2019 at 10:57 AM HAIRUL ALAM [hidden email]
> [belajar-excel] <[hidden email]> wrote:
>
>
>
> Salam Mr.Kid
>
> Bagaimana agar hasilnya sama dengan sheet "hasil1" tapi menggunakan data
> dari sheet "data" dan hasil di sheet "hasil2" dengan menggunakan code no.
> entry numerik seperti data terlampir tapi tetap nilai yang terhitung
> berdasarkan code no 1 satu kali hitung saja bila diantara range H sd U
> terdapat code 21 misal maka walaupun range I sd U muncul lagi akan tetap
> dihitung 1, Terimakasih Banyak Solusinya Master ku
>
> Assalamualaikum
> Hairul Alam
> Pada Jumat, 18 Oktober 2019 10..33.17 WIB, 'Mr. Kid' [hidden email]
> [belajar-excel] <[hidden email]> menulis:
>
>
>
>
> Yup,
> Karena entry datanya tidak konsisten..
> Entry data yang konsisten itu, untuk kasus Anda, begini :
> entry 16 akan diketik 1 lalu 6 lalu enter.
> entry 16' akan diketik 1 lalu 6 lalu ' lalu enter.
>
> Jadi, yang tanpa ' harusnya hasil entry bertipe numerik
> Sedang yang diakhiri ' akan bertipe text.
>
>
>
>
>
>
>
> On Fri, Oct 18, 2019 at 10:28 AM HAIRUL ALAM [hidden email]
> <[hidden email]..id> [belajar-excel] <[hidden email]>
> wrote:
>
>
>
> Salam Mr.Kid
>
> Maaf
>
> Hasil yang diinginkan tidak sama di sheet "hasil1" nilai pada R11 id no 07
> misalnya = 4 namun di sheet "hasil2" nilai R11 = 56 id no 07
>
> Terimakasih
> Assalamualaikum
>
> Pada Jumat, 18 Oktober 2019 08.58.41 WIB, 'Mr. Kid' mr.nmkid@gmail...com
> <[hidden email]> [belajar-excel] <[hidden email]>
> menulis:
>
>
>
>
>
> =COUNTIFS(data1!H$5:H$15,$C5&"*",data1!$F$5:$F$15,">0")+COUNTIFS(data1!H$5:H$15,$C5*1,data1!$F$5:$F$15,">0")
>
> On Thu, Oct 17, 2019 at 5:27 PM HAIRUL ALAM [hidden email]
> [belajar-excel] <[hidden email]> wrote:
>
>
>
> Salam Para Master
>
> seperti data terlampir
> Bagaimana caranya agar hasil sheet "hasil2" sama dengan sheet "hasil"
> yang diberi higligh warna biru dan nilai pada cell yang diberi warna kuning
> dengan tanpa memberi tanda ( ' ) pada code no yang berulang/sama. mohon
> solusinya dengan RUMUS & Pivot Table
>
> Terimakasih Banyak
>
> Assalamualaikum
>
> Hairul Alam
>
>
>

contoh.JPG (116K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] data dengan criteria code no (sama dang berulang) [1 Attachment]

HAIRUL ALAM
 Salam Mr.Kid
Terimakasih Pak, bukan seperti itu yang dimaksud, bila kode no kolom 1,2 misal 06/07 dan kolom 3 sd berikutnya muncul lagi kode tersebut maka di hasil terisi hanya kolom 1,2 untuk 06/07 nilai 1 dan kolom 3 sd seterunya nilai tidak terulang begitu berikutnya bila di beberapa kolom misal 1,2,3,4 di 1=06, 2= 07, 3=20, 4=33 misalnya muncul lagi di kolom 5,6,7,8 dengan kode sama dengan kolom 1,2,3,4 maka hasil nilai yang dihitung cuma 1,2,3,4 dan yang 5,6,7,8 menjadi 0 karena kode no di 1,2,3,4 sudah ada, begitu kira Master Ku, Terimakasih Banyak
AssalamualaikumHairul Alam
    Pada Jumat, 18 Oktober 2019 11.14.48 WIB, 'Mr. Kid' [hidden email] [belajar-excel] <[hidden email]> menulis:

  


Begitu bukan ?


On Fri, Oct 18, 2019 at 11:09 AM HAIRUL ALAM [hidden email] [belajar-excel] <[hidden email]> wrote:

  

 Salam Mr.Kid
data yang dimaksud terlampir
Terimakasih banyak master
Assalamualaikum
    Pada Jumat, 18 Oktober 2019 10.59.21 WIB, 'Mr.. Kid' [hidden email] [belajar-excel] <[hidden email]> menulis:

  

Sertaan contoh hasil manualnya saja dulu (tanpa formula sama sekali)
On Fri, Oct 18, 2019 at 10:57 AM HAIRUL ALAM [hidden email] [belajar-excel] <[hidden email]> wrote:

  

 Salam Mr.Kid
Bagaimana agar hasilnya sama dengan sheet "hasil1" tapi menggunakan data dari sheet "data" dan hasil di sheet "hasil2" dengan menggunakan code no. entry numerik seperti data terlampir tapi tetap nilai yang terhitung berdasarkan code no 1 satu kali hitung saja bila diantara range H sd U terdapat code 21 misal maka walaupun range I sd U muncul lagi akan tetap dihitung 1, Terimakasih Banyak Solusinya Master ku
AssalamualaikumHairul Alam    Pada Jumat, 18 Oktober 2019 10..33.17 WIB, 'Mr. Kid' [hidden email] [belajar-excel] <[hidden email]> menulis:

  

Yup,Karena entry datanya tidak konsisten...Entry data yang konsisten itu, untuk kasus Anda, begini :entry 16 akan diketik 1 lalu 6 lalu enter.entry 16' akan diketik 1 lalu 6 lalu ' lalu enter.
Jadi, yang tanpa ' harusnya hasil entry bertipe numerikSedang yang diakhiri ' akan bertipe text.






On Fri, Oct 18, 2019 at 10:28 AM HAIRUL ALAM [hidden email] [belajar-excel] <[hidden email]> wrote:

  

 Salam Mr.Kid
Maaf
Hasil yang diinginkan tidak sama di sheet "hasil1" nilai pada R11 id no 07 misalnya = 4 namun di sheet "hasil2" nilai R11 = 56 id no 07
TerimakasihAssalamualaikum
    Pada Jumat, 18 Oktober 2019 08.58.41 WIB, 'Mr. Kid' mr.nmkid@gmail...com [belajar-excel] <[hidden email]> menulis:

  

=COUNTIFS(data1!H$5:H$15,$C5&"*",data1!$F$5:$F$15,">0")+COUNTIFS(data1!H$5:H$15,$C5*1,data1!$F$5:$F$15,">0")

On Thu, Oct 17, 2019 at 5:27 PM HAIRUL ALAM [hidden email] [belajar-excel] <[hidden email]> wrote:

  

Salam Para Master
seperti data terlampirBagaimana caranya agar hasil sheet "hasil2" sama dengansheet "hasil" yang diberi higligh warna biru dan nilai pada cell yang diberiwarna kuning dengan tanpa memberi tanda ( ' ) pada code no yang berulang/sama.mohon solusinya dengan RUMUS & Pivot Table
Terimakasih Banyak
Assalamualaikum
Hairul Alam












  #yiv7452990971 #yiv7452990971 -- #yiv7452990971ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7452990971 #yiv7452990971ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7452990971 #yiv7452990971ygrp-mkp #yiv7452990971hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7452990971 #yiv7452990971ygrp-mkp #yiv7452990971ads {margin-bottom:10px;}#yiv7452990971 #yiv7452990971ygrp-mkp .yiv7452990971ad {padding:0 0;}#yiv7452990971 #yiv7452990971ygrp-mkp .yiv7452990971ad p {margin:0;}#yiv7452990971 #yiv7452990971ygrp-mkp .yiv7452990971ad a {color:#0000ff;text-decoration:none;}#yiv7452990971 #yiv7452990971ygrp-sponsor #yiv7452990971ygrp-lc {font-family:Arial;}#yiv7452990971 #yiv7452990971ygrp-sponsor #yiv7452990971ygrp-lc #yiv7452990971hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7452990971 #yiv7452990971ygrp-sponsor #yiv7452990971ygrp-lc .yiv7452990971ad {margin-bottom:10px;padding:0 0;}#yiv7452990971 #yiv7452990971actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7452990971 #yiv7452990971activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7452990971 #yiv7452990971activity span {font-weight:700;}#yiv7452990971 #yiv7452990971activity span:first-child {text-transform:uppercase;}#yiv7452990971 #yiv7452990971activity span a {color:#5085b6;text-decoration:none;}#yiv7452990971 #yiv7452990971activity span span {color:#ff7900;}#yiv7452990971 #yiv7452990971activity span .yiv7452990971underline {text-decoration:underline;}#yiv7452990971 .yiv7452990971attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7452990971 .yiv7452990971attach div a {text-decoration:none;}#yiv7452990971 .yiv7452990971attach img {border:none;padding-right:5px;}#yiv7452990971 .yiv7452990971attach label {display:block;margin-bottom:5px;}#yiv7452990971 .yiv7452990971attach label a {text-decoration:none;}#yiv7452990971 blockquote {margin:0 0 0 4px;}#yiv7452990971 .yiv7452990971bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7452990971 .yiv7452990971bold a {text-decoration:none;}#yiv7452990971 dd.yiv7452990971last p a {font-family:Verdana;font-weight:700;}#yiv7452990971 dd.yiv7452990971last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7452990971 dd.yiv7452990971last p span.yiv7452990971yshortcuts {margin-right:0;}#yiv7452990971 div.yiv7452990971attach-table div div a {text-decoration:none;}#yiv7452990971 div.yiv7452990971attach-table {width:400px;}#yiv7452990971 div.yiv7452990971file-title a, #yiv7452990971 div.yiv7452990971file-title a:active, #yiv7452990971 div.yiv7452990971file-title a:hover, #yiv7452990971 div.yiv7452990971file-title a:visited {text-decoration:none;}#yiv7452990971 div.yiv7452990971photo-title a, #yiv7452990971 div.yiv7452990971photo-title a:active, #yiv7452990971 div.yiv7452990971photo-title a:hover, #yiv7452990971 div...yiv7452990971photo-title a:visited {text-decoration:none;}#yiv7452990971 div#yiv7452990971ygrp-mlmsg #yiv7452990971ygrp-msg p a span.yiv7452990971yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7452990971 .yiv7452990971green {color:#628c2a;}#yiv7452990971 .yiv7452990971MsoNormal {margin:0 0 0 0;}#yiv7452990971 o {font-size:0;}#yiv7452990971 #yiv7452990971photos div {float:left;width:72px;}#yiv7452990971 #yiv7452990971photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv7452990971 #yiv7452990971photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7452990971 #yiv7452990971reco-category {font-size:77%;}#yiv7452990971 #yiv7452990971reco-desc {font-size:77%;}#yiv7452990971 .yiv7452990971replbq {margin:4px;}#yiv7452990971 #yiv7452990971ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv7452990971 #yiv7452990971ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7452990971 #yiv7452990971ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7452990971 #yiv7452990971ygrp-mlmsg select, #yiv7452990971 input, #yiv7452990971 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv7452990971 #yiv7452990971ygrp-mlmsg pre, #yiv7452990971 code {font:115% monospace;}#yiv7452990971 #yiv7452990971ygrp-mlmsg * {line-height:1.22em;}#yiv7452990971 #yiv7452990971ygrp-mlmsg #yiv7452990971logo {padding-bottom:10px;}#yiv7452990971 #yiv7452990971ygrp-msg p a {font-family:Verdana;}#yiv7452990971 #yiv7452990971ygrp-msg p#yiv7452990971attach-count span {color:#1E66AE;font-weight:700;}#yiv7452990971 #yiv7452990971ygrp-reco #yiv7452990971reco-head {color:#ff7900;font-weight:700;}#yiv7452990971 #yiv7452990971ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7452990971 #yiv7452990971ygrp-sponsor #yiv7452990971ov li a {font-size:130%;text-decoration:none;}#yiv7452990971 #yiv7452990971ygrp-sponsor #yiv7452990971ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7452990971 #yiv7452990971ygrp-sponsor #yiv7452990971ov ul {margin:0;padding:0 0 0 8px;}#yiv7452990971 #yiv7452990971ygrp-text {font-family:Georgia;}#yiv7452990971 #yiv7452990971ygrp-text p {margin:0 0 1em 0;}#yiv7452990971 #yiv7452990971ygrp-text tt {font-size:120%;}#yiv7452990971 #yiv7452990971ygrp-vital ul li:last-child {border-right:none !important;}#yiv7452990971

contoh.JPG (116K) Download Attachment