[belajar-excel] Mengambil data yg sama dalam satu tabel [1 Attachment]

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

[belajar-excel] Mengambil data yg sama dalam satu tabel [1 Attachment]

fathianm
mhn bantuannya...formula untuk mengambil data yg sama gimana ya? (sulit jelasinnya ) file terlampir

DATA.xlsx (18K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Mengambil data yg sama dalam satu tabel

Eira_ariE
Selamat sore ..
silakan dicoba pakai PIVOT TABLE ..
terlebih dahulu tabel data (sumber data) diset EXCEL TABLE ..lalu buat PIVOT TABLE berdasar sumber data tadi ..


    On Thursday, November 1, 2018, 2:40:25 PM GMT+7, [hidden email] [belajar-excel] <[hidden email]> wrote:

  


mhn bantuannya...formula untuk mengambil data yg sama gimana ya? (sulit jelasinnya ) file terlampir
  #yiv9258158189 #yiv9258158189 -- #yiv9258158189ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9258158189 #yiv9258158189ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9258158189 #yiv9258158189ygrp-mkp #yiv9258158189hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv9258158189 #yiv9258158189ygrp-mkp #yiv9258158189ads {margin-bottom:10px;}#yiv9258158189 #yiv9258158189ygrp-mkp .yiv9258158189ad {padding:0 0;}#yiv9258158189 #yiv9258158189ygrp-mkp .yiv9258158189ad p {margin:0;}#yiv9258158189 #yiv9258158189ygrp-mkp .yiv9258158189ad a {color:#0000ff;text-decoration:none;}#yiv9258158189 #yiv9258158189ygrp-sponsor #yiv9258158189ygrp-lc {font-family:Arial;}#yiv9258158189 #yiv9258158189ygrp-sponsor #yiv9258158189ygrp-lc #yiv9258158189hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9258158189 #yiv9258158189ygrp-sponsor #yiv9258158189ygrp-lc .yiv9258158189ad {margin-bottom:10px;padding:0 0;}#yiv9258158189 #yiv9258158189actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9258158189 #yiv9258158189activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9258158189 #yiv9258158189activity span {font-weight:700;}#yiv9258158189 #yiv9258158189activity span:first-child {text-transform:uppercase;}#yiv9258158189 #yiv9258158189activity span a {color:#5085b6;text-decoration:none;}#yiv9258158189 #yiv9258158189activity span span {color:#ff7900;}#yiv9258158189 #yiv9258158189activity span .yiv9258158189underline {text-decoration:underline;}#yiv9258158189 .yiv9258158189attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv9258158189 .yiv9258158189attach div a {text-decoration:none;}#yiv9258158189 .yiv9258158189attach img {border:none;padding-right:5px;}#yiv9258158189 .yiv9258158189attach label {display:block;margin-bottom:5px;}#yiv9258158189 .yiv9258158189attach label a {text-decoration:none;}#yiv9258158189 blockquote {margin:0 0 0 4px;}#yiv9258158189 .yiv9258158189bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv9258158189 .yiv9258158189bold a {text-decoration:none;}#yiv9258158189 dd.yiv9258158189last p a {font-family:Verdana;font-weight:700;}#yiv9258158189 dd.yiv9258158189last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9258158189 dd.yiv9258158189last p span.yiv9258158189yshortcuts {margin-right:0;}#yiv9258158189 div.yiv9258158189attach-table div div a {text-decoration:none;}#yiv9258158189 div.yiv9258158189attach-table {width:400px;}#yiv9258158189 div.yiv9258158189file-title a, #yiv9258158189 div.yiv9258158189file-title a:active, #yiv9258158189 div.yiv9258158189file-title a:hover, #yiv9258158189 div.yiv9258158189file-title a:visited {text-decoration:none;}#yiv9258158189 div.yiv9258158189photo-title a, #yiv9258158189 div.yiv9258158189photo-title a:active, #yiv9258158189 div.yiv9258158189photo-title a:hover, #yiv9258158189 div.yiv9258158189photo-title a:visited {text-decoration:none;}#yiv9258158189 div#yiv9258158189ygrp-mlmsg #yiv9258158189ygrp-msg p a span.yiv9258158189yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9258158189 .yiv9258158189green {color:#628c2a;}#yiv9258158189 .yiv9258158189MsoNormal {margin:0 0 0 0;}#yiv9258158189 o {font-size:0;}#yiv9258158189 #yiv9258158189photos div {float:left;width:72px;}#yiv9258158189 #yiv9258158189photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv9258158189 #yiv9258158189photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9258158189 #yiv9258158189reco-category {font-size:77%;}#yiv9258158189 #yiv9258158189reco-desc {font-size:77%;}#yiv9258158189 .yiv9258158189replbq {margin:4px;}#yiv9258158189 #yiv9258158189ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv9258158189 #yiv9258158189ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9258158189 #yiv9258158189ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9258158189 #yiv9258158189ygrp-mlmsg select, #yiv9258158189 input, #yiv9258158189 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv9258158189 #yiv9258158189ygrp-mlmsg pre, #yiv9258158189 code {font:115% monospace;}#yiv9258158189 #yiv9258158189ygrp-mlmsg * {line-height:1.22em;}#yiv9258158189 #yiv9258158189ygrp-mlmsg #yiv9258158189logo {padding-bottom:10px;}#yiv9258158189 #yiv9258158189ygrp-msg p a {font-family:Verdana;}#yiv9258158189 #yiv9258158189ygrp-msg p#yiv9258158189attach-count span {color:#1E66AE;font-weight:700;}#yiv9258158189 #yiv9258158189ygrp-reco #yiv9258158189reco-head {color:#ff7900;font-weight:700;}#yiv9258158189 #yiv9258158189ygrp-reco {margin-bottom:20px;padding:0px;}#yiv9258158189 #yiv9258158189ygrp-sponsor #yiv9258158189ov li a {font-size:130%;text-decoration:none;}#yiv9258158189 #yiv9258158189ygrp-sponsor #yiv9258158189ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv9258158189 #yiv9258158189ygrp-sponsor #yiv9258158189ov ul {margin:0;padding:0 0 0 8px;}#yiv9258158189 #yiv9258158189ygrp-text {font-family:Georgia;}#yiv9258158189 #yiv9258158189ygrp-text p {margin:0 0 1em 0;}#yiv9258158189 #yiv9258158189ygrp-text tt {font-size:120%;}#yiv9258158189 #yiv9258158189ygrp-vital ul li:last-child {border-right:none !important;}#yiv9258158189
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Mengambil data yg sama dalam satu tabel [1 Attachment]

ghery yen
In reply to this post by fathianm
Haduh, sambil menunggu para suhu, pakai Pivot table boleh kan ya ?!

On Thu, Nov 1, 2018 at 2:40 PM [hidden email] [belajar-excel] <
[hidden email]> wrote:

>
>
> mhn bantuannya...formula untuk mengambil data yg sama gimana ya? (sulit
> jelasinnya ) file terlampir
>
>

DATA - Edited Heri.xlsx (24K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Mengambil data yg sama dalam satu tabel

fathianm
terimakasih sebelumnya Suhu Heri...pernah jg lihat2 pake pivot kyke kurang rapi gitu, klo pake formula gimana ya formulanya? sampe td mlm trial blm bisa jg
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Mengambil data yg sama dalam satu tabel

ghozi alkatiri
In reply to this post by ghery yen
 hapus dulu format merge & center pada  cell B17 s/d B22  tulis formula di B17 
(formula array )=IFERROR(INDEX($B$4:$B$13,SMALL(IF($P$4:$P$13="tidak naik",$A$4:$A$13),A17)),"")
copy ke bawah
wassalam
Ghozi Alkatiri
 
    Pada Kamis, 1 November 2018 15.46.27 WIB, ghery yen [hidden email] [belajar-excel] <[hidden email]> menulis:  
 
    

Haduh, sambil menunggu para suhu, pakai Pivot table boleh kan ya ?!

On Thu, Nov 1, 2018 at 2:40 PM fathianm@yahoo..com [belajar-excel] <[hidden email]> wrote:

    


mhn bantuannya....formula untuk mengambil data yg sama gimana ya? (sulit jelasinnya ) file terlampir
   
  #yiv9352582079 #yiv9352582079 -- #yiv9352582079ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9352582079 #yiv9352582079ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9352582079 #yiv9352582079ygrp-mkp #yiv9352582079hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv9352582079 #yiv9352582079ygrp-mkp #yiv9352582079ads {margin-bottom:10px;}#yiv9352582079 #yiv9352582079ygrp-mkp .yiv9352582079ad {padding:0 0;}#yiv9352582079 #yiv9352582079ygrp-mkp .yiv9352582079ad p {margin:0;}#yiv9352582079 #yiv9352582079ygrp-mkp .yiv9352582079ad a {color:#0000ff;text-decoration:none;}#yiv9352582079 #yiv9352582079ygrp-sponsor #yiv9352582079ygrp-lc {font-family:Arial;}#yiv9352582079 #yiv9352582079ygrp-sponsor #yiv9352582079ygrp-lc #yiv9352582079hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9352582079 #yiv9352582079ygrp-sponsor #yiv9352582079ygrp-lc .yiv9352582079ad {margin-bottom:10px;padding:0 0;}#yiv9352582079 #yiv9352582079actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9352582079 #yiv9352582079activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9352582079 #yiv9352582079activity span {font-weight:700;}#yiv9352582079 #yiv9352582079activity span:first-child {text-transform:uppercase;}#yiv9352582079 #yiv9352582079activity span a {color:#5085b6;text-decoration:none;}#yiv9352582079 #yiv9352582079activity span span {color:#ff7900;}#yiv9352582079 #yiv9352582079activity span .yiv9352582079underline {text-decoration:underline;}#yiv9352582079 .yiv9352582079attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv9352582079 .yiv9352582079attach div a {text-decoration:none;}#yiv9352582079 .yiv9352582079attach img {border:none;padding-right:5px;}#yiv9352582079 .yiv9352582079attach label {display:block;margin-bottom:5px;}#yiv9352582079 .yiv9352582079attach label a {text-decoration:none;}#yiv9352582079 blockquote {margin:0 0 0 4px;}#yiv9352582079 .yiv9352582079bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv9352582079 .yiv9352582079bold a {text-decoration:none;}#yiv9352582079 dd.yiv9352582079last p a {font-family:Verdana;font-weight:700;}#yiv9352582079 dd.yiv9352582079last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9352582079 dd.yiv9352582079last p span.yiv9352582079yshortcuts {margin-right:0;}#yiv9352582079 div.yiv9352582079attach-table div div a {text-decoration:none;}#yiv9352582079 div.yiv9352582079attach-table {width:400px;}#yiv9352582079 div.yiv9352582079file-title a, #yiv9352582079 div.yiv9352582079file-title a:active, #yiv9352582079 div.yiv9352582079file-title a:hover, #yiv9352582079 div.yiv9352582079file-title a:visited {text-decoration:none;}#yiv9352582079 div.yiv9352582079photo-title a, #yiv9352582079 div.yiv9352582079photo-title a:active, #yiv9352582079 div.yiv9352582079photo-title a:hover, #yiv9352582079 div.yiv9352582079photo-title a:visited {text-decoration:none;}#yiv9352582079 div#yiv9352582079ygrp-mlmsg #yiv9352582079ygrp-msg p a span.yiv9352582079yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9352582079 .yiv9352582079green {color:#628c2a;}#yiv9352582079 .yiv9352582079MsoNormal {margin:0 0 0 0;}#yiv9352582079 o {font-size:0;}#yiv9352582079 #yiv9352582079photos div {float:left;width:72px;}#yiv9352582079 #yiv9352582079photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv9352582079 #yiv9352582079photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9352582079 #yiv9352582079reco-category {font-size:77%;}#yiv9352582079 #yiv9352582079reco-desc {font-size:77%;}#yiv9352582079 .yiv9352582079replbq {margin:4px;}#yiv9352582079 #yiv9352582079ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv9352582079 #yiv9352582079ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9352582079 #yiv9352582079ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9352582079 #yiv9352582079ygrp-mlmsg select, #yiv9352582079 input, #yiv9352582079 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv9352582079 #yiv9352582079ygrp-mlmsg pre, #yiv9352582079 code {font:115% monospace;}#yiv9352582079 #yiv9352582079ygrp-mlmsg * {line-height:1.22em;}#yiv9352582079 #yiv9352582079ygrp-mlmsg #yiv9352582079logo {padding-bottom:10px;}#yiv9352582079 #yiv9352582079ygrp-msg p a {font-family:Verdana;}#yiv9352582079 #yiv9352582079ygrp-msg p#yiv9352582079attach-count span {color:#1E66AE;font-weight:700;}#yiv9352582079 #yiv9352582079ygrp-reco #yiv9352582079reco-head {color:#ff7900;font-weight:700;}#yiv9352582079 #yiv9352582079ygrp-reco {margin-bottom:20px;padding:0px;}#yiv9352582079 #yiv9352582079ygrp-sponsor #yiv9352582079ov li a {font-size:130%;text-decoration:none;}#yiv9352582079 #yiv9352582079ygrp-sponsor #yiv9352582079ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv9352582079 #yiv9352582079ygrp-sponsor #yiv9352582079ov ul {margin:0;padding:0 0 0 8px;}#yiv9352582079 #yiv9352582079ygrp-text {font-family:Georgia;}#yiv9352582079 #yiv9352582079ygrp-text p {margin:0 0 1em 0;}#yiv9352582079 #yiv9352582079ygrp-text tt {font-size:120%;}#yiv9352582079 #yiv9352582079ygrp-vital ul li:last-child {border-right:none !important;}#yiv9352582079  
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Mengambil data yg sama dalam satu tabel

fathianm
Hasilnya blank suhu Ghozi...

Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Mengambil data yg sama dalam satu tabel [1 Attachment]

ghery yen
In reply to this post by fathianm
Waduh, sampe malem. Luar biasa berkemauan keras..

Nah, sebenernya tu sampe mentok fitur excel ngga ada saya sebisa mungkin
minimal menggunakan Formula.
Agar "kalau kata Mr.Kid" memanusiakan Kalkulasi Komputer. Halah.......

Berikut kalau pakai kolom bantu boleh kan ya ?!

Atau masih ngga boleh ?!
_,_._,___

On Fri, Nov 2, 2018 at 10:41 AM [hidden email] [belajar-excel] <
[hidden email]> wrote:

>
>
> terimakasih sebelumnya Suhu Heri...pernah jg lihat2 pake pivot kyke kurang
> rapi gitu, klo pake formula gimana ya formulanya? sampe td mlm trial blm
> bisa jg
>
>

DATA - Edited Heri 2.xlsx (25K) Download Attachment
Kid
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Mengambil data yg sama dalam satu tabel

Kid
Administrator
In reply to this post by fathianm
mungkin belum ditata layoutnya, jadi hanya pakai layout (susunan) default.
bisa lebih spesifik seperti apa layout yang rapi itu dan seperti apa layout
yang kurang rapi tersebut ?

Ini contoh pivot table yang dibuat mas Gery, lalu ditata layout-nya
[image: Untitled-1.gif]
a. warna-warni bisa ditata dengan PivotTable Styles (ribbon Design -> grup
PivotTable Styles) [dalam ribbon, sisi kanan]
b. layout bisa ditata melalui grup menu Layout (ribbon Design -> grup
Layout) [dalam ribbon, sisi kiri
c. fields (kolom-kolom) yang akan ditampilkan bisa ditata melalui
PivotTable Field List yang ada dalam pane yang muncul di sisi kanan layar

Regards,
Kid







On Fri, Nov 2, 2018 at 10:40 AM [hidden email] [belajar-excel] <
[hidden email]> wrote:

>
>
> terimakasih sebelumnya Suhu Heri...pernah jg lihat2 pake pivot kyke kurang
> rapi gitu, klo pake formula gimana ya formulanya? sampe td mlm trial blm
> bisa jg
>
>

Untitled-1.gif (46K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Bls: [belajar-excel] Mengambil data yg sama dalam satu tabel [1 Attachment]

od212
In reply to this post by ghery yen
 br,

odong nando


      Dari: "ghery yen [hidden email] [belajar-excel]" <[hidden email]>
 Kepada: [hidden email]
 Dikirim: Kamis, 1 November 2018 15:45
 Judul: Re: [belajar-excel] Mengambil data yg sama dalam satu tabel [1 Attachment]
   
    Haduh, sambil menunggu para suhu, pakai Pivot table boleh kan ya ?!

On Thu, Nov 1, 2018 at 2:40 PM fathianm@yahoo..com [belajar-excel] <[hidden email]> wrote:

     mhn bantuannya....formula untuk mengambil data yg sama gimana ya? (sulit jelasinnya ) file terlampir  
  #yiv3825054894 #yiv3825054894 -- #yiv3825054894ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3825054894 #yiv3825054894ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3825054894 #yiv3825054894ygrp-mkp #yiv3825054894hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3825054894 #yiv3825054894ygrp-mkp #yiv3825054894ads {margin-bottom:10px;}#yiv3825054894 #yiv3825054894ygrp-mkp .yiv3825054894ad {padding:0 0;}#yiv3825054894 #yiv3825054894ygrp-mkp .yiv3825054894ad p {margin:0;}#yiv3825054894 #yiv3825054894ygrp-mkp .yiv3825054894ad a {color:#0000ff;text-decoration:none;}#yiv3825054894 #yiv3825054894ygrp-sponsor #yiv3825054894ygrp-lc {font-family:Arial;}#yiv3825054894 #yiv3825054894ygrp-sponsor #yiv3825054894ygrp-lc #yiv3825054894hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3825054894 #yiv3825054894ygrp-sponsor #yiv3825054894ygrp-lc .yiv3825054894ad {margin-bottom:10px;padding:0 0;}#yiv3825054894 #yiv3825054894actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3825054894 #yiv3825054894activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3825054894 #yiv3825054894activity span {font-weight:700;}#yiv3825054894 #yiv3825054894activity span:first-child {text-transform:uppercase;}#yiv3825054894 #yiv3825054894activity span a {color:#5085b6;text-decoration:none;}#yiv3825054894 #yiv3825054894activity span span {color:#ff7900;}#yiv3825054894 #yiv3825054894activity span .yiv3825054894underline {text-decoration:underline;}#yiv3825054894 .yiv3825054894attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3825054894 .yiv3825054894attach div a {text-decoration:none;}#yiv3825054894 .yiv3825054894attach img {border:none;padding-right:5px;}#yiv3825054894 .yiv3825054894attach label {display:block;margin-bottom:5px;}#yiv3825054894 .yiv3825054894attach label a {text-decoration:none;}#yiv3825054894 blockquote {margin:0 0 0 4px;}#yiv3825054894 .yiv3825054894bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3825054894 .yiv3825054894bold a {text-decoration:none;}#yiv3825054894 dd.yiv3825054894last p a {font-family:Verdana;font-weight:700;}#yiv3825054894 dd.yiv3825054894last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3825054894 dd.yiv3825054894last p span.yiv3825054894yshortcuts {margin-right:0;}#yiv3825054894 div.yiv3825054894attach-table div div a {text-decoration:none;}#yiv3825054894 div.yiv3825054894attach-table {width:400px;}#yiv3825054894 div.yiv3825054894file-title a, #yiv3825054894 div.yiv3825054894file-title a:active, #yiv3825054894 div.yiv3825054894file-title a:hover, #yiv3825054894 div.yiv3825054894file-title a:visited {text-decoration:none;}#yiv3825054894 div.yiv3825054894photo-title a, #yiv3825054894 div.yiv3825054894photo-title a:active, #yiv3825054894 div.yiv3825054894photo-title a:hover, #yiv3825054894 div.yiv3825054894photo-title a:visited {text-decoration:none;}#yiv3825054894 div#yiv3825054894ygrp-mlmsg #yiv3825054894ygrp-msg p a span.yiv3825054894yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3825054894 .yiv3825054894green {color:#628c2a;}#yiv3825054894 .yiv3825054894MsoNormal {margin:0 0 0 0;}#yiv3825054894 o {font-size:0;}#yiv3825054894 #yiv3825054894photos div {float:left;width:72px;}#yiv3825054894 #yiv3825054894photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv3825054894 #yiv3825054894photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3825054894 #yiv3825054894reco-category {font-size:77%;}#yiv3825054894 #yiv3825054894reco-desc {font-size:77%;}#yiv3825054894 .yiv3825054894replbq {margin:4px;}#yiv3825054894 #yiv3825054894ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3825054894 #yiv3825054894ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3825054894 #yiv3825054894ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3825054894 #yiv3825054894ygrp-mlmsg select, #yiv3825054894 input, #yiv3825054894 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3825054894 #yiv3825054894ygrp-mlmsg pre, #yiv3825054894 code {font:115% monospace;}#yiv3825054894 #yiv3825054894ygrp-mlmsg * {line-height:1.22em;}#yiv3825054894 #yiv3825054894ygrp-mlmsg #yiv3825054894logo {padding-bottom:10px;}#yiv3825054894 #yiv3825054894ygrp-msg p a {font-family:Verdana;}#yiv3825054894 #yiv3825054894ygrp-msg p#yiv3825054894attach-count span {color:#1E66AE;font-weight:700;}#yiv3825054894 #yiv3825054894ygrp-reco #yiv3825054894reco-head {color:#ff7900;font-weight:700;}#yiv3825054894 #yiv3825054894ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3825054894 #yiv3825054894ygrp-sponsor #yiv3825054894ov li a {font-size:130%;text-decoration:none;}#yiv3825054894 #yiv3825054894ygrp-sponsor #yiv3825054894ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3825054894 #yiv3825054894ygrp-sponsor #yiv3825054894ov ul {margin:0;padding:0 0 0 8px;}#yiv3825054894 #yiv3825054894ygrp-text {font-family:Georgia;}#yiv3825054894 #yiv3825054894ygrp-text p {margin:0 0 1em 0;}#yiv3825054894 #yiv3825054894ygrp-text tt {font-size:120%;}#yiv3825054894 #yiv3825054894ygrp-vital ul li:last-child {border-right:none !important;}#yiv3825054894

   

DATA (1)_od.xlsx (22K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Bls: [belajar-excel] Mengambil data yg sama dalam satu tabel [1 Attachment]

od212
In reply to this post by Kid
maaf boz kid, itu cara buat no urutnya gmn y...
hehe... br,

odong nando


      Dari: "'Mr. Kid' [hidden email] [belajar-excel]" <[hidden email]>
 Kepada: BeExcel <[hidden email]>
 Dikirim: Jumat, 2 November 2018 14:40
 Judul: Re: [belajar-excel] Mengambil data yg sama dalam satu tabel
   
    mungkin belum ditata layoutnya, jadi hanya pakai layout (susunan) default.bisa lebih spesifik seperti apa layout yang rapi itu dan seperti apa layout yang kurang rapi tersebut ?
Ini contoh pivot table yang dibuat mas Gery, lalu ditata layout-nya
a. warna-warni bisa ditata dengan PivotTable Styles (ribbon Design -> grup PivotTable Styles) [dalam ribbon, sisi kanan]b. layout bisa ditata melalui grup menu Layout (ribbon Design -> grup Layout) [dalam ribbon, sisi kiric. fields (kolom-kolom) yang akan ditampilkan bisa ditata melalui PivotTable Field List yang ada dalam pane yang muncul di sisi kanan layar
Regards,Kid






On Fri, Nov 2, 2018 at 10:40 AM [hidden email] [belajar-excel] <[hidden email]> wrote:

     terimakasih sebelumnya Suhu Heri...pernah jg lihat2 pake pivot kyke kurang rapi gitu, klo pake formula gimana ya formulanya? sampe td mlm trial blm bisa jg   
  #yiv4077919475 #yiv4077919475 -- #yiv4077919475ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4077919475 #yiv4077919475ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4077919475 #yiv4077919475ygrp-mkp #yiv4077919475hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv4077919475 #yiv4077919475ygrp-mkp #yiv4077919475ads {margin-bottom:10px;}#yiv4077919475 #yiv4077919475ygrp-mkp .yiv4077919475ad {padding:0 0;}#yiv4077919475 #yiv4077919475ygrp-mkp .yiv4077919475ad p {margin:0;}#yiv4077919475 #yiv4077919475ygrp-mkp .yiv4077919475ad a {color:#0000ff;text-decoration:none;}#yiv4077919475 #yiv4077919475ygrp-sponsor #yiv4077919475ygrp-lc {font-family:Arial;}#yiv4077919475 #yiv4077919475ygrp-sponsor #yiv4077919475ygrp-lc #yiv4077919475hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4077919475 #yiv4077919475ygrp-sponsor #yiv4077919475ygrp-lc .yiv4077919475ad {margin-bottom:10px;padding:0 0;}#yiv4077919475 #yiv4077919475actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4077919475 #yiv4077919475activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4077919475 #yiv4077919475activity span {font-weight:700;}#yiv4077919475 #yiv4077919475activity span:first-child {text-transform:uppercase;}#yiv4077919475 #yiv4077919475activity span a {color:#5085b6;text-decoration:none;}#yiv4077919475 #yiv4077919475activity span span {color:#ff7900;}#yiv4077919475 #yiv4077919475activity span .yiv4077919475underline {text-decoration:underline;}#yiv4077919475 .yiv4077919475attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv4077919475 .yiv4077919475attach div a {text-decoration:none;}#yiv4077919475 .yiv4077919475attach img {border:none;padding-right:5px;}#yiv4077919475 .yiv4077919475attach label {display:block;margin-bottom:5px;}#yiv4077919475 .yiv4077919475attach label a {text-decoration:none;}#yiv4077919475 blockquote {margin:0 0 0 4px;}#yiv4077919475 .yiv4077919475bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv4077919475 .yiv4077919475bold a {text-decoration:none;}#yiv4077919475 dd.yiv4077919475last p a {font-family:Verdana;font-weight:700;}#yiv4077919475 dd.yiv4077919475last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4077919475 dd.yiv4077919475last p span.yiv4077919475yshortcuts {margin-right:0;}#yiv4077919475 div.yiv4077919475attach-table div div a {text-decoration:none;}#yiv4077919475 div.yiv4077919475attach-table {width:400px;}#yiv4077919475 div.yiv4077919475file-title a, #yiv4077919475 div.yiv4077919475file-title a:active, #yiv4077919475 div.yiv4077919475file-title a:hover, #yiv4077919475 div.yiv4077919475file-title a:visited {text-decoration:none;}#yiv4077919475 div.yiv4077919475photo-title a, #yiv4077919475 div.yiv4077919475photo-title a:active, #yiv4077919475 div.yiv4077919475photo-title a:hover, #yiv4077919475 div.yiv4077919475photo-title a:visited {text-decoration:none;}#yiv4077919475 div#yiv4077919475ygrp-mlmsg #yiv4077919475ygrp-msg p a span.yiv4077919475yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4077919475 .yiv4077919475green {color:#628c2a;}#yiv4077919475 .yiv4077919475MsoNormal {margin:0 0 0 0;}#yiv4077919475 o {font-size:0;}#yiv4077919475 #yiv4077919475photos div {float:left;width:72px;}#yiv4077919475 #yiv4077919475photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv4077919475 #yiv4077919475photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4077919475 #yiv4077919475reco-category {font-size:77%;}#yiv4077919475 #yiv4077919475reco-desc {font-size:77%;}#yiv4077919475 .yiv4077919475replbq {margin:4px;}#yiv4077919475 #yiv4077919475ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv4077919475 #yiv4077919475ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4077919475 #yiv4077919475ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4077919475 #yiv4077919475ygrp-mlmsg select, #yiv4077919475 input, #yiv4077919475 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv4077919475 #yiv4077919475ygrp-mlmsg pre, #yiv4077919475 code {font:115% monospace;}#yiv4077919475 #yiv4077919475ygrp-mlmsg * {line-height:1.22em;}#yiv4077919475 #yiv4077919475ygrp-mlmsg #yiv4077919475logo {padding-bottom:10px;}#yiv4077919475 #yiv4077919475ygrp-msg p a {font-family:Verdana;}#yiv4077919475 #yiv4077919475ygrp-msg p#yiv4077919475attach-count span {color:#1E66AE;font-weight:700;}#yiv4077919475 #yiv4077919475ygrp-reco #yiv4077919475reco-head {color:#ff7900;font-weight:700;}#yiv4077919475 #yiv4077919475ygrp-reco {margin-bottom:20px;padding:0px;}#yiv4077919475 #yiv4077919475ygrp-sponsor #yiv4077919475ov li a {font-size:130%;text-decoration:none;}#yiv4077919475 #yiv4077919475ygrp-sponsor #yiv4077919475ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv4077919475 #yiv4077919475ygrp-sponsor #yiv4077919475ov ul {margin:0;padding:0 0 0 8px;}#yiv4077919475 #yiv4077919475ygrp-text {font-family:Georgia;}#yiv4077919475 #yiv4077919475ygrp-text p {margin:0 0 1em 0;}#yiv4077919475 #yiv4077919475ygrp-text tt {font-size:120%;}#yiv4077919475 #yiv4077919475ygrp-vital ul li:last-child {border-right:none !important;}#yiv4077919475

   

Untitled-1.gif (46K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: Bls: [belajar-excel] Mengambil data yg sama dalam satu tabel [1 Attachment]

Eira_ariE

sama nanyanya .. Mr. Kid, gimana yaa buatnya nomer urutnya biar bisa masuk field pivot table ?hehehe .. biasanya saya buat di luar area pivot

    On Friday, November 2, 2018, 5:42:02 PM GMT+7, odong nando [hidden email] [belajar-excel] <[hidden email]> wrote:

  

maaf boz kid, itu cara buat no urutnya gmn y...
hehe... br,

odong nando


      Dari: "'Mr. Kid' [hidden email] [belajar-excel]" <[hidden email]>
 Kepada: BeExcel <[hidden email]>
 Dikirim: Jumat, 2 November 2018 14:40
 Judul: Re: [belajar-excel] Mengambil data yg sama dalam satu tabel

    mungkin belum ditata layoutnya, jadi hanya pakai layout (susunan) default.bisa lebih spesifik seperti apa layout yang rapi itu dan seperti apa layout yang kurang rapi tersebut ?
Ini contoh pivot table yang dibuat mas Gery, lalu ditata layout-nya
a. warna-warni bisa ditata dengan PivotTable Styles (ribbon Design -> grup PivotTable Styles) [dalam ribbon, sisi kanan]b. layout bisa ditata melalui grup menu Layout (ribbon Design -> grup Layout) [dalam ribbon, sisi kiric. fields (kolom-kolom) yang akan ditampilkan bisa ditata melalui PivotTable Field List yang ada dalam pane yang muncul di sisi kanan layar
Regards,Kid






On Fri, Nov 2, 2018 at 10:40 AM [hidden email] [belajar-excel] <[hidden email]> wrote:

     terimakasih sebelumnya Suhu Heri...pernah jg lihat2 pake pivot kyke kurang rapi gitu, klo pake formula gimana ya formulanya? sampe td mlm trial blm bisa jg 


     #yiv5474249505 #yiv5474249505 -- #yiv5474249505ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5474249505 #yiv5474249505ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5474249505 #yiv5474249505ygrp-mkp #yiv5474249505hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5474249505 #yiv5474249505ygrp-mkp #yiv5474249505ads {margin-bottom:10px;}#yiv5474249505 #yiv5474249505ygrp-mkp .yiv5474249505ad {padding:0 0;}#yiv5474249505 #yiv5474249505ygrp-mkp .yiv5474249505ad p {margin:0;}#yiv5474249505 #yiv5474249505ygrp-mkp .yiv5474249505ad a {color:#0000ff;text-decoration:none;}#yiv5474249505 #yiv5474249505ygrp-sponsor #yiv5474249505ygrp-lc {font-family:Arial;}#yiv5474249505 #yiv5474249505ygrp-sponsor #yiv5474249505ygrp-lc #yiv5474249505hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5474249505 #yiv5474249505ygrp-sponsor #yiv5474249505ygrp-lc .yiv5474249505ad {margin-bottom:10px;padding:0 0;}#yiv5474249505 #yiv5474249505actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5474249505 #yiv5474249505activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5474249505 #yiv5474249505activity span {font-weight:700;}#yiv5474249505 #yiv5474249505activity span:first-child {text-transform:uppercase;}#yiv5474249505 #yiv5474249505activity span a {color:#5085b6;text-decoration:none;}#yiv5474249505 #yiv5474249505activity span span {color:#ff7900;}#yiv5474249505 #yiv5474249505activity span .yiv5474249505underline {text-decoration:underline;}#yiv5474249505 .yiv5474249505attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv5474249505 .yiv5474249505attach div a {text-decoration:none;}#yiv5474249505 .yiv5474249505attach img {border:none;padding-right:5px;}#yiv5474249505 .yiv5474249505attach label {display:block;margin-bottom:5px;}#yiv5474249505 .yiv5474249505attach label a {text-decoration:none;}#yiv5474249505 blockquote {margin:0 0 0 4px;}#yiv5474249505 .yiv5474249505bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv5474249505 .yiv5474249505bold a {text-decoration:none;}#yiv5474249505 dd.yiv5474249505last p a {font-family:Verdana;font-weight:700;}#yiv5474249505 dd.yiv5474249505last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5474249505 dd.yiv5474249505last p span.yiv5474249505yshortcuts {margin-right:0;}#yiv5474249505 div.yiv5474249505attach-table div div a {text-decoration:none;}#yiv5474249505 div.yiv5474249505attach-table {width:400px;}#yiv5474249505 div.yiv5474249505file-title a, #yiv5474249505 div.yiv5474249505file-title a:active, #yiv5474249505 div.yiv5474249505file-title a:hover, #yiv5474249505 div.yiv5474249505file-title a:visited {text-decoration:none;}#yiv5474249505 div.yiv5474249505photo-title a, #yiv5474249505 div.yiv5474249505photo-title a:active, #yiv5474249505 div.yiv5474249505photo-title a:hover, #yiv5474249505 div.yiv5474249505photo-title a:visited {text-decoration:none;}#yiv5474249505 div#yiv5474249505ygrp-mlmsg #yiv5474249505ygrp-msg p a span.yiv5474249505yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5474249505 .yiv5474249505green {color:#628c2a;}#yiv5474249505 .yiv5474249505MsoNormal {margin:0 0 0 0;}#yiv5474249505 o {font-size:0;}#yiv5474249505 #yiv5474249505photos div {float:left;width:72px;}#yiv5474249505 #yiv5474249505photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv5474249505 #yiv5474249505photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5474249505 #yiv5474249505reco-category {font-size:77%;}#yiv5474249505 #yiv5474249505reco-desc {font-size:77%;}#yiv5474249505 ...yiv5474249505replbq {margin:4px;}#yiv5474249505 #yiv5474249505ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv5474249505 #yiv5474249505ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5474249505 #yiv5474249505ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5474249505 #yiv5474249505ygrp-mlmsg select, #yiv5474249505 input, #yiv5474249505 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv5474249505 #yiv5474249505ygrp-mlmsg pre, #yiv5474249505 code {font:115% monospace;}#yiv5474249505 #yiv5474249505ygrp-mlmsg * {line-height:1.22em;}#yiv5474249505 #yiv5474249505ygrp-mlmsg #yiv5474249505logo {padding-bottom:10px;}#yiv5474249505 #yiv5474249505ygrp-msg p a {font-family:Verdana;}#yiv5474249505 #yiv5474249505ygrp-msg p#yiv5474249505attach-count span {color:#1E66AE;font-weight:700;}#yiv5474249505 #yiv5474249505ygrp-reco #yiv5474249505reco-head {color:#ff7900;font-weight:700;}#yiv5474249505 #yiv5474249505ygrp-reco {margin-bottom:20px;padding:0px;}#yiv5474249505 #yiv5474249505ygrp-sponsor #yiv5474249505ov li a {font-size:130%;text-decoration:none;}#yiv5474249505 #yiv5474249505ygrp-sponsor #yiv5474249505ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv5474249505 #yiv5474249505ygrp-sponsor #yiv5474249505ov ul {margin:0;padding:0 0 0 8px;}#yiv5474249505 #yiv5474249505ygrp-text {font-family:Georgia;}#yiv5474249505 #yiv5474249505ygrp-text p {margin:0 0 1em 0;}#yiv5474249505 #yiv5474249505ygrp-text tt {font-size:120%;}#yiv5474249505 #yiv5474249505ygrp-vital ul li:last-child {border-right:none !important;}#yiv5474249505

Untitled-1.gif (46K) Download Attachment
Kid
Reply | Threaded
Open this post in threaded view
|

Re: Bls: [belajar-excel] Mengambil data yg sama dalam satu tabel

Kid
Administrator
Naah...
Berarti tidak tampak ada 2 pivot tabel dijejerkan...
Ya kan...
Terbukti bahwa menyusun tampilan untuk manusia itu relatif mudah, karena mata manusia kurang awas dan manusia memiliki karakter dasar untuk mentolerir sesuatu.

Regards,
Kid
Sent from my smart enough phone

> On Nov 2, 2018, at 18:03, Eira I Arie [hidden email] [belajar-excel] <[hidden email]> wrote:
>
>
> sama nanyanya .. Mr. Kid, gimana yaa buatnya nomer urutnya biar bisa masuk field pivot table ?
> hehehe .. biasanya saya buat di luar area pivot
>
>
> On Friday, November 2, 2018, 5:42:02 PM GMT+7, odong nando [hidden email] [belajar-excel] <[hidden email]> wrote:
>
>
>  
> maaf boz kid, itu cara buat no urutnya gmn y...
> hehe...
>  
> br,
>
> odong nando
>
>
> Dari: "'Mr. Kid' [hidden email] [belajar-excel]" <[hidden email]>
> Kepada: BeExcel <[hidden email]>
> Dikirim: Jumat, 2 November 2018 14:40
> Judul: Re: [belajar-excel] Mengambil data yg sama dalam satu tabel
>
>  
> mungkin belum ditata layoutnya, jadi hanya pakai layout (susunan) default..
> bisa lebih spesifik seperti apa layout yang rapi itu dan seperti apa layout yang kurang rapi tersebut ?
>
> Ini contoh pivot table yang dibuat mas Gery, lalu ditata layout-nya
> <Untitled-1.gif>
> a. warna-warni bisa ditata dengan PivotTable Styles (ribbon Design -> grup PivotTable Styles) [dalam ribbon, sisi kanan]
> b. layout bisa ditata melalui grup menu Layout (ribbon Design -> grup Layout) [dalam ribbon, sisi kiri
> c. fields (kolom-kolom) yang akan ditampilkan bisa ditata melalui PivotTable Field List yang ada dalam pane yang muncul di sisi kanan layar
>
> Regards,
> Kid
>
>
>
>
>
>
>
> On Fri, Nov 2, 2018 at 10:40 AM [hidden email] [belajar-excel] <[hidden email]> wrote:
>  
> terimakasih sebelumnya Suhu Heri...pernah jg lihat2 pake pivot kyke kurang rapi gitu, klo pake formula gimana ya formulanya? sampe td mlm trial blm bisa jg
>
>
>
> <Untitled-1.gif>
Reply | Threaded
Open this post in threaded view
|

[belajar-excel] Re: Mengambil data yg sama dalam satu tabel

fathianm
terimakasih semua atas masukanya...semakin nambah wawasan nih...