[belajar-excel] ( TANYA ) BAGAIMANA CARA MENCARI DATA BASE DENGAN 2 KRITARIA [1 Attachment]

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

[belajar-excel] ( TANYA ) BAGAIMANA CARA MENCARI DATA BASE DENGAN 2 KRITARIA [1 Attachment]

makdo marbun-2
dear  kawan kawan  dan  om momod

selamat pagi dan semangat pagi

saya  Mohon bantuannya  semua untuk  mempermudah pekerjaan saya .

jadi saya  punya database karyawan yang cukup banyak namun sih manual..
agar  suatu saat data di perlukan  oleh atasan siap saji
maka saya perlu meemikirkan cara terbaik

misalkan jika atasan  minta  sbb:

1. jumlah   karyawan  yang ada di devisi  dengan  dept terpilih
2. atau jumlah karyawan dept  dengan kriteria masa kontrak
3. dll



data terlampir mohon bantuanya.
 jika ada yang mau di tambahkan atau modifikasi untuk lebih baik saya
sangat berterimakasih

Tks

( TANYA ) BAGAIMANA CARA MENCARI DATA BASE DENGAN 2 KRITARIA.xlsx (35K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] ( TANYA ) BAGAIMANA CARA MENCARI DATA BASE DENGAN 2 KRITARIA

Eira_ariE
selamat pagi ..coba pakai fitur excel PIVOT TABLE kang ..di kasus sebelumnya ada permasalahan yang mirip ..


    On Saturday, November 3, 2018, 10:59:25 AM GMT+7, makdo marbun [hidden email] [belajar-excel] <[hidden email]> wrote:

  

dear  kawan kawan  dan  om momod 
selamat pagi dan semangat pagi
saya  Mohon bantuannya  semua untuk  mempermudah pekerjaan saya . 
jadi saya  punya database karyawan yang cukup banyak namun sih manual.. agar  suatu saat data di perlukan  oleh atasan siap sajimaka saya perlu meemikirkan cara terbaik  
misalkan jika atasan  minta  sbb: 
1. jumlah   karyawan  yang ada di devisi  dengan  dept terpilih2. atau jumlah karyawan dept  dengan kriteria masa kontrak3. dll


data terlampir mohon bantuanya. jika ada yang mau di tambahkan atau modifikasi untuk lebih baik saya sangat berterimakasih
Tks
  #yiv7329184384 #yiv7329184384 -- #yiv7329184384ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7329184384 #yiv7329184384ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7329184384 #yiv7329184384ygrp-mkp #yiv7329184384hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7329184384 #yiv7329184384ygrp-mkp #yiv7329184384ads {margin-bottom:10px;}#yiv7329184384 #yiv7329184384ygrp-mkp .yiv7329184384ad {padding:0 0;}#yiv7329184384 #yiv7329184384ygrp-mkp .yiv7329184384ad p {margin:0;}#yiv7329184384 #yiv7329184384ygrp-mkp .yiv7329184384ad a {color:#0000ff;text-decoration:none;}#yiv7329184384 #yiv7329184384ygrp-sponsor #yiv7329184384ygrp-lc {font-family:Arial;}#yiv7329184384 #yiv7329184384ygrp-sponsor #yiv7329184384ygrp-lc #yiv7329184384hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7329184384 #yiv7329184384ygrp-sponsor #yiv7329184384ygrp-lc .yiv7329184384ad {margin-bottom:10px;padding:0 0;}#yiv7329184384 #yiv7329184384actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7329184384 #yiv7329184384activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7329184384 #yiv7329184384activity span {font-weight:700;}#yiv7329184384 #yiv7329184384activity span:first-child {text-transform:uppercase;}#yiv7329184384 #yiv7329184384activity span a {color:#5085b6;text-decoration:none;}#yiv7329184384 #yiv7329184384activity span span {color:#ff7900;}#yiv7329184384 #yiv7329184384activity span .yiv7329184384underline {text-decoration:underline;}#yiv7329184384 .yiv7329184384attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7329184384 .yiv7329184384attach div a {text-decoration:none;}#yiv7329184384 .yiv7329184384attach img {border:none;padding-right:5px;}#yiv7329184384 .yiv7329184384attach label {display:block;margin-bottom:5px;}#yiv7329184384 .yiv7329184384attach label a {text-decoration:none;}#yiv7329184384 blockquote {margin:0 0 0 4px;}#yiv7329184384 .yiv7329184384bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7329184384 .yiv7329184384bold a {text-decoration:none;}#yiv7329184384 dd.yiv7329184384last p a {font-family:Verdana;font-weight:700;}#yiv7329184384 dd.yiv7329184384last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7329184384 dd.yiv7329184384last p span.yiv7329184384yshortcuts {margin-right:0;}#yiv7329184384 div.yiv7329184384attach-table div div a {text-decoration:none;}#yiv7329184384 div.yiv7329184384attach-table {width:400px;}#yiv7329184384 div.yiv7329184384file-title a, #yiv7329184384 div.yiv7329184384file-title a:active, #yiv7329184384 div...yiv7329184384file-title a:hover, #yiv7329184384 div.yiv7329184384file-title a:visited {text-decoration:none;}#yiv7329184384 div.yiv7329184384photo-title a, #yiv7329184384 div.yiv7329184384photo-title a:active, #yiv7329184384 div.yiv7329184384photo-title a:hover, #yiv7329184384 div.yiv7329184384photo-title a:visited {text-decoration:none;}#yiv7329184384 div#yiv7329184384ygrp-mlmsg #yiv7329184384ygrp-msg p a span.yiv7329184384yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7329184384 .yiv7329184384green {color:#628c2a;}#yiv7329184384 .yiv7329184384MsoNormal {margin:0 0 0 0;}#yiv7329184384 o {font-size:0;}#yiv7329184384 #yiv7329184384photos div {float:left;width:72px;}#yiv7329184384 #yiv7329184384photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv7329184384 #yiv7329184384photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7329184384 #yiv7329184384reco-category {font-size:77%;}#yiv7329184384 #yiv7329184384reco-desc {font-size:77%;}#yiv7329184384 .yiv7329184384replbq {margin:4px;}#yiv7329184384 #yiv7329184384ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv7329184384 #yiv7329184384ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7329184384 #yiv7329184384ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7329184384 #yiv7329184384ygrp-mlmsg select, #yiv7329184384 input, #yiv7329184384 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv7329184384 #yiv7329184384ygrp-mlmsg pre, #yiv7329184384 code {font:115% monospace;}#yiv7329184384 #yiv7329184384ygrp-mlmsg * {line-height:1.22em;}#yiv7329184384 #yiv7329184384ygrp-mlmsg #yiv7329184384logo {padding-bottom:10px;}#yiv7329184384 #yiv7329184384ygrp-msg p a {font-family:Verdana;}#yiv7329184384 #yiv7329184384ygrp-msg p#yiv7329184384attach-count span {color:#1E66AE;font-weight:700;}#yiv7329184384 #yiv7329184384ygrp-reco #yiv7329184384reco-head {color:#ff7900;font-weight:700;}#yiv7329184384 #yiv7329184384ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7329184384 #yiv7329184384ygrp-sponsor #yiv7329184384ov li a {font-size:130%;text-decoration:none;}#yiv7329184384 #yiv7329184384ygrp-sponsor #yiv7329184384ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7329184384 #yiv7329184384ygrp-sponsor #yiv7329184384ov ul {margin:0;padding:0 0 0 8px;}#yiv7329184384 #yiv7329184384ygrp-text {font-family:Georgia;}#yiv7329184384 #yiv7329184384ygrp-text p {margin:0 0 1em 0;}#yiv7329184384 #yiv7329184384ygrp-text tt {font-size:120%;}#yiv7329184384 #yiv7329184384ygrp-vital ul li:last-child {border-right:none !important;}#yiv7329184384
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] ( TANYA ) BAGAIMANA CARA MENCARI DATA BASE DENGAN 2 KRITARIA

makdo marbun-2
besar harapan saya pakai  rumus pak biar atomatis cuman saya enggak bisa


mohon bantuannya

Pada tanggal 03/11/18, Eira I Arie [hidden email]
[belajar-excel] <[hidden email]> menulis:

> selamat pagi ..coba pakai fitur excel PIVOT TABLE kang ..di kasus sebelumnya
> ada permasalahan yang mirip ..
>
>
>     On Saturday, November 3, 2018, 10:59:25 AM GMT+7, makdo marbun
> [hidden email] [belajar-excel] <[hidden email]> wrote:
>
>
>
>
> dear  kawan kawan  dan  om momod
> selamat pagi dan semangat pagi
> saya  Mohon bantuannya  semua untuk  mempermudah pekerjaan saya .
> jadi saya  punya database karyawan yang cukup banyak namun sih manual..
> agar  suatu saat data di perlukan  oleh atasan siap sajimaka saya perlu
> meemikirkan cara terbaik
> misalkan jika atasan  minta  sbb:
> 1. jumlah   karyawan  yang ada di devisi  dengan  dept terpilih2. atau
> jumlah karyawan dept  dengan kriteria masa kontrak3. dll
>
>
> data terlampir mohon bantuanya. jika ada yang mau di tambahkan atau
> modifikasi untuk lebih baik saya sangat berterimakasih
> Tks
>   #yiv7329184384 #yiv7329184384 -- #yiv7329184384ygrp-mkp {border:1px solid
> #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7329184384
> #yiv7329184384ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7329184384
> #yiv7329184384ygrp-mkp #yiv7329184384hd
> {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
> 0;}#yiv7329184384 #yiv7329184384ygrp-mkp #yiv7329184384ads
> {margin-bottom:10px;}#yiv7329184384 #yiv7329184384ygrp-mkp .yiv7329184384ad
> {padding:0 0;}#yiv7329184384 #yiv7329184384ygrp-mkp .yiv7329184384ad p
> {margin:0;}#yiv7329184384 #yiv7329184384ygrp-mkp .yiv7329184384ad a
> {color:#0000ff;text-decoration:none;}#yiv7329184384
> #yiv7329184384ygrp-sponsor #yiv7329184384ygrp-lc
> {font-family:Arial;}#yiv7329184384 #yiv7329184384ygrp-sponsor
> #yiv7329184384ygrp-lc #yiv7329184384hd {margin:10px
> 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7329184384
> #yiv7329184384ygrp-sponsor #yiv7329184384ygrp-lc .yiv7329184384ad
> {margin-bottom:10px;padding:0 0;}#yiv7329184384 #yiv7329184384actions
> {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7329184384
> #yiv7329184384activity
> {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7329184384
> #yiv7329184384activity span {font-weight:700;}#yiv7329184384
> #yiv7329184384activity span:first-child
> {text-transform:uppercase;}#yiv7329184384 #yiv7329184384activity span a
> {color:#5085b6;text-decoration:none;}#yiv7329184384 #yiv7329184384activity
> span span {color:#ff7900;}#yiv7329184384 #yiv7329184384activity span
> .yiv7329184384underline {text-decoration:underline;}#yiv7329184384
> .yiv7329184384attach
> {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
> 0;width:400px;}#yiv7329184384 .yiv7329184384attach div a
> {text-decoration:none;}#yiv7329184384 .yiv7329184384attach img
> {border:none;padding-right:5px;}#yiv7329184384 .yiv7329184384attach label
> {display:block;margin-bottom:5px;}#yiv7329184384 .yiv7329184384attach label
> a {text-decoration:none;}#yiv7329184384 blockquote {margin:0 0 0
> 4px;}#yiv7329184384 .yiv7329184384bold
> {font-family:Arial;font-size:13px;font-weight:700;}#yiv7329184384
> .yiv7329184384bold a {text-decoration:none;}#yiv7329184384
> dd.yiv7329184384last p a
> {font-family:Verdana;font-weight:700;}#yiv7329184384 dd.yiv7329184384last p
> span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7329184384
> dd.yiv7329184384last p span.yiv7329184384yshortcuts
> {margin-right:0;}#yiv7329184384 div.yiv7329184384attach-table div div a
> {text-decoration:none;}#yiv7329184384 div.yiv7329184384attach-table
> {width:400px;}#yiv7329184384 div.yiv7329184384file-title a, #yiv7329184384
> div.yiv7329184384file-title a:active, #yiv7329184384
> div...yiv7329184384file-title a:hover, #yiv7329184384
> div.yiv7329184384file-title a:visited {text-decoration:none;}#yiv7329184384
> div.yiv7329184384photo-title a, #yiv7329184384 div.yiv7329184384photo-title
> a:active, #yiv7329184384 div.yiv7329184384photo-title a:hover,
> #yiv7329184384 div.yiv7329184384photo-title a:visited
> {text-decoration:none;}#yiv7329184384 div#yiv7329184384ygrp-mlmsg
> #yiv7329184384ygrp-msg p a span.yiv7329184384yshortcuts
> {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7329184384
> .yiv7329184384green {color:#628c2a;}#yiv7329184384 .yiv7329184384MsoNormal
> {margin:0 0 0 0;}#yiv7329184384 o {font-size:0;}#yiv7329184384
> #yiv7329184384photos div {float:left;width:72px;}#yiv7329184384
> #yiv7329184384photos div div {border:1px solid
> #666666;min-height:62px;overflow:hidden;width:62px;}#yiv7329184384
> #yiv7329184384photos div label
> {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7329184384
> #yiv7329184384reco-category {font-size:77%;}#yiv7329184384
> #yiv7329184384reco-desc {font-size:77%;}#yiv7329184384 .yiv7329184384replbq
> {margin:4px;}#yiv7329184384 #yiv7329184384ygrp-actbar div a:first-child
> {margin-right:2px;padding-right:5px;}#yiv7329184384 #yiv7329184384ygrp-mlmsg
> {font-size:13px;font-family:Arial, helvetica, clean,
> sans-serif;}#yiv7329184384 #yiv7329184384ygrp-mlmsg table
> {font-size:inherit;font:100%;}#yiv7329184384 #yiv7329184384ygrp-mlmsg
> select, #yiv7329184384 input, #yiv7329184384 textarea {font:99% Arial,
> Helvetica, clean, sans-serif;}#yiv7329184384 #yiv7329184384ygrp-mlmsg pre,
> #yiv7329184384 code {font:115% monospace;}#yiv7329184384
> #yiv7329184384ygrp-mlmsg * {line-height:1.22em;}#yiv7329184384
> #yiv7329184384ygrp-mlmsg #yiv7329184384logo
> {padding-bottom:10px;}#yiv7329184384 #yiv7329184384ygrp-msg p a
> {font-family:Verdana;}#yiv7329184384 #yiv7329184384ygrp-msg
> p#yiv7329184384attach-count span
> {color:#1E66AE;font-weight:700;}#yiv7329184384 #yiv7329184384ygrp-reco
> #yiv7329184384reco-head {color:#ff7900;font-weight:700;}#yiv7329184384
> #yiv7329184384ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7329184384
> #yiv7329184384ygrp-sponsor #yiv7329184384ov li a
> {font-size:130%;text-decoration:none;}#yiv7329184384
> #yiv7329184384ygrp-sponsor #yiv7329184384ov li
> {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7329184384
> #yiv7329184384ygrp-sponsor #yiv7329184384ov ul {margin:0;padding:0 0 0
> 8px;}#yiv7329184384 #yiv7329184384ygrp-text
> {font-family:Georgia;}#yiv7329184384 #yiv7329184384ygrp-text p {margin:0 0
> 1em 0;}#yiv7329184384 #yiv7329184384ygrp-text tt
> {font-size:120%;}#yiv7329184384 #yiv7329184384ygrp-vital ul li:last-child
> {border-right:none !important;}#yiv7329184384
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] ( TANYA ) BAGAIMANA CARA MENCARI DATA BASE DENGAN 2 KRITARIA [1 Attachment]

Agus-2
In reply to this post by makdo marbun-2
Dear Makdo;
Ternyata ada juga orang yang suka formula seperti saya, ha ha ha ha . . .
Karena data yang saya olah hanya kecil, maksimal dua ribuan baris. masih
mecil untuk data ukuran excel sehingga masih sangat terasa nyaman
menggunakan formula yang rumit sekalipun.
Andai saja data saya sampai ratusan ribu baris pasti saya akan memilih
menggunakan pivot tabel.
File terlampir menggunakan kolom bantu.
Kolom bantunya lumanyan banyak untuk membuat combobox bertingkat ( bukan
combo box hanya data validation berjenjang)

salam
NangAgus

On 11/3/2018 07:52, makdo marbun [hidden email] [belajar-excel] wrote:

> dear kawan kawan  dan  om momod
>
> selamat pagi dan semangat pagi
>
> saya Mohon bantuannya  semua untuk  mempermudah pekerjaan saya .
>
> jadi saya  punya database karyawan yang cukup banyak namun sih
> manual.. agar  suatu saat data di perlukan  oleh atasan siap saji
> maka saya perlu meemikirkan cara terbaik
>
> misalkan jika atasan  minta  sbb:
>
> 1. jumlah   karyawan  yang ada di devisi  dengan  dept terpilih
> 2. atau jumlah karyawan dept  dengan kriteria masa kontrak
> 3. dll
>
>
>
> data terlampir mohon bantuanya.
>  jika ada yang mau di tambahkan atau modifikasi untuk lebih baik saya
> sangat berterimakasih
>
> Tks
>
>



BAGAIMANA CARA MENCARI DATA BASE DENGAN 2 KRITARIA Gz.xlsx (39K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Bls: [belajar-excel] ( TANYA ) BAGAIMANA CARA MENCARI DATA BASE DENGAN 2 KRITARIA

od212
In reply to this post by makdo marbun-2
pakein table excel aja...
lebih gampang tinggal di atur tataletaknya... br,

odong nando


      Dari: "makdo marbun [hidden email] [belajar-excel]" <[hidden email]>
 Kepada: [hidden email]
 Dikirim: Sabtu, 3 November 2018 10:59
 Judul: [belajar-excel] ( TANYA ) BAGAIMANA CARA MENCARI DATA BASE DENGAN 2 KRITARIA [1 Attachment]
   
    dear  kawan kawan  dan  om momod 
selamat pagi dan semangat pagi
saya  Mohon bantuannya  semua untuk  mempermudah pekerjaan saya . 
jadi saya  punya database karyawan yang cukup banyak namun sih manual... agar  suatu saat data di perlukan  oleh atasan siap sajimaka saya perlu meemikirkan cara terbaik  
misalkan jika atasan  minta  sbb: 
1. jumlah   karyawan  yang ada di devisi  dengan  dept terpilih2. atau jumlah karyawan dept  dengan kriteria masa kontrak3. dll


data terlampir mohon bantuanya. jika ada yang mau di tambahkan atau modifikasi untuk lebih baik saya sangat berterimakasih
Tks
  #yiv6467896693 #yiv6467896693 -- #yiv6467896693ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6467896693 #yiv6467896693ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6467896693 #yiv6467896693ygrp-mkp #yiv6467896693hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv6467896693 #yiv6467896693ygrp-mkp #yiv6467896693ads {margin-bottom:10px;}#yiv6467896693 #yiv6467896693ygrp-mkp .yiv6467896693ad {padding:0 0;}#yiv6467896693 #yiv6467896693ygrp-mkp .yiv6467896693ad p {margin:0;}#yiv6467896693 #yiv6467896693ygrp-mkp .yiv6467896693ad a {color:#0000ff;text-decoration:none;}#yiv6467896693 #yiv6467896693ygrp-sponsor #yiv6467896693ygrp-lc {font-family:Arial;}#yiv6467896693 #yiv6467896693ygrp-sponsor #yiv6467896693ygrp-lc #yiv6467896693hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6467896693 #yiv6467896693ygrp-sponsor #yiv6467896693ygrp-lc .yiv6467896693ad {margin-bottom:10px;padding:0 0;}#yiv6467896693 #yiv6467896693actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6467896693 #yiv6467896693activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6467896693 #yiv6467896693activity span {font-weight:700;}#yiv6467896693 #yiv6467896693activity span:first-child {text-transform:uppercase;}#yiv6467896693 #yiv6467896693activity span a {color:#5085b6;text-decoration:none;}#yiv6467896693 #yiv6467896693activity span span {color:#ff7900;}#yiv6467896693 #yiv6467896693activity span .yiv6467896693underline {text-decoration:underline;}#yiv6467896693 .yiv6467896693attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv6467896693 .yiv6467896693attach div a {text-decoration:none;}#yiv6467896693 .yiv6467896693attach img {border:none;padding-right:5px;}#yiv6467896693 .yiv6467896693attach label {display:block;margin-bottom:5px;}#yiv6467896693 .yiv6467896693attach label a {text-decoration:none;}#yiv6467896693 blockquote {margin:0 0 0 4px;}#yiv6467896693 .yiv6467896693bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv6467896693 .yiv6467896693bold a {text-decoration:none;}#yiv6467896693 dd.yiv6467896693last p a {font-family:Verdana;font-weight:700;}#yiv6467896693 dd.yiv6467896693last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6467896693 dd.yiv6467896693last p span.yiv6467896693yshortcuts {margin-right:0;}#yiv6467896693 div.yiv6467896693attach-table div div a {text-decoration:none;}#yiv6467896693 div.yiv6467896693attach-table {width:400px;}#yiv6467896693 div.yiv6467896693file-title a, #yiv6467896693 div.yiv6467896693file-title a:active, #yiv6467896693 div.yiv6467896693file-title a:hover, #yiv6467896693 div.yiv6467896693file-title a:visited {text-decoration:none;}#yiv6467896693 div.yiv6467896693photo-title a, #yiv6467896693 div.yiv6467896693photo-title a:active, #yiv6467896693 div.yiv6467896693photo-title a:hover, #yiv6467896693 div.yiv6467896693photo-title a:visited {text-decoration:none;}#yiv6467896693 div#yiv6467896693ygrp-mlmsg #yiv6467896693ygrp-msg p a span.yiv6467896693yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6467896693 .yiv6467896693green {color:#628c2a;}#yiv6467896693 .yiv6467896693MsoNormal {margin:0 0 0 0;}#yiv6467896693 o {font-size:0;}#yiv6467896693 #yiv6467896693photos div {float:left;width:72px;}#yiv6467896693 #yiv6467896693photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv6467896693 #yiv6467896693photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6467896693 #yiv6467896693reco-category {font-size:77%;}#yiv6467896693 #yiv6467896693reco-desc {font-size:77%;}#yiv6467896693 .yiv6467896693replbq {margin:4px;}#yiv6467896693 #yiv6467896693ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv6467896693 #yiv6467896693ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6467896693 #yiv6467896693ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6467896693 #yiv6467896693ygrp-mlmsg select, #yiv6467896693 input, #yiv6467896693 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv6467896693 #yiv6467896693ygrp-mlmsg pre, #yiv6467896693 code {font:115% monospace;}#yiv6467896693 #yiv6467896693ygrp-mlmsg * {line-height:1.22em;}#yiv6467896693 #yiv6467896693ygrp-mlmsg #yiv6467896693logo {padding-bottom:10px;}#yiv6467896693 #yiv6467896693ygrp-msg p a {font-family:Verdana;}#yiv6467896693 #yiv6467896693ygrp-msg p#yiv6467896693attach-count span {color:#1E66AE;font-weight:700;}#yiv6467896693 #yiv6467896693ygrp-reco #yiv6467896693reco-head {color:#ff7900;font-weight:700;}#yiv6467896693 #yiv6467896693ygrp-reco {margin-bottom:20px;padding:0px;}#yiv6467896693 #yiv6467896693ygrp-sponsor #yiv6467896693ov li a {font-size:130%;text-decoration:none;}#yiv6467896693 #yiv6467896693ygrp-sponsor #yiv6467896693ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv6467896693 #yiv6467896693ygrp-sponsor #yiv6467896693ov ul {margin:0;padding:0 0 0 8px;}#yiv6467896693 #yiv6467896693ygrp-text {font-family:Georgia;}#yiv6467896693 #yiv6467896693ygrp-text p {margin:0 0 1em 0;}#yiv6467896693 #yiv6467896693ygrp-text tt {font-size:120%;}#yiv6467896693 #yiv6467896693ygrp-vital ul li:last-child {border-right:none !important;}#yiv6467896693

   
Reply | Threaded
Open this post in threaded view
|

Bls: [belajar-excel] ( TANYA ) BAGAIMANA CARA MENCARI DATA BASE DENGAN 2 KRITARIA

od212
In reply to this post by makdo marbun-2
baca ini.
 
|  
|  
|  
|   |    |

   |

  |
|  
|   |  
Formula filter data (filtering formula)
 Coretan Mr. Kid tentang Microsoft Excel  |   |

  |

  |

 
 br,

odong nando


      Dari: "makdo marbun [hidden email] [belajar-excel]" <[hidden email]>
 Kepada: [hidden email]
 Dikirim: Sabtu, 3 November 2018 15:33
 Judul: Re: [belajar-excel] ( TANYA ) BAGAIMANA CARA MENCARI DATA BASE DENGAN 2 KRITARIA
   
    besar harapan saya pakai rumus pak biar atomatis cuman saya enggak bisa

mohon bantuannya

Pada tanggal 03/11/18, Eira I Arie [hidden email]
[belajar-excel] <[hidden email]> menulis:

> selamat pagi ..coba pakai fitur excel PIVOT TABLE kang ..di kasus sebelumnya
> ada permasalahan yang mirip ..
>
>
> On Saturday, November 3, 2018, 10:59:25 AM GMT+7, makdo marbun
> [hidden email] [belajar-excel] <[hidden email]> wrote:
>
>
>
>
> dear kawan kawan dan om momod
> selamat pagi dan semangat pagi
> saya Mohon bantuannya semua untuk mempermudah pekerjaan saya .
> jadi saya punya database karyawan yang cukup banyak namun sih manual..
> agar suatu saat data di perlukan oleh atasan siap sajimaka saya perlu
> meemikirkan cara terbaik
> misalkan jika atasan minta sbb:
> 1. jumlah karyawan yang ada di devisi dengan dept terpilih2. atau
> jumlah karyawan dept dengan kriteria masa kontrak3. dll
>
>
> data terlampir mohon bantuanya. jika ada yang mau di tambahkan atau
> modifikasi untuk lebih baik saya sangat berterimakasih
> Tks
> #yiv7329184384 #yiv7329184384 -- #yiv7329184384ygrp-mkp {border:1px solid
> #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7329184384
> #yiv7329184384ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7329184384
> #yiv7329184384ygrp-mkp #yiv7329184384hd
> {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
> 0;}#yiv7329184384 #yiv7329184384ygrp-mkp #yiv7329184384ads
> {margin-bottom:10px;}#yiv7329184384 #yiv7329184384ygrp-mkp .yiv7329184384ad
> {padding:0 0;}#yiv7329184384 #yiv7329184384ygrp-mkp .yiv7329184384ad p
> {margin:0;}#yiv7329184384 #yiv7329184384ygrp-mkp .yiv7329184384ad a
> {color:#0000ff;text-decoration:none;}#yiv7329184384
> #yiv7329184384ygrp-sponsor #yiv7329184384ygrp-lc
> {font-family:Arial;}#yiv7329184384 #yiv7329184384ygrp-sponsor
> #yiv7329184384ygrp-lc #yiv7329184384hd {margin:10px
> 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7329184384
> #yiv7329184384ygrp-sponsor #yiv7329184384ygrp-lc .yiv7329184384ad
> {margin-bottom:10px;padding:0 0;}#yiv7329184384 #yiv7329184384actions
> {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7329184384
> #yiv7329184384activity
> {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7329184384
> #yiv7329184384activity span {font-weight:700;}#yiv7329184384
> #yiv7329184384activity span:first-child
> {text-transform:uppercase;}#yiv7329184384 #yiv7329184384activity span a
> {color:#5085b6;text-decoration:none;}#yiv7329184384 #yiv7329184384activity
> span span {color:#ff7900;}#yiv7329184384 #yiv7329184384activity span
> .yiv7329184384underline {text-decoration:underline;}#yiv7329184384
> .yiv7329184384attach
> {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
> 0;width:400px;}#yiv7329184384 .yiv7329184384attach div a
> {text-decoration:none;}#yiv7329184384 .yiv7329184384attach img
> {border:none;padding-right:5px;}#yiv7329184384 .yiv7329184384attach label
> {display:block;margin-bottom:5px;}#yiv7329184384 .yiv7329184384attach label
> a {text-decoration:none;}#yiv7329184384 blockquote {margin:0 0 0
> 4px;}#yiv7329184384 .yiv7329184384bold
> {font-family:Arial;font-size:13px;font-weight:700;}#yiv7329184384
> .yiv7329184384bold a {text-decoration:none;}#yiv7329184384
> dd.yiv7329184384last p a
> {font-family:Verdana;font-weight:700;}#yiv7329184384 dd.yiv7329184384last p
> span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7329184384
> dd.yiv7329184384last p span.yiv7329184384yshortcuts
> {margin-right:0;}#yiv7329184384 div.yiv7329184384attach-table div div a
> {text-decoration:none;}#yiv7329184384 div.yiv7329184384attach-table
> {width:400px;}#yiv7329184384 div.yiv7329184384file-title a, #yiv7329184384
> div.yiv7329184384file-title a:active, #yiv7329184384
> div...yiv7329184384file-title a:hover, #yiv7329184384
> div.yiv7329184384file-title a:visited {text-decoration:none;}#yiv7329184384
> div.yiv7329184384photo-title a, #yiv7329184384 div.yiv7329184384photo-title
> a:active, #yiv7329184384 div.yiv7329184384photo-title a:hover,
> #yiv7329184384 div.yiv7329184384photo-title a:visited
> {text-decoration:none;}#yiv7329184384 div#yiv7329184384ygrp-mlmsg
> #yiv7329184384ygrp-msg p a span.yiv7329184384yshortcuts
> {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7329184384
> .yiv7329184384green {color:#628c2a;}#yiv7329184384 .yiv7329184384MsoNormal
> {margin:0 0 0 0;}#yiv7329184384 o {font-size:0;}#yiv7329184384
> #yiv7329184384photos div {float:left;width:72px;}#yiv7329184384
> #yiv7329184384photos div div {border:1px solid
> #666666;min-height:62px;overflow:hidden;width:62px;}#yiv7329184384
> #yiv7329184384photos div label
> {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7329184384
> #yiv7329184384reco-category {font-size:77%;}#yiv7329184384
> #yiv7329184384reco-desc {font-size:77%;}#yiv7329184384 .yiv7329184384replbq
> {margin:4px;}#yiv7329184384 #yiv7329184384ygrp-actbar div a:first-child
> {margin-right:2px;padding-right:5px;}#yiv7329184384 #yiv7329184384ygrp-mlmsg
> {font-size:13px;font-family:Arial, helvetica, clean,
> sans-serif;}#yiv7329184384 #yiv7329184384ygrp-mlmsg table
> {font-size:inherit;font:100%;}#yiv7329184384 #yiv7329184384ygrp-mlmsg
> select, #yiv7329184384 input, #yiv7329184384 textarea {font:99% Arial,
> Helvetica, clean, sans-serif;}#yiv7329184384 #yiv7329184384ygrp-mlmsg pre,
> #yiv7329184384 code {font:115% monospace;}#yiv7329184384
> #yiv7329184384ygrp-mlmsg * {line-height:1.22em;}#yiv7329184384
> #yiv7329184384ygrp-mlmsg #yiv7329184384logo
> {padding-bottom:10px;}#yiv7329184384 #yiv7329184384ygrp-msg p a
> {font-family:Verdana;}#yiv7329184384 #yiv7329184384ygrp-msg
> p#yiv7329184384attach-count span
> {color:#1E66AE;font-weight:700;}#yiv7329184384 #yiv7329184384ygrp-reco
> #yiv7329184384reco-head {color:#ff7900;font-weight:700;}#yiv7329184384
> #yiv7329184384ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7329184384
> #yiv7329184384ygrp-sponsor #yiv7329184384ov li a
> {font-size:130%;text-decoration:none;}#yiv7329184384
> #yiv7329184384ygrp-sponsor #yiv7329184384ov li
> {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7329184384
> #yiv7329184384ygrp-sponsor #yiv7329184384ov ul {margin:0;padding:0 0 0
> 8px;}#yiv7329184384 #yiv7329184384ygrp-text
> {font-family:Georgia;}#yiv7329184384 #yiv7329184384ygrp-text p {margin:0 0
> 1em 0;}#yiv7329184384 #yiv7329184384ygrp-text tt
> {font-size:120%;}#yiv7329184384 #yiv7329184384ygrp-vital ul li:last-child
> {border-right:none !important;}#yiv7329184384
  #yiv7949611810 #yiv7949611810 -- #yiv7949611810ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7949611810 #yiv7949611810ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7949611810 #yiv7949611810ygrp-mkp #yiv7949611810hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7949611810 #yiv7949611810ygrp-mkp #yiv7949611810ads {margin-bottom:10px;}#yiv7949611810 #yiv7949611810ygrp-mkp .yiv7949611810ad {padding:0 0;}#yiv7949611810 #yiv7949611810ygrp-mkp .yiv7949611810ad p {margin:0;}#yiv7949611810 #yiv7949611810ygrp-mkp .yiv7949611810ad a {color:#0000ff;text-decoration:none;}#yiv7949611810 #yiv7949611810ygrp-sponsor #yiv7949611810ygrp-lc {font-family:Arial;}#yiv7949611810 #yiv7949611810ygrp-sponsor #yiv7949611810ygrp-lc #yiv7949611810hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7949611810 #yiv7949611810ygrp-sponsor #yiv7949611810ygrp-lc .yiv7949611810ad {margin-bottom:10px;padding:0 0;}#yiv7949611810 #yiv7949611810actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7949611810 #yiv7949611810activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7949611810 #yiv7949611810activity span {font-weight:700;}#yiv7949611810 #yiv7949611810activity span:first-child {text-transform:uppercase;}#yiv7949611810 #yiv7949611810activity span a {color:#5085b6;text-decoration:none;}#yiv7949611810 #yiv7949611810activity span span {color:#ff7900;}#yiv7949611810 #yiv7949611810activity span .yiv7949611810underline {text-decoration:underline;}#yiv7949611810 .yiv7949611810attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7949611810 .yiv7949611810attach div a {text-decoration:none;}#yiv7949611810 .yiv7949611810attach img {border:none;padding-right:5px;}#yiv7949611810 .yiv7949611810attach label {display:block;margin-bottom:5px;}#yiv7949611810 .yiv7949611810attach label a {text-decoration:none;}#yiv7949611810 blockquote {margin:0 0 0 4px;}#yiv7949611810 .yiv7949611810bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7949611810 .yiv7949611810bold a {text-decoration:none;}#yiv7949611810 dd.yiv7949611810last p a {font-family:Verdana;font-weight:700;}#yiv7949611810 dd.yiv7949611810last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7949611810 dd.yiv7949611810last p span.yiv7949611810yshortcuts {margin-right:0;}#yiv7949611810 div.yiv7949611810attach-table div div a {text-decoration:none;}#yiv7949611810 div.yiv7949611810attach-table {width:400px;}#yiv7949611810 div.yiv7949611810file-title a, #yiv7949611810 div.yiv7949611810file-title a:active, #yiv7949611810 div.yiv7949611810file-title a:hover, #yiv7949611810 div.yiv7949611810file-title a:visited {text-decoration:none;}#yiv7949611810 div.yiv7949611810photo-title a, #yiv7949611810 div.yiv7949611810photo-title a:active, #yiv7949611810 div.yiv7949611810photo-title a:hover, #yiv7949611810 div.yiv7949611810photo-title a:visited {text-decoration:none;}#yiv7949611810 div#yiv7949611810ygrp-mlmsg #yiv7949611810ygrp-msg p a span.yiv7949611810yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7949611810 .yiv7949611810green {color:#628c2a;}#yiv7949611810 .yiv7949611810MsoNormal {margin:0 0 0 0;}#yiv7949611810 o {font-size:0;}#yiv7949611810 #yiv7949611810photos div {float:left;width:72px;}#yiv7949611810 #yiv7949611810photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv7949611810 #yiv7949611810photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7949611810 #yiv7949611810reco-category {font-size:77%;}#yiv7949611810 #yiv7949611810reco-desc {font-size:77%;}#yiv7949611810 .yiv7949611810replbq {margin:4px;}#yiv7949611810 #yiv7949611810ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv7949611810 #yiv7949611810ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7949611810 #yiv7949611810ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7949611810 #yiv7949611810ygrp-mlmsg select, #yiv7949611810 input, #yiv7949611810 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv7949611810 #yiv7949611810ygrp-mlmsg pre, #yiv7949611810 code {font:115% monospace;}#yiv7949611810 #yiv7949611810ygrp-mlmsg * {line-height:1.22em;}#yiv7949611810 #yiv7949611810ygrp-mlmsg #yiv7949611810logo {padding-bottom:10px;}#yiv7949611810 #yiv7949611810ygrp-msg p a {font-family:Verdana;}#yiv7949611810 #yiv7949611810ygrp-msg p#yiv7949611810attach-count span {color:#1E66AE;font-weight:700;}#yiv7949611810 #yiv7949611810ygrp-reco #yiv7949611810reco-head {color:#ff7900;font-weight:700;}#yiv7949611810 #yiv7949611810ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7949611810 #yiv7949611810ygrp-sponsor #yiv7949611810ov li a {font-size:130%;text-decoration:none;}#yiv7949611810 #yiv7949611810ygrp-sponsor #yiv7949611810ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7949611810 #yiv7949611810ygrp-sponsor #yiv7949611810ov ul {margin:0;padding:0 0 0 8px;}#yiv7949611810 #yiv7949611810ygrp-text {font-family:Georgia;}#yiv7949611810 #yiv7949611810ygrp-text p {margin:0 0 1em 0;}#yiv7949611810 #yiv7949611810ygrp-text tt {font-size:120%;}#yiv7949611810 #yiv7949611810ygrp-vital ul li:last-child {border-right:none !important;}#yiv7949611810

   
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] ( TANYA ) BAGAIMANA CARA MENCARI DATA BASE DENGAN 2 KRITARIA

makdo marbun-2
dear para suhu  dan om Momod terimkasih

case saya solved atas bantuan kalian

terimkasih dan sukses selalu

Pada tanggal Sen, 5 Nov 2018 pukul 17.18 odong nando [hidden email]
[belajar-excel] <belajar-excel@yahoogroups...com> menulis:

>
>
> baca ini.
> <http://excel-mr-kid.blogspot.com/2011/04/formula-filter-data-filtering-formula.html>
>
> Formula filter data (filtering formula)
> Coretan Mr. Kid tentang Microsoft Excel
>
> <http://excel-mr-kid.blogspot.com/2011/04/formula-filter-data-filtering-formula.html>
>
>
> br,
>
> odong nando
>
>
> ------------------------------
> *Dari:* "makdo marbun [hidden email] [belajar-excel]" <
> [hidden email]>
> *Kepada:* [hidden email]
> *Dikirim:* Sabtu, 3 November 2018 15:33
> *Judul:* Re: [belajar-excel] ( TANYA ) BAGAIMANA CARA MENCARI DATA BASE
> DENGAN 2 KRITARIA
>
>
> besar harapan saya pakai rumus pak biar atomatis cuman saya enggak bisa
>
> mohon bantuannya
>
> Pada tanggal 03/11/18, Eira I Arie [hidden email]
> [belajar-excel] <[hidden email]> menulis:
> > selamat pagi ..coba pakai fitur excel PIVOT TABLE kang ..di kasus
> sebelumnya
> > ada permasalahan yang mirip ..
> >
> >
> > On Saturday, November 3, 2018, 10:59:25 AM GMT+7, makdo marbun
> > [hidden email] [belajar-excel] <[hidden email]>
> wrote:
> >
> >
> >
> >
> > dear kawan kawan dan om momod
> > selamat pagi dan semangat pagi
> > saya Mohon bantuannya semua untuk mempermudah pekerjaan saya .
> > jadi saya punya database karyawan yang cukup banyak namun sih manual..
> > agar suatu saat data di perlukan oleh atasan siap sajimaka saya perlu
> > meemikirkan cara terbaik
> > misalkan jika atasan minta sbb:
> > 1. jumlah karyawan yang ada di devisi dengan dept terpilih2. atau
> > jumlah karyawan dept dengan kriteria masa kontrak3. dll
> >
> >
> > data terlampir mohon bantuanya. jika ada yang mau di tambahkan atau
> > modifikasi untuk lebih baik saya sangat berterimakasih
> > Tks
> > #yiv7329184384 #yiv7329184384 -- #yiv7329184384ygrp-mkp {border:1px solid
> > #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7329184384
> > #yiv7329184384ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7329184384
> > #yiv7329184384ygrp-mkp #yiv7329184384hd
> > {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
> > 0;}#yiv7329184384 #yiv7329184384ygrp-mkp #yiv7329184384ads
> > {margin-bottom:10px;}#yiv7329184384 #yiv7329184384ygrp-mkp
> .yiv7329184384ad
> > {padding:0 0;}#yiv7329184384 #yiv7329184384ygrp-mkp .yiv7329184384ad p
> > {margin:0;}#yiv7329184384 #yiv7329184384ygrp-mkp .yiv7329184384ad a
> > {color:#0000ff;text-decoration:none;}#yiv7329184384
> > #yiv7329184384ygrp-sponsor #yiv7329184384ygrp-lc
> > {font-family:Arial;}#yiv7329184384 #yiv7329184384ygrp-sponsor
> > #yiv7329184384ygrp-lc #yiv7329184384hd {margin:10px
> > 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7329184384
> > #yiv7329184384ygrp-sponsor #yiv7329184384ygrp-lc .yiv7329184384ad
> > {margin-bottom:10px;padding:0 0;}#yiv7329184384 #yiv7329184384actions
> > {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7329184384
> > #yiv7329184384activity
> >
> {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7329184384
> > #yiv7329184384activity span {font-weight:700;}#yiv7329184384
> > #yiv7329184384activity span:first-child
> > {text-transform:uppercase;}#yiv7329184384 #yiv7329184384activity span a
> > {color:#5085b6;text-decoration:none;}#yiv7329184384
> #yiv7329184384activity
> > span span {color:#ff7900;}#yiv7329184384 #yiv7329184384activity span
> > .yiv7329184384underline {text-decoration:underline;}#yiv7329184384
> > .yiv7329184384attach
> > {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
> > 0;width:400px;}#yiv7329184384 .yiv7329184384attach div a
> > {text-decoration:none;}#yiv7329184384 .yiv7329184384attach img
> > {border:none;padding-right:5px;}#yiv7329184384 .yiv7329184384attach label
> > {display:block;margin-bottom:5px;}#yiv7329184384 .yiv7329184384attach
> label
> > a {text-decoration:none;}#yiv7329184384 blockquote {margin:0 0 0
> > 4px;}#yiv7329184384 .yiv7329184384bold
> > {font-family:Arial;font-size:13px;font-weight:700;}#yiv7329184384
> > .yiv7329184384bold a {text-decoration:none;}#yiv7329184384
> > dd.yiv7329184384last p a
> > {font-family:Verdana;font-weight:700;}#yiv7329184384
> dd.yiv7329184384last p
> > span
> {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7329184384
> > dd.yiv7329184384last p span.yiv7329184384yshortcuts
> > {margin-right:0;}#yiv7329184384 div.yiv7329184384attach-table div div a
> > {text-decoration:none;}#yiv7329184384 div.yiv7329184384attach-table
> > {width:400px;}#yiv7329184384 div.yiv7329184384file-title a,
> #yiv7329184384
> > div.yiv7329184384file-title a:active, #yiv7329184384
> > div.....yiv7329184384file-title a:hover, #yiv7329184384
> > div.yiv7329184384file-title a:visited
> {text-decoration:none;}#yiv7329184384
> > div.yiv7329184384photo-title a, #yiv7329184384
> div.yiv7329184384photo-title
> > a:active, #yiv7329184384 div.yiv7329184384photo-title a:hover,
> > #yiv7329184384 div.yiv7329184384photo-title a:visited
> > {text-decoration:none;}#yiv7329184384 div#yiv7329184384ygrp-mlmsg
> > #yiv7329184384ygrp-msg p a span.yiv7329184384yshortcuts
> > {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7329184384
> > .yiv7329184384green {color:#628c2a;}#yiv7329184384
> .yiv7329184384MsoNormal
> > {margin:0 0 0 0;}#yiv7329184384 o {font-size:0;}#yiv7329184384
> > #yiv7329184384photos div {float:left;width:72px;}#yiv7329184384
> > #yiv7329184384photos div div {border:1px solid
> > #666666;min-height:62px;overflow:hidden;width:62px;}#yiv7329184384
> > #yiv7329184384photos div label
> >
> {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7329184384
> > #yiv7329184384reco-category {font-size:77%;}#yiv7329184384
> > #yiv7329184384reco-desc {font-size:77%;}#yiv7329184384
> .yiv7329184384replbq
> > {margin:4px;}#yiv7329184384 #yiv7329184384ygrp-actbar div a:first-child
> > {margin-right:2px;padding-right:5px;}#yiv7329184384
> #yiv7329184384ygrp-mlmsg
> > {font-size:13px;font-family:Arial, helvetica, clean,
> > sans-serif;}#yiv7329184384 #yiv7329184384ygrp-mlmsg table
> > {font-size:inherit;font:100%;}#yiv7329184384 #yiv7329184384ygrp-mlmsg
> > select, #yiv7329184384 input, #yiv7329184384 textarea {font:99% Arial,
> > Helvetica, clean, sans-serif;}#yiv7329184384 #yiv7329184384ygrp-mlmsg
> pre,
> > #yiv7329184384 code {font:115% monospace;}#yiv7329184384
> > #yiv7329184384ygrp-mlmsg * {line-height:1.22em;}#yiv7329184384
> > #yiv7329184384ygrp-mlmsg #yiv7329184384logo
> > {padding-bottom:10px;}#yiv7329184384 #yiv7329184384ygrp-msg p a
> > {font-family:Verdana;}#yiv7329184384 #yiv7329184384ygrp-msg
> > p#yiv7329184384attach-count span
> > {color:#1E66AE;font-weight:700;}#yiv7329184384 #yiv7329184384ygrp-reco
> > #yiv7329184384reco-head {color:#ff7900;font-weight:700;}#yiv7329184384
> > #yiv7329184384ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7329184384
> > #yiv7329184384ygrp-sponsor #yiv7329184384ov li a
> > {font-size:130%;text-decoration:none;}#yiv7329184384
> > #yiv7329184384ygrp-sponsor #yiv7329184384ov li
> > {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7329184384
> > #yiv7329184384ygrp-sponsor #yiv7329184384ov ul {margin:0;padding:0 0 0
> > 8px;}#yiv7329184384 #yiv7329184384ygrp-text
> > {font-family:Georgia;}#yiv7329184384 #yiv7329184384ygrp-text p {margin:0
> 0
> > 1em 0;}#yiv7329184384 #yiv7329184384ygrp-text tt
> > {font-size:120%;}#yiv7329184384 #yiv7329184384ygrp-vital ul li:last-child
> > {border-right:none !important;}#yiv7329184384
>
>
>
>