[belajar-excel] lookup v3 [1 Attachment]

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

[belajar-excel] lookup v3 [1 Attachment]

HAIRUL ALAM
Salam Para Master BeExcelSelamat SoreSemoga dalam keadaan sehat semuanya
Bagaimana lookup

Jika pada sheet (Record) cell B2 dipilih sesuai kriteriamisalkan ELECTRICAL

maka data yang tampil pada tabel C5sd C9 sesuai data Sheet (Master)
bagaimanaformulanya atau code macronya
seperti file terlampir
TerimakasihHairul Alam


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

Re: [belajar-excel] lookup v3

ghozi alkatiri
 di C5 sheet record  formula array
=IFERROR(INDEX(Master!$H$13:$H$26,SMALL(IF($B$2=Master!$B$13:$B$26,ROW(Master!$B$13:$B$26)),ROW(1:1))-12),"")

copy ke bawah



    Pada Senin, 22 Juni 2020 17.24.39 WIB, HAIRUL ALAM [hidden email] [belajar-excel] <[hidden email]> menulis:  
 
    

Salam Para Master BeExcelSelamat SoreSemoga dalam keadaan sehat semuanya
Bagaimana lookup

Jika pada sheet (Record) cell B2 dipilih sesuai kriteriamisalkan ELECTRICAL

maka data yang tampil pada tabel C5sd C9 sesuai data Sheet (Master)
bagaimanaformulanya atau code macronya
seperti file terlampir
TerimakasihHairul Alam

  #yiv7564063271 #yiv7564063271 -- #yiv7564063271ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7564063271 #yiv7564063271ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7564063271 #yiv7564063271ygrp-mkp #yiv7564063271hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7564063271 #yiv7564063271ygrp-mkp #yiv7564063271ads {margin-bottom:10px;}#yiv7564063271 #yiv7564063271ygrp-mkp .yiv7564063271ad {padding:0 0;}#yiv7564063271 #yiv7564063271ygrp-mkp .yiv7564063271ad p {margin:0;}#yiv7564063271 #yiv7564063271ygrp-mkp .yiv7564063271ad a {color:#0000ff;text-decoration:none;}#yiv7564063271 #yiv7564063271ygrp-sponsor #yiv7564063271ygrp-lc {font-family:Arial;}#yiv7564063271 #yiv7564063271ygrp-sponsor #yiv7564063271ygrp-lc #yiv7564063271hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7564063271 #yiv7564063271ygrp-sponsor #yiv7564063271ygrp-lc .yiv7564063271ad {margin-bottom:10px;padding:0 0;}#yiv7564063271 #yiv7564063271actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7564063271 #yiv7564063271activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7564063271 #yiv7564063271activity span {font-weight:700;}#yiv7564063271 #yiv7564063271activity span:first-child {text-transform:uppercase;}#yiv7564063271 #yiv7564063271activity span a {color:#5085b6;text-decoration:none;}#yiv7564063271 #yiv7564063271activity span span {color:#ff7900;}#yiv7564063271 #yiv7564063271activity span .yiv7564063271underline {text-decoration:underline;}#yiv7564063271 .yiv7564063271attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7564063271 .yiv7564063271attach div a {text-decoration:none;}#yiv7564063271 .yiv7564063271attach img {border:none;padding-right:5px;}#yiv7564063271 .yiv7564063271attach label {display:block;margin-bottom:5px;}#yiv7564063271 .yiv7564063271attach label a {text-decoration:none;}#yiv7564063271 blockquote {margin:0 0 0 4px;}#yiv7564063271 .yiv7564063271bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7564063271 .yiv7564063271bold a {text-decoration:none;}#yiv7564063271 dd.yiv7564063271last p a {font-family:Verdana;font-weight:700;}#yiv7564063271 dd.yiv7564063271last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7564063271 dd.yiv7564063271last p span.yiv7564063271yshortcuts {margin-right:0;}#yiv7564063271 div.yiv7564063271attach-table div div a {text-decoration:none;}#yiv7564063271 div.yiv7564063271attach-table {width:400px;}#yiv7564063271 div.yiv7564063271file-title a, #yiv7564063271 div.yiv7564063271file-title a:active, #yiv7564063271 div.yiv7564063271file-title a:hover, #yiv7564063271 div.yiv7564063271file-title a:visited {text-decoration:none;}#yiv7564063271 div.yiv7564063271photo-title a, #yiv7564063271 div.yiv7564063271photo-title a:active, #yiv7564063271 div.yiv7564063271photo-title a:hover, #yiv7564063271 div.yiv7564063271photo-title a:visited {text-decoration:none;}#yiv7564063271 div#yiv7564063271ygrp-mlmsg #yiv7564063271ygrp-msg p a span.yiv7564063271yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7564063271 .yiv7564063271green {color:#628c2a;}#yiv7564063271 .yiv7564063271MsoNormal {margin:0 0 0 0;}#yiv7564063271 o {font-size:0;}#yiv7564063271 #yiv7564063271photos div {float:left;width:72px;}#yiv7564063271 #yiv7564063271photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv7564063271 #yiv7564063271photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7564063271 #yiv7564063271reco-category {font-size:77%;}#yiv7564063271 #yiv7564063271reco-desc {font-size:77%;}#yiv7564063271 .yiv7564063271replbq {margin:4px;}#yiv7564063271 #yiv7564063271ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv7564063271 #yiv7564063271ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7564063271 #yiv7564063271ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7564063271 #yiv7564063271ygrp-mlmsg select, #yiv7564063271 input, #yiv7564063271 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv7564063271 #yiv7564063271ygrp-mlmsg pre, #yiv7564063271 code {font:115% monospace;}#yiv7564063271 #yiv7564063271ygrp-mlmsg * {line-height:1.22em;}#yiv7564063271 #yiv7564063271ygrp-mlmsg #yiv7564063271logo {padding-bottom:10px;}#yiv7564063271 #yiv7564063271ygrp-msg p a {font-family:Verdana;}#yiv7564063271 #yiv7564063271ygrp-msg p#yiv7564063271attach-count span {color:#1E66AE;font-weight:700;}#yiv7564063271 #yiv7564063271ygrp-reco #yiv7564063271reco-head {color:#ff7900;font-weight:700;}#yiv7564063271 #yiv7564063271ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7564063271 #yiv7564063271ygrp-sponsor #yiv7564063271ov li a {font-size:130%;text-decoration:none;}#yiv7564063271 #yiv7564063271ygrp-sponsor #yiv7564063271ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7564063271 #yiv7564063271ygrp-sponsor #yiv7564063271ov ul {margin:0;padding:0 0 0 8px;}#yiv7564063271 #yiv7564063271ygrp-text {font-family:Georgia;}#yiv7564063271 #yiv7564063271ygrp-text p {margin:0 0 1em 0;}#yiv7564063271 #yiv7564063271ygrp-text tt {font-size:120%;}#yiv7564063271 #yiv7564063271ygrp-vital ul li:last-child {border-right:none !important;}#yiv7564063271  
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] lookup v3

HAIRUL ALAM
 Terimakasih Mas Ghozi
    Pada Senin, 22 Juni 2020 20.50.57 WIB, ghozi alkatiri [hidden email] [belajar-excel] <[hidden email]> menulis:  
 
    

 di C5 sheet record  formula array
=IFERROR(INDEX(Master!$H$13:$H$26,SMALL(IF($B$2=Master!$B$13:$B$26,ROW(Master!$B$13:$B$26)),ROW(1:1))-12),"")

copy ke bawah



    Pada Senin, 22 Juni 2020 17.24.39 WIB, HAIRUL ALAM [hidden email] [belajar-excel] <[hidden email]> menulis:  
 
    

Salam Para Master BeExcelSelamat SoreSemoga dalam keadaan sehat semuanya
Bagaimana lookup

Jika pada sheet (Record) cell B2 dipilih sesuai kriteriamisalkan ELECTRICAL

maka data yang tampil pada tabel C5sd C9 sesuai data Sheet (Master)
bagaimanaformulanya atau code macronya
seperti file terlampir
TerimakasihHairul Alam

      #yiv5057098434 #yiv5057098434 -- #yiv5057098434ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5057098434 #yiv5057098434ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5057098434 #yiv5057098434ygrp-mkp #yiv5057098434hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5057098434 #yiv5057098434ygrp-mkp #yiv5057098434ads {margin-bottom:10px;}#yiv5057098434 #yiv5057098434ygrp-mkp .yiv5057098434ad {padding:0 0;}#yiv5057098434 #yiv5057098434ygrp-mkp .yiv5057098434ad p {margin:0;}#yiv5057098434 #yiv5057098434ygrp-mkp .yiv5057098434ad a {color:#0000ff;text-decoration:none;}#yiv5057098434 #yiv5057098434ygrp-sponsor #yiv5057098434ygrp-lc {font-family:Arial;}#yiv5057098434 #yiv5057098434ygrp-sponsor #yiv5057098434ygrp-lc #yiv5057098434hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5057098434 #yiv5057098434ygrp-sponsor #yiv5057098434ygrp-lc .yiv5057098434ad {margin-bottom:10px;padding:0 0;}#yiv5057098434 #yiv5057098434actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5057098434 #yiv5057098434activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5057098434 #yiv5057098434activity span {font-weight:700;}#yiv5057098434 #yiv5057098434activity span:first-child {text-transform:uppercase;}#yiv5057098434 #yiv5057098434activity span a {color:#5085b6;text-decoration:none;}#yiv5057098434 #yiv5057098434activity span span {color:#ff7900;}#yiv5057098434 #yiv5057098434activity span .yiv5057098434underline {text-decoration:underline;}#yiv5057098434 .yiv5057098434attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv5057098434 .yiv5057098434attach div a {text-decoration:none;}#yiv5057098434 .yiv5057098434attach img {border:none;padding-right:5px;}#yiv5057098434 .yiv5057098434attach label {display:block;margin-bottom:5px;}#yiv5057098434 .yiv5057098434attach label a {text-decoration:none;}#yiv5057098434 blockquote {margin:0 0 0 4px;}#yiv5057098434 .yiv5057098434bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv5057098434 .yiv5057098434bold a {text-decoration:none;}#yiv5057098434 dd.yiv5057098434last p a {font-family:Verdana;font-weight:700;}#yiv5057098434 dd.yiv5057098434last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5057098434 dd.yiv5057098434last p span.yiv5057098434yshortcuts {margin-right:0;}#yiv5057098434 div.yiv5057098434attach-table div div a {text-decoration:none;}#yiv5057098434 div.yiv5057098434attach-table {width:400px;}#yiv5057098434 div.yiv5057098434file-title a, #yiv5057098434 div.yiv5057098434file-title a:active, #yiv5057098434 div.yiv5057098434file-title a:hover, #yiv5057098434 div.yiv5057098434file-title a:visited {text-decoration:none;}#yiv5057098434 div.yiv5057098434photo-title a, #yiv5057098434 div.yiv5057098434photo-title a:active, #yiv5057098434 div.yiv5057098434photo-title a:hover, #yiv5057098434 div.yiv5057098434photo-title a:visited {text-decoration:none;}#yiv5057098434 div#yiv5057098434ygrp-mlmsg #yiv5057098434ygrp-msg p a span.yiv5057098434yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5057098434 .yiv5057098434green {color:#628c2a;}#yiv5057098434 .yiv5057098434MsoNormal {margin:0 0 0 0;}#yiv5057098434 o {font-size:0;}#yiv5057098434 #yiv5057098434photos div {float:left;width:72px;}#yiv5057098434 #yiv5057098434photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv5057098434 #yiv5057098434photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5057098434 #yiv5057098434reco-category {font-size:77%;}#yiv5057098434 #yiv5057098434reco-desc {font-size:77%;}#yiv5057098434 .yiv5057098434replbq {margin:4px;}#yiv5057098434 #yiv5057098434ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv5057098434 #yiv5057098434ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5057098434 #yiv5057098434ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5057098434 #yiv5057098434ygrp-mlmsg select, #yiv5057098434 input, #yiv5057098434 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv5057098434 #yiv5057098434ygrp-mlmsg pre, #yiv5057098434 code {font:115% monospace;}#yiv5057098434 #yiv5057098434ygrp-mlmsg * {line-height:1.22em;}#yiv5057098434 #yiv5057098434ygrp-mlmsg #yiv5057098434logo {padding-bottom:10px;}#yiv5057098434 #yiv5057098434ygrp-msg p a {font-family:Verdana;}#yiv5057098434 #yiv5057098434ygrp-msg p#yiv5057098434attach-count span {color:#1E66AE;font-weight:700;}#yiv5057098434 #yiv5057098434ygrp-reco #yiv5057098434reco-head {color:#ff7900;font-weight:700;}#yiv5057098434 #yiv5057098434ygrp-reco {margin-bottom:20px;padding:0px;}#yiv5057098434 #yiv5057098434ygrp-sponsor #yiv5057098434ov li a {font-size:130%;text-decoration:none;}#yiv5057098434 #yiv5057098434ygrp-sponsor #yiv5057098434ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv5057098434 #yiv5057098434ygrp-sponsor #yiv5057098434ov ul {margin:0;padding:0 0 0 8px;}#yiv5057098434 #yiv5057098434ygrp-text {font-family:Georgia;}#yiv5057098434 #yiv5057098434ygrp-text p {margin:0 0 1em 0;}#yiv5057098434 #yiv5057098434ygrp-text tt {font-size:120%;}#yiv5057098434 #yiv5057098434ygrp-vital ul li:last-child {border-right:none !important;}#yiv5057098434  
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] lookup v3

HAIRUL ALAM
 Terimakasih Mas Ghozi
Kemarin saya coba pake INDIRECT 
{=INDIRECT("Master!H"&SMALL(IF(Master!$B$2:$B$26=B$2,ROW(Master!$H$2:$H$26)),ROW(1:1)))}

    Pada Selasa, 23 Juni 2020 07.47.01 WIB, HAIRUL ALAM <[hidden email]> menulis:  
 
  Terimakasih Mas Ghozi
    Pada Senin, 22 Juni 2020 20.50.57 WIB, ghozi alkatiri [hidden email] [belajar-excel] <[hidden email]> menulis:  
 
    

 di C5 sheet record  formula array
=IFERROR(INDEX(Master!$H$13:$H$26,SMALL(IF($B$2=Master!$B$13:$B$26,ROW(Master!$B$13:$B$26)),ROW(1:1))-12),"")

copy ke bawah



    Pada Senin, 22 Juni 2020 17.24.39 WIB, HAIRUL ALAM [hidden email] [belajar-excel] <[hidden email]> menulis:  
 
    

Salam Para Master BeExcelSelamat SoreSemoga dalam keadaan sehat semuanya
Bagaimana lookup

Jika pada sheet (Record) cell B2 dipilih sesuai kriteriamisalkan ELECTRICAL

maka data yang tampil pada tabel C5sd C9 sesuai data Sheet (Master)
bagaimanaformulanya atau code macronya
seperti file terlampir
TerimakasihHairul Alam

      #yiv6677631740 -- #yiv6677631740ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6677631740 #yiv6677631740ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6677631740 #yiv6677631740ygrp-mkp #yiv6677631740hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv6677631740 #yiv6677631740ygrp-mkp #yiv6677631740ads {margin-bottom:10px;}#yiv6677631740 #yiv6677631740ygrp-mkp .yiv6677631740ad {padding:0 0;}#yiv6677631740 #yiv6677631740ygrp-mkp .yiv6677631740ad p {margin:0;}#yiv6677631740 #yiv6677631740ygrp-mkp .yiv6677631740ad a {color:#0000ff;text-decoration:none;}#yiv6677631740 #yiv6677631740ygrp-sponsor #yiv6677631740ygrp-lc {font-family:Arial;}#yiv6677631740 #yiv6677631740ygrp-sponsor #yiv6677631740ygrp-lc #yiv6677631740hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6677631740 #yiv6677631740ygrp-sponsor #yiv6677631740ygrp-lc .yiv6677631740ad {margin-bottom:10px;padding:0 0;}#yiv6677631740 #yiv6677631740actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6677631740 #yiv6677631740activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6677631740 #yiv6677631740activity span {font-weight:700;}#yiv6677631740 #yiv6677631740activity span:first-child {text-transform:uppercase;}#yiv6677631740 #yiv6677631740activity span a {color:#5085b6;text-decoration:none;}#yiv6677631740 #yiv6677631740activity span span {color:#ff7900;}#yiv6677631740 #yiv6677631740activity span .yiv6677631740underline {text-decoration:underline;}#yiv6677631740 .yiv6677631740attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv6677631740 .yiv6677631740attach div a {text-decoration:none;}#yiv6677631740 .yiv6677631740attach img {border:none;padding-right:5px;}#yiv6677631740 .yiv6677631740attach label {display:block;margin-bottom:5px;}#yiv6677631740 .yiv6677631740attach label a {text-decoration:none;}#yiv6677631740 blockquote {margin:0 0 0 4px;}#yiv6677631740 .yiv6677631740bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv6677631740 .yiv6677631740bold a {text-decoration:none;}#yiv6677631740 dd.yiv6677631740last p a {font-family:Verdana;font-weight:700;}#yiv6677631740 dd.yiv6677631740last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6677631740 dd.yiv6677631740last p span.yiv6677631740yshortcuts {margin-right:0;}#yiv6677631740 div.yiv6677631740attach-table div div a {text-decoration:none;}#yiv6677631740 div.yiv6677631740attach-table {width:400px;}#yiv6677631740 div.yiv6677631740file-title a, #yiv6677631740 div.yiv6677631740file-title a:active, #yiv6677631740 div.yiv6677631740file-title a:hover, #yiv6677631740 div.yiv6677631740file-title a:visited {text-decoration:none;}#yiv6677631740 div.yiv6677631740photo-title a, #yiv6677631740 div.yiv6677631740photo-title a:active, #yiv6677631740 div.yiv6677631740photo-title a:hover, #yiv6677631740 div.yiv6677631740photo-title a:visited {text-decoration:none;}#yiv6677631740 div#yiv6677631740ygrp-mlmsg #yiv6677631740ygrp-msg p a span.yiv6677631740yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6677631740 .yiv6677631740green {color:#628c2a;}#yiv6677631740 .yiv6677631740MsoNormal {margin:0 0 0 0;}#yiv6677631740 o {font-size:0;}#yiv6677631740 #yiv6677631740photos div {float:left;width:72px;}#yiv6677631740 #yiv6677631740photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv6677631740 #yiv6677631740photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6677631740 #yiv6677631740reco-category {font-size:77%;}#yiv6677631740 #yiv6677631740reco-desc {font-size:77%;}#yiv6677631740 .yiv6677631740replbq {margin:4px;}#yiv6677631740 #yiv6677631740ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv6677631740 #yiv6677631740ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6677631740 #yiv6677631740ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6677631740 #yiv6677631740ygrp-mlmsg select, #yiv6677631740 input, #yiv6677631740 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv6677631740 #yiv6677631740ygrp-mlmsg pre, #yiv6677631740 code {font:115% monospace;}#yiv6677631740 #yiv6677631740ygrp-mlmsg * {line-height:1.22em;}#yiv6677631740 #yiv6677631740ygrp-mlmsg #yiv6677631740logo {padding-bottom:10px;}#yiv6677631740 #yiv6677631740ygrp-msg p a {font-family:Verdana;}#yiv6677631740 #yiv6677631740ygrp-msg p#yiv6677631740attach-count span {color:#1E66AE;font-weight:700;}#yiv6677631740 #yiv6677631740ygrp-reco #yiv6677631740reco-head {color:#ff7900;font-weight:700;}#yiv6677631740 #yiv6677631740ygrp-reco {margin-bottom:20px;padding:0px;}#yiv6677631740 #yiv6677631740ygrp-sponsor #yiv6677631740ov li a {font-size:130%;text-decoration:none;}#yiv6677631740 #yiv6677631740ygrp-sponsor #yiv6677631740ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv6677631740 #yiv6677631740ygrp-sponsor #yiv6677631740ov ul {margin:0;padding:0 0 0 8px;}#yiv6677631740 #yiv6677631740ygrp-text {font-family:Georgia;}#yiv6677631740 #yiv6677631740ygrp-text p {margin:0 0 1em 0;}#yiv6677631740 #yiv6677631740ygrp-text tt {font-size:120%;}#yiv6677631740 #yiv6677631740ygrp-vital ul li:last-child {border-right:none !important;}#yiv6677631740