[belajar-excel] Mencari nilai dengan criteria [1 Attachment]

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

[belajar-excel] Mencari nilai dengan criteria [1 Attachment]

HAIRUL ALAM
Salam Rekan - Rekan BeExcel
Rumus apa yang digunakan jika masalah seperti data terlampir ;

jika data pada range C s/d P sepertidiatas, bagaimana rumusnya agar nilai sama seperti kolom Q, rumus apa yangdigunakan COUNTIF atau SUMIF

kolom B no 1 range C s/d P terdapat 2code angka 1 & 2 maka di R 5 nilainya samadengan 2

kolom B no 2 range C s/d P terdapat 4code angka 1,2,3 & 4 maka di R 6 nilainya samadengan 4

kolom B no 3 range C s/d P terdapat 6code angka 1,2,3,4,5 & 6 maka di R 7 nilainya samadengan 6

Terimakasih
AssalmualaikumHairul Alam

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

Re: [belajar-excel] Mencari nilai dengan criteria

hendrik karnadi
 Dear Hairul,Coba ketik di R5 :=MAX(B5:P5)lalu dicopy ke bawah.
Salam,HK


    Pada Rabu, 16 Oktober 2019 14.14.59 GMT+7, HAIRUL ALAM [hidden email]..id [belajar-excel] <[hidden email]> menulis:  
 
    

Salam Rekan - Rekan BeExcel
Rumus apa yang digunakan jika masalah seperti data terlampir ;

jika data pada range C s/d P sepertidiatas, bagaimana rumusnya agar nilai sama seperti kolom Q, rumus apa yangdigunakan COUNTIF atau SUMIF

kolom B no 1 range C s/d P terdapat 2code angka 1 & 2 maka di R 5 nilainya samadengan 2

kolom B no 2 range C s/d P terdapat 4code angka 1,2,3 & 4 maka di R 6 nilainya samadengan 4

kolom B no 3 range C s/d P terdapat 6code angka 1,2,3,4,5 & 6 maka di R 7 nilainya samadengan 6

Terimakasih
AssalmualaikumHairul Alam    
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Mencari nilai dengan criteria

HAIRUL ALAM
 SalamPak Hendrik
Terimakasih banyak simpel tapi sayanya yang tidak mengerti penggunaannya dan sekarang Bisa
AssalamualaikumHairul 
    Pada Rabu, 16 Oktober 2019 14.29.56 WIB, hendrik karnadi [hidden email] [belajar-excel] <[hidden email]> menulis:

  

 Dear Hairul,Coba ketik di R5 :=MAX(B5:P5)lalu dicopy ke bawah.
Salam,HK


    Pada Rabu, 16 Oktober 2019 14.14.59 GMT+7, HAIRUL ALAM [hidden email] [belajar-excel] <[hidden email]> menulis:

  

Salam Rekan - Rekan BeExcel
Rumus apa yang digunakan jika masalah seperti data terlampir ;

jika data pada range C s/d P sepertidiatas, bagaimana rumusnya agar nilai sama seperti kolom Q, rumus apa yangdigunakan COUNTIF atau SUMIF

kolom B no 1 range C s/d P terdapat 2code angka 1 & 2 maka di R 5 nilainya samadengan 2

kolom B no 2 range C s/d P terdapat 4code angka 1,2,3 & 4 maka di R 6 nilainya samadengan 4

kolom B no 3 range C s/d P terdapat 6code angka 1,2,3,4,5 & 6 maka di R 7 nilainya samadengan 6

Terimakasih
AssalmualaikumHairul Alam      #yiv4606899853 #yiv4606899853 -- #yiv4606899853ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4606899853 #yiv4606899853ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4606899853 #yiv4606899853ygrp-mkp #yiv4606899853hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv4606899853 #yiv4606899853ygrp-mkp #yiv4606899853ads {margin-bottom:10px;}#yiv4606899853 #yiv4606899853ygrp-mkp .yiv4606899853ad {padding:0 0;}#yiv4606899853 #yiv4606899853ygrp-mkp .yiv4606899853ad p {margin:0;}#yiv4606899853 #yiv4606899853ygrp-mkp .yiv4606899853ad a {color:#0000ff;text-decoration:none;}#yiv4606899853 #yiv4606899853ygrp-sponsor #yiv4606899853ygrp-lc {font-family:Arial;}#yiv4606899853 #yiv4606899853ygrp-sponsor #yiv4606899853ygrp-lc #yiv4606899853hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4606899853 #yiv4606899853ygrp-sponsor #yiv4606899853ygrp-lc .yiv4606899853ad {margin-bottom:10px;padding:0 0;}#yiv4606899853 #yiv4606899853actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4606899853 #yiv4606899853activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4606899853 #yiv4606899853activity span {font-weight:700;}#yiv4606899853 #yiv4606899853activity span:first-child {text-transform:uppercase;}#yiv4606899853 #yiv4606899853activity span a {color:#5085b6;text-decoration:none;}#yiv4606899853 #yiv4606899853activity span span {color:#ff7900;}#yiv4606899853 #yiv4606899853activity span .yiv4606899853underline {text-decoration:underline;}#yiv4606899853 .yiv4606899853attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv4606899853 .yiv4606899853attach div a {text-decoration:none;}#yiv4606899853 .yiv4606899853attach img {border:none;padding-right:5px;}#yiv4606899853 .yiv4606899853attach label {display:block;margin-bottom:5px;}#yiv4606899853 .yiv4606899853attach label a {text-decoration:none;}#yiv4606899853 blockquote {margin:0 0 0 4px;}#yiv4606899853 .yiv4606899853bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv4606899853 .yiv4606899853bold a {text-decoration:none;}#yiv4606899853 dd.yiv4606899853last p a {font-family:Verdana;font-weight:700;}#yiv4606899853 dd.yiv4606899853last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4606899853 dd.yiv4606899853last p span.yiv4606899853yshortcuts {margin-right:0;}#yiv4606899853 div.yiv4606899853attach-table div div a {text-decoration:none;}#yiv4606899853 div.yiv4606899853attach-table {width:400px;}#yiv4606899853 div.yiv4606899853file-title a, #yiv4606899853 div.yiv4606899853file-title a:active, #yiv4606899853 div.yiv4606899853file-title a:hover, #yiv4606899853 div.yiv4606899853file-title a:visited {text-decoration:none;}#yiv4606899853 div.yiv4606899853photo-title a, #yiv4606899853 div.yiv4606899853photo-title a:active, #yiv4606899853 div.yiv4606899853photo-title a:hover, #yiv4606899853 div.yiv4606899853photo-title a:visited {text-decoration:none;}#yiv4606899853 div#yiv4606899853ygrp-mlmsg #yiv4606899853ygrp-msg p a span.yiv4606899853yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4606899853 .yiv4606899853green {color:#628c2a;}#yiv4606899853 .yiv4606899853MsoNormal {margin:0 0 0 0;}#yiv4606899853 o {font-size:0;}#yiv4606899853 #yiv4606899853photos div {float:left;width:72px;}#yiv4606899853 #yiv4606899853photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv4606899853 #yiv4606899853photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4606899853 #yiv4606899853reco-category {font-size:77%;}#yiv4606899853 #yiv4606899853reco-desc {font-size:77%;}#yiv4606899853 .yiv4606899853replbq {margin:4px;}#yiv4606899853 #yiv4606899853ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv4606899853 #yiv4606899853ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4606899853 #yiv4606899853ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4606899853 #yiv4606899853ygrp-mlmsg select, #yiv4606899853 input, #yiv4606899853 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv4606899853 #yiv4606899853ygrp-mlmsg pre, #yiv4606899853 code {font:115% monospace;}#yiv4606899853 #yiv4606899853ygrp-mlmsg * {line-height:1.22em;}#yiv4606899853 #yiv4606899853ygrp-mlmsg #yiv4606899853logo {padding-bottom:10px;}#yiv4606899853 #yiv4606899853ygrp-msg p a {font-family:Verdana;}#yiv4606899853 #yiv4606899853ygrp-msg p#yiv4606899853attach-count span {color:#1E66AE;font-weight:700;}#yiv4606899853 #yiv4606899853ygrp-reco #yiv4606899853reco-head {color:#ff7900;font-weight:700;}#yiv4606899853 #yiv4606899853ygrp-reco {margin-bottom:20px;padding:0px;}#yiv4606899853 #yiv4606899853ygrp-sponsor #yiv4606899853ov li a {font-size:130%;text-decoration:none;}#yiv4606899853 #yiv4606899853ygrp-sponsor #yiv4606899853ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv4606899853 #yiv4606899853ygrp-sponsor #yiv4606899853ov ul {margin:0;padding:0 0 0 8px;}#yiv4606899853 #yiv4606899853ygrp-text {font-family:Georgia;}#yiv4606899853 #yiv4606899853ygrp-text p {margin:0 0 1em 0;}#yiv4606899853 #yiv4606899853ygrp-text tt {font-size:120%;}#yiv4606899853 #yiv4606899853ygrp-vital ul li:last-child {border-right:none !important;}#yiv4606899853
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Mencari nilai dengan criteria [1 Attachment]

HAIRUL ALAM
In reply to this post by hendrik karnadi
 Salam Pak Hendrik
TerimakasihPak Hendrikuntuk rumus tersebut berfungsi menentukan nilai terbesar, sedangkan yang sayamaksud itu seperti terlampir, jadi berdasarkan jumlah kode yang berbeda Pak

Terimakasih
AssalamualaikumHairul
    Pada Rabu, 16 Oktober 2019 14.29.56 WIB, hendrik karnadi [hidden email] [belajar-excel] <[hidden email]> menulis:
 
  

 Dear Hairul,Coba ketik di R5 :=MAX(B5:P5)lalu dicopy ke bawah.
Salam,HK


    Pada Rabu, 16 Oktober 2019 14.14.59 GMT+7, HAIRUL ALAM [hidden email] [belajar-excel] <[hidden email]> menulis:

  

Salam Rekan - Rekan BeExcel
Rumus apa yang digunakan jika masalah seperti data terlampir ;

jika data pada range C s/d P sepertidiatas, bagaimana rumusnya agar nilai sama seperti kolom Q, rumus apa yangdigunakan COUNTIF atau SUMIF

kolom B no 1 range C s/d P terdapat 2code angka 1 & 2 maka di R 5 nilainya samadengan 2

kolom B no 2 range C s/d P terdapat 4code angka 1,2,3 & 4 maka di R 6 nilainya samadengan 4

kolom B no 3 range C s/d P terdapat 6code angka 1,2,3,4,5 & 6 maka di R 7 nilainya samadengan 6

Terimakasih
AssalmualaikumHairul Alam      #yiv4606899853 #yiv4606899853 -- #yiv4606899853ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4606899853 #yiv4606899853ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4606899853 #yiv4606899853ygrp-mkp #yiv4606899853hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv4606899853 #yiv4606899853ygrp-mkp #yiv4606899853ads {margin-bottom:10px;}#yiv4606899853 #yiv4606899853ygrp-mkp .yiv4606899853ad {padding:0 0;}#yiv4606899853 #yiv4606899853ygrp-mkp .yiv4606899853ad p {margin:0;}#yiv4606899853 #yiv4606899853ygrp-mkp .yiv4606899853ad a {color:#0000ff;text-decoration:none;}#yiv4606899853 #yiv4606899853ygrp-sponsor #yiv4606899853ygrp-lc {font-family:Arial;}#yiv4606899853 #yiv4606899853ygrp-sponsor #yiv4606899853ygrp-lc #yiv4606899853hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4606899853 #yiv4606899853ygrp-sponsor #yiv4606899853ygrp-lc .yiv4606899853ad {margin-bottom:10px;padding:0 0;}#yiv4606899853 #yiv4606899853actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4606899853 #yiv4606899853activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4606899853 #yiv4606899853activity span {font-weight:700;}#yiv4606899853 #yiv4606899853activity span:first-child {text-transform:uppercase;}#yiv4606899853 #yiv4606899853activity span a {color:#5085b6;text-decoration:none;}#yiv4606899853 #yiv4606899853activity span span {color:#ff7900;}#yiv4606899853 #yiv4606899853activity span .yiv4606899853underline {text-decoration:underline;}#yiv4606899853 .yiv4606899853attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv4606899853 .yiv4606899853attach div a {text-decoration:none;}#yiv4606899853 .yiv4606899853attach img {border:none;padding-right:5px;}#yiv4606899853 .yiv4606899853attach label {display:block;margin-bottom:5px;}#yiv4606899853 .yiv4606899853attach label a {text-decoration:none;}#yiv4606899853 blockquote {margin:0 0 0 4px;}#yiv4606899853 .yiv4606899853bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv4606899853 .yiv4606899853bold a {text-decoration:none;}#yiv4606899853 dd.yiv4606899853last p a {font-family:Verdana;font-weight:700;}#yiv4606899853 dd.yiv4606899853last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4606899853 dd.yiv4606899853last p span.yiv4606899853yshortcuts {margin-right:0;}#yiv4606899853 div.yiv4606899853attach-table div div a {text-decoration:none;}#yiv4606899853 div.yiv4606899853attach-table {width:400px;}#yiv4606899853 div.yiv4606899853file-title a, #yiv4606899853 div.yiv4606899853file-title a:active, #yiv4606899853 div.yiv4606899853file-title a:hover, #yiv4606899853 div.yiv4606899853file-title a:visited {text-decoration:none;}#yiv4606899853 div.yiv4606899853photo-title a, #yiv4606899853 div.yiv4606899853photo-title a:active, #yiv4606899853 div.yiv4606899853photo-title a:hover, #yiv4606899853 div.yiv4606899853photo-title a:visited {text-decoration:none;}#yiv4606899853 div#yiv4606899853ygrp-mlmsg #yiv4606899853ygrp-msg p a span.yiv4606899853yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4606899853 .yiv4606899853green {color:#628c2a;}#yiv4606899853 .yiv4606899853MsoNormal {margin:0 0 0 0;}#yiv4606899853 o {font-size:0;}#yiv4606899853 #yiv4606899853photos div {float:left;width:72px;}#yiv4606899853 #yiv4606899853photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv4606899853 #yiv4606899853photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4606899853 #yiv4606899853reco-category {font-size:77%;}#yiv4606899853 #yiv4606899853reco-desc {font-size:77%;}#yiv4606899853 .yiv4606899853replbq {margin:4px;}#yiv4606899853 #yiv4606899853ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv4606899853 #yiv4606899853ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4606899853 #yiv4606899853ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4606899853 #yiv4606899853ygrp-mlmsg select, #yiv4606899853 input, #yiv4606899853 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv4606899853 #yiv4606899853ygrp-mlmsg pre, #yiv4606899853 code {font:115% monospace;}#yiv4606899853 #yiv4606899853ygrp-mlmsg * {line-height:1.22em;}#yiv4606899853 #yiv4606899853ygrp-mlmsg #yiv4606899853logo {padding-bottom:10px;}#yiv4606899853 #yiv4606899853ygrp-msg p a {font-family:Verdana;}#yiv4606899853 #yiv4606899853ygrp-msg p#yiv4606899853attach-count span {color:#1E66AE;font-weight:700;}#yiv4606899853 #yiv4606899853ygrp-reco #yiv4606899853reco-head {color:#ff7900;font-weight:700;}#yiv4606899853 #yiv4606899853ygrp-reco {margin-bottom:20px;padding:0px;}#yiv4606899853 #yiv4606899853ygrp-sponsor #yiv4606899853ov li a {font-size:130%;text-decoration:none;}#yiv4606899853 #yiv4606899853ygrp-sponsor #yiv4606899853ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv4606899853 #yiv4606899853ygrp-sponsor #yiv4606899853ov ul {margin:0;padding:0 0 0 8px;}#yiv4606899853 #yiv4606899853ygrp-text {font-family:Georgia;}#yiv4606899853 #yiv4606899853ygrp-text p {margin:0 0 1em 0;}#yiv4606899853 #yiv4606899853ygrp-text tt {font-size:120%;}#yiv4606899853 #yiv4606899853ygrp-vital ul li:last-child {border-right:none !important;}#yiv4606899853

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

Re: [belajar-excel] Mencari nilai dengan criteria

Kid
Administrator
=SUMPRODUCT(1*(MATCH(C5:P5,C5:P5,0)=COLUMN(C5:P5)-COLUMN(B5)))

On Wed, Oct 16, 2019 at 5:45 PM HAIRUL ALAM [hidden email]
[belajar-excel] <[hidden email]> wrote:

>
>
> Salam Pak Hendrik
>
> Terimakasih Pak Hendrik untuk rumus tersebut berfungsi menentukan nilai
> terbesar, sedangkan yang saya maksud itu seperti terlampir, jadi
> berdasarkan jumlah kode yang berbeda Pak
>
> Terimakasih
>
> Assalamualaikum
> Hairul
>
> Pada Rabu, 16 Oktober 2019 14.29.56 WIB, hendrik karnadi
> [hidden email] [belajar-excel] <[hidden email]>
> menulis:
>
>
>
>
> Dear Hairul,
> Coba ketik di *R5* :*=MAX(B5:P5)*
> lalu dicopy ke bawah.
>
> Salam,
> HK
>
>
>
> Pada Rabu, 16 Oktober 2019 14.14.59 GMT+7, HAIRUL ALAM [hidden email]
> [belajar-excel] <[hidden email]> menulis:
>
>
>
>
> Salam Rekan - Rekan BeExcel
>
> Rumus apa yang digunakan jika masalah seperti data terlampir ;
>
> jika data pada range C s/d P seperti diatas, bagaimana rumusnya agar nilai
> sama seperti kolom Q, rumus apa yang digunakan COUNTIF atau SUMIF
>
> kolom B no 1 range C s/d P terdapat 2 code angka 1 & 2 maka di R 5
> nilainya samadengan 2
>
> kolom B no 2 range C s/d P terdapat 4 code angka 1,2,3 & 4 maka di R 6
> nilainya samadengan 4
>
> kolom B no 3 range C s/d P terdapat 6 code angka 1,2,3,4,5 & 6 maka di R 7
> nilainya samadengan 6
>
> Terimakasih
>
> Assalmualaikum
> Hairul Alam
>
>
>
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Mencari nilai dengan criteria

HAIRUL ALAM
 Salam Mr.Kid
Terimakasih Banyak
Assalamualaikum
    Pada Kamis, 17 Oktober 2019 09.00.48 GMT+7, 'Mr. Kid' [hidden email] [belajar-excel] <[hidden email]> menulis:

  

=SUMPRODUCT(1*(MATCH(C5:P5,C5:P5,0)=COLUMN(C5:P5)-COLUMN(B5)))

On Wed, Oct 16, 2019 at 5:45 PM HAIRUL ALAM [hidden email] [belajar-excel] <[hidden email]> wrote:

  

 Salam Pak Hendrik
TerimakasihPak Hendrikuntuk rumus tersebut berfungsi menentukan nilai terbesar, sedangkan yang sayamaksud itu seperti terlampir, jadi berdasarkan jumlah kode yang berbeda Pak

Terimakasih
AssalamualaikumHairul
    Pada Rabu, 16 Oktober 2019 14.29.56 WIB, hendrik karnadi [hidden email] [belajar-excel] <[hidden email]> menulis:

  

 Dear Hairul,Coba ketik di R5 :=MAX(B5:P5)lalu dicopy ke bawah.
Salam,HK


    Pada Rabu, 16 Oktober 2019 14.14...59 GMT+7, HAIRUL ALAM [hidden email] [belajar-excel] <[hidden email]> menulis:

  

Salam Rekan - Rekan BeExcel
Rumus apa yang digunakan jika masalah seperti data terlampir ;

jika data pada range C s/d P sepertidiatas, bagaimana rumusnya agar nilai sama seperti kolom Q, rumus apa yangdigunakan COUNTIF atau SUMIF

kolom B no 1 range C s/d P terdapat 2code angka 1 & 2 maka di R 5 nilainya samadengan 2

kolom B no 2 range C s/d P terdapat 4code angka 1,2,3 & 4 maka di R 6 nilainya samadengan 4

kolom B no 3 range C s/d P terdapat 6code angka 1,2,3,4,5 & 6 maka di R 7 nilainya samadengan 6

Terimakasih
AssalmualaikumHairul Alam

 
  #yiv3125855631 #yiv3125855631 -- #yiv3125855631ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3125855631 #yiv3125855631ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3125855631 #yiv3125855631ygrp-mkp #yiv3125855631hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3125855631 #yiv3125855631ygrp-mkp #yiv3125855631ads {margin-bottom:10px;}#yiv3125855631 #yiv3125855631ygrp-mkp ...yiv3125855631ad {padding:0 0;}#yiv3125855631 #yiv3125855631ygrp-mkp .yiv3125855631ad p {margin:0;}#yiv3125855631 #yiv3125855631ygrp-mkp .yiv3125855631ad a {color:#0000ff;text-decoration:none;}#yiv3125855631 #yiv3125855631ygrp-sponsor #yiv3125855631ygrp-lc {font-family:Arial;}#yiv3125855631 #yiv3125855631ygrp-sponsor #yiv3125855631ygrp-lc #yiv3125855631hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3125855631 #yiv3125855631ygrp-sponsor #yiv3125855631ygrp-lc .yiv3125855631ad {margin-bottom:10px;padding:0 0;}#yiv3125855631 #yiv3125855631actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3125855631 #yiv3125855631activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3125855631 #yiv3125855631activity span {font-weight:700;}#yiv3125855631 #yiv3125855631activity span:first-child {text-transform:uppercase;}#yiv3125855631 #yiv3125855631activity span a {color:#5085b6;text-decoration:none;}#yiv3125855631 #yiv3125855631activity span span {color:#ff7900;}#yiv3125855631 #yiv3125855631activity span .yiv3125855631underline {text-decoration:underline;}#yiv3125855631 .yiv3125855631attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3125855631 .yiv3125855631attach div a {text-decoration:none;}#yiv3125855631 .yiv3125855631attach img {border:none;padding-right:5px;}#yiv3125855631 .yiv3125855631attach label {display:block;margin-bottom:5px;}#yiv3125855631 .yiv3125855631attach label a {text-decoration:none;}#yiv3125855631 blockquote {margin:0 0 0 4px;}#yiv3125855631 .yiv3125855631bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3125855631 .yiv3125855631bold a {text-decoration:none;}#yiv3125855631 dd.yiv3125855631last p a {font-family:Verdana;font-weight:700;}#yiv3125855631 dd.yiv3125855631last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3125855631 dd.yiv3125855631last p span.yiv3125855631yshortcuts {margin-right:0;}#yiv3125855631 div.yiv3125855631attach-table div div a {text-decoration:none;}#yiv3125855631 div.yiv3125855631attach-table {width:400px;}#yiv3125855631 div.yiv3125855631file-title a, #yiv3125855631 div.yiv3125855631file-title a:active, #yiv3125855631 div.yiv3125855631file-title a:hover, #yiv3125855631 div.yiv3125855631file-title a:visited {text-decoration:none;}#yiv3125855631 div.yiv3125855631photo-title a, #yiv3125855631 div.yiv3125855631photo-title a:active, #yiv3125855631 div.yiv3125855631photo-title a:hover, #yiv3125855631 div.yiv3125855631photo-title a:visited {text-decoration:none;}#yiv3125855631 div#yiv3125855631ygrp-mlmsg #yiv3125855631ygrp-msg p a span.yiv3125855631yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3125855631 .yiv3125855631green {color:#628c2a;}#yiv3125855631 .yiv3125855631MsoNormal {margin:0 0 0 0;}#yiv3125855631 o {font-size:0;}#yiv3125855631 #yiv3125855631photos div {float:left;width:72px;}#yiv3125855631 #yiv3125855631photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv3125855631 #yiv3125855631photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3125855631 #yiv3125855631reco-category {font-size:77%;}#yiv3125855631 #yiv3125855631reco-desc {font-size:77%;}#yiv3125855631 .yiv3125855631replbq {margin:4px;}#yiv3125855631 #yiv3125855631ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3125855631 #yiv3125855631ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3125855631 #yiv3125855631ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3125855631 #yiv3125855631ygrp-mlmsg select, #yiv3125855631 input, #yiv3125855631 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3125855631 #yiv3125855631ygrp-mlmsg pre, #yiv3125855631 code {font:115% monospace;}#yiv3125855631 #yiv3125855631ygrp-mlmsg * {line-height:1.22em;}#yiv3125855631 #yiv3125855631ygrp-mlmsg #yiv3125855631logo {padding-bottom:10px;}#yiv3125855631 #yiv3125855631ygrp-msg p a {font-family:Verdana;}#yiv3125855631 #yiv3125855631ygrp-msg p#yiv3125855631attach-count span {color:#1E66AE;font-weight:700;}#yiv3125855631 #yiv3125855631ygrp-reco #yiv3125855631reco-head {color:#ff7900;font-weight:700;}#yiv3125855631 #yiv3125855631ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3125855631 #yiv3125855631ygrp-sponsor #yiv3125855631ov li a {font-size:130%;text-decoration:none;}#yiv3125855631 #yiv3125855631ygrp-sponsor #yiv3125855631ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3125855631 #yiv3125855631ygrp-sponsor #yiv3125855631ov ul {margin:0;padding:0 0 0 8px;}#yiv3125855631 #yiv3125855631ygrp-text {font-family:Georgia;}#yiv3125855631 #yiv3125855631ygrp-text p {margin:0 0 1em 0;}#yiv3125855631 #yiv3125855631ygrp-text tt {font-size:120%;}#yiv3125855631 #yiv3125855631ygrp-vital ul li:last-child {border-right:none !important;}#yiv3125855631