[belajar-excel] Merapikan data sesuai kriteria

[Heru Adi]

Assalamu'alaikum.Mohon bantuan nya teman2 . Bagaimana cara merapikan data sesuai dengan kriteria.Contoh file terlampir.Sebelumnya saya ucapkan terimakasih banyak 

Dikirim dari Yahoo Mail di Android

[Jatmiko]

Dear Pak Heru,

Apakah boleh ditambah kolom bantuan?
File terlampir.
Apakah sudah sesuai keinginan?

Suwun,

On Tue, Nov 24, 2020 at 8:03 AM Heru Adi [hidden email] [belajar-excel] <
[hidden email]> wrote:

>
>
> Assalamu'alaikum.
> Mohon bantuan nya teman2 . Bagaimana cara merapikan data sesuai dengan
> kriteria.
> Contoh file terlampir.
> Sebelumnya saya ucapkan terimakasih banyak
>
> Dikirim dari Yahoo Mail di Android
> <https://go.onelink.me/107872968?pid=InProduct&c=Global_Internal_YGrowth_AndroidEmailSig__AndroidUsers&af_wl=ym&af_sub1=Internal&af_sub2=Global_YGrowth&af_sub3=EmailSignature>
>
>
>

[Heru Adi]

Boleh pak, boleh banget malah hehe.Terimakasih banyak pak abu abdillah.. atas bantuan nya. Sudah sesuai keinginan . Mudah2an ilmu bapak berkah.Sekali lg terimakasih banyak pak :)

Dikirim dari Yahoo Mail di Android
 
  Pada Sel, 24 Nov 2020 pada 9:04, Abu Abdillaah [hidden email] [belajar-excel]<[hidden email]> menulis:      

Dear Pak Heru,
Apakah boleh ditambah kolom bantuan?File terlampir.Apakah sudah sesuai keinginan?
Suwun,
On Tue, Nov 24, 2020 at 8:03 AM Heru Adi [hidden email] [belajar-excel] <[hidden email]> wrote:

    
Assalamu'alaikum.
Mohon bantuan nya teman2 . Bagaimana cara merapikan data sesuai dengan kriteria.Contoh file terlampir.Sebelumnya saya ucapkan terimakasih banyak 

Dikirim dari Yahoo Mail di Android

   
  #yiv7289167657 #yiv7289167657 -- #yiv7289167657ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7289167657 #yiv7289167657ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7289167657 #yiv7289167657ygrp-mkp #yiv7289167657hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7289167657 #yiv7289167657ygrp-mkp #yiv7289167657ads {margin-bottom:10px;}#yiv7289167657 #yiv7289167657ygrp-mkp .yiv7289167657ad {padding:0 0;}#yiv7289167657 #yiv7289167657ygrp-mkp .yiv7289167657ad p {margin:0;}#yiv7289167657 #yiv7289167657ygrp-mkp .yiv7289167657ad a {color:#0000ff;text-decoration:none;}#yiv7289167657 #yiv7289167657ygrp-sponsor #yiv7289167657ygrp-lc {font-family:Arial;}#yiv7289167657 #yiv7289167657ygrp-sponsor #yiv7289167657ygrp-lc #yiv7289167657hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7289167657 #yiv7289167657ygrp-sponsor #yiv7289167657ygrp-lc .yiv7289167657ad {margin-bottom:10px;padding:0 0;}#yiv7289167657 #yiv7289167657actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7289167657 #yiv7289167657activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7289167657 #yiv7289167657activity span {font-weight:700;}#yiv7289167657 #yiv7289167657activity span:first-child {text-transform:uppercase;}#yiv7289167657 #yiv7289167657activity span a {color:#5085b6;text-decoration:none;}#yiv7289167657 #yiv7289167657activity span span {color:#ff7900;}#yiv7289167657 #yiv7289167657activity span .yiv7289167657underline {text-decoration:underline;}#yiv7289167657 .yiv7289167657attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7289167657 .yiv7289167657attach div a {text-decoration:none;}#yiv7289167657 .yiv7289167657attach img {border:none;padding-right:5px;}#yiv7289167657 .yiv7289167657attach label {display:block;margin-bottom:5px;}#yiv7289167657 .yiv7289167657attach label a {text-decoration:none;}#yiv7289167657 blockquote {margin:0 0 0 4px;}#yiv7289167657 .yiv7289167657bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7289167657 .yiv7289167657bold a {text-decoration:none;}#yiv7289167657 dd.yiv7289167657last p a {font-family:Verdana;font-weight:700;}#yiv7289167657 dd.yiv7289167657last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7289167657 dd.yiv7289167657last p span.yiv7289167657yshortcuts {margin-right:0;}#yiv7289167657 div.yiv7289167657attach-table div div a {text-decoration:none;}#yiv7289167657 div.yiv7289167657attach-table {width:400px;}#yiv7289167657 div.yiv7289167657file-title a, #yiv7289167657 div.yiv7289167657file-title a:active, #yiv7289167657 div.yiv7289167657file-title a:hover, #yiv7289167657 div.yiv7289167657file-title a:visited {text-decoration:none;}#yiv7289167657 div.yiv7289167657photo-title a, #yiv7289167657 div.yiv7289167657photo-title a:active, #yiv7289167657 div.yiv7289167657photo-title a:hover, #yiv7289167657 div.yiv7289167657photo-title a:visited {text-decoration:none;}#yiv7289167657 div#yiv7289167657ygrp-mlmsg #yiv7289167657ygrp-msg p a span.yiv7289167657yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7289167657 .yiv7289167657green {color:#628c2a;}#yiv7289167657 .yiv7289167657MsoNormal {margin:0 0 0 0;}#yiv7289167657 o {font-size:0;}#yiv7289167657 #yiv7289167657photos div {float:left;width:72px;}#yiv7289167657 #yiv7289167657photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv7289167657 #yiv7289167657photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7289167657 #yiv7289167657reco-category {font-size:77%;}#yiv7289167657 #yiv7289167657reco-desc {font-size:77%;}#yiv7289167657 .yiv7289167657replbq {margin:4px;}#yiv7289167657 #yiv7289167657ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv7289167657 #yiv7289167657ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7289167657 #yiv7289167657ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7289167657 #yiv7289167657ygrp-mlmsg select, #yiv7289167657 input, #yiv7289167657 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv7289167657 #yiv7289167657ygrp-mlmsg pre, #yiv7289167657 code {font:115% monospace;}#yiv7289167657 #yiv7289167657ygrp-mlmsg * {line-height:1.22em;}#yiv7289167657 #yiv7289167657ygrp-mlmsg #yiv7289167657logo {padding-bottom:10px;}#yiv7289167657 #yiv7289167657ygrp-msg p a {font-family:Verdana;}#yiv7289167657 #yiv7289167657ygrp-msg p#yiv7289167657attach-count span {color:#1E66AE;font-weight:700;}#yiv7289167657 #yiv7289167657ygrp-reco #yiv7289167657reco-head {color:#ff7900;font-weight:700;}#yiv7289167657 #yiv7289167657ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7289167657 #yiv7289167657ygrp-sponsor #yiv7289167657ov li a {font-size:130%;text-decoration:none;}#yiv7289167657 #yiv7289167657ygrp-sponsor #yiv7289167657ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7289167657 #yiv7289167657ygrp-sponsor #yiv7289167657ov ul {margin:0;padding:0 0 0 8px;}#yiv7289167657 #yiv7289167657ygrp-text {font-family:Georgia;}#yiv7289167657 #yiv7289167657ygrp-text p {margin:0 0 1em 0;}#yiv7289167657 #yiv7289167657ygrp-text tt {font-size:120%;}#yiv7289167657 #yiv7289167657ygrp-vital ul li:last-child {border-right:none !important;}#yiv7289167657  

[Heru Adi]

Dear pak abu abdillah,
Mohon bantuan nya lagi pak, masih terkait data yg td.Untuk formula =MATCH($I4&J3;$B$4:$B$33&$G$4:$G$33;0))di bagian J3 nya apa bisa dibuat absolut manjadi J$3 ? Sehingga ketika rumus nya saya drag ke bawah referensi nya gak bergeser. Sudah saya coba tapi malah terjadi error, mohon koreksinya ..
Makasih pak :)

Dikirim dari Yahoo Mail di Android
 
  Pada Sel, 24 Nov 2020 pada 9:14, Heru Adi [hidden email] [belajar-excel]<[hidden email]> menulis:      
Boleh pak, boleh banget malah hehe.
Terimakasih banyak pak abu abdillah.. atas bantuan nya. Sudah sesuai keinginan . Mudah2an ilmu bapak berkah.Sekali lg terimakasih banyak pak :)

Dikirim dari Yahoo Mail di Android
 
  Pada Sel, 24 Nov 2020 pada 9:04, Abu Abdillaah [hidden email] [belajar-excel]<[hidden email]> menulis:      

Dear Pak Heru,
Apakah boleh ditambah kolom bantuan?File terlampir.Apakah sudah sesuai keinginan?
Suwun,
On Tue, Nov 24, 2020 at 8:03 AM Heru Adi [hidden email] [belajar-excel] <[hidden email]> wrote:

    
Assalamu'alaikum.
Mohon bantuan nya teman2 . Bagaimana cara merapikan data sesuai dengan kriteria.Contoh file terlampir.Sebelumnya saya ucapkan terimakasih banyak 

Dikirim dari Yahoo Mail di Android

   
   
  #yiv2475189629 #yiv2475189629 -- #yiv2475189629ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2475189629 #yiv2475189629ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2475189629 #yiv2475189629ygrp-mkp #yiv2475189629hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2475189629 #yiv2475189629ygrp-mkp #yiv2475189629ads {margin-bottom:10px;}#yiv2475189629 #yiv2475189629ygrp-mkp .yiv2475189629ad {padding:0 0;}#yiv2475189629 #yiv2475189629ygrp-mkp .yiv2475189629ad p {margin:0;}#yiv2475189629 #yiv2475189629ygrp-mkp .yiv2475189629ad a {color:#0000ff;text-decoration:none;}#yiv2475189629 #yiv2475189629ygrp-sponsor #yiv2475189629ygrp-lc {font-family:Arial;}#yiv2475189629 #yiv2475189629ygrp-sponsor #yiv2475189629ygrp-lc #yiv2475189629hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2475189629 #yiv2475189629ygrp-sponsor #yiv2475189629ygrp-lc .yiv2475189629ad {margin-bottom:10px;padding:0 0;}#yiv2475189629 #yiv2475189629actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2475189629 #yiv2475189629activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2475189629 #yiv2475189629activity span {font-weight:700;}#yiv2475189629 #yiv2475189629activity span:first-child {text-transform:uppercase;}#yiv2475189629 #yiv2475189629activity span a {color:#5085b6;text-decoration:none;}#yiv2475189629 #yiv2475189629activity span span {color:#ff7900;}#yiv2475189629 #yiv2475189629activity span .yiv2475189629underline {text-decoration:underline;}#yiv2475189629 .yiv2475189629attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2475189629 .yiv2475189629attach div a {text-decoration:none;}#yiv2475189629 .yiv2475189629attach img {border:none;padding-right:5px;}#yiv2475189629 .yiv2475189629attach label {display:block;margin-bottom:5px;}#yiv2475189629 .yiv2475189629attach label a {text-decoration:none;}#yiv2475189629 blockquote {margin:0 0 0 4px;}#yiv2475189629 .yiv2475189629bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2475189629 .yiv2475189629bold a {text-decoration:none;}#yiv2475189629 dd.yiv2475189629last p a {font-family:Verdana;font-weight:700;}#yiv2475189629 dd.yiv2475189629last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2475189629 dd.yiv2475189629last p span.yiv2475189629yshortcuts {margin-right:0;}#yiv2475189629 div.yiv2475189629attach-table div div a {text-decoration:none;}#yiv2475189629 div.yiv2475189629attach-table {width:400px;}#yiv2475189629 div.yiv2475189629file-title a, #yiv2475189629 div.yiv2475189629file-title a:active, #yiv2475189629 div.yiv2475189629file-title a:hover, #yiv2475189629 div.yiv2475189629file-title a:visited {text-decoration:none;}#yiv2475189629 div.yiv2475189629photo-title a, #yiv2475189629 div.yiv2475189629photo-title a:active, #yiv2475189629 div.yiv2475189629photo-title a:hover, #yiv2475189629 div.yiv2475189629photo-title a:visited {text-decoration:none;}#yiv2475189629 div#yiv2475189629ygrp-mlmsg #yiv2475189629ygrp-msg p a span.yiv2475189629yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2475189629 .yiv2475189629green {color:#628c2a;}#yiv2475189629 .yiv2475189629MsoNormal {margin:0 0 0 0;}#yiv2475189629 o {font-size:0;}#yiv2475189629 #yiv2475189629photos div {float:left;width:72px;}#yiv2475189629 #yiv2475189629photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv2475189629 #yiv2475189629photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2475189629 #yiv2475189629reco-category {font-size:77%;}#yiv2475189629 #yiv2475189629reco-desc {font-size:77%;}#yiv2475189629 .yiv2475189629replbq {margin:4px;}#yiv2475189629 #yiv2475189629ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2475189629 #yiv2475189629ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2475189629 #yiv2475189629ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2475189629 #yiv2475189629ygrp-mlmsg select, #yiv2475189629 input, #yiv2475189629 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2475189629 #yiv2475189629ygrp-mlmsg pre, #yiv2475189629 code {font:115% monospace;}#yiv2475189629 #yiv2475189629ygrp-mlmsg * {line-height:1.22em;}#yiv2475189629 #yiv2475189629ygrp-mlmsg #yiv2475189629logo {padding-bottom:10px;}#yiv2475189629 #yiv2475189629ygrp-msg p a {font-family:Verdana;}#yiv2475189629 #yiv2475189629ygrp-msg p#yiv2475189629attach-count span {color:#1E66AE;font-weight:700;}#yiv2475189629 #yiv2475189629ygrp-reco #yiv2475189629reco-head {color:#ff7900;font-weight:700;}#yiv2475189629 #yiv2475189629ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2475189629 #yiv2475189629ygrp-sponsor #yiv2475189629ov li a {font-size:130%;text-decoration:none;}#yiv2475189629 #yiv2475189629ygrp-sponsor #yiv2475189629ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2475189629 #yiv2475189629ygrp-sponsor #yiv2475189629ov ul {margin:0;padding:0 0 0 8px;}#yiv2475189629 #yiv2475189629ygrp-text {font-family:Georgia;}#yiv2475189629 #yiv2475189629ygrp-text p {margin:0 0 1em 0;}#yiv2475189629 #yiv2475189629ygrp-text tt {font-size:120%;}#yiv2475189629 #yiv2475189629ygrp-vital ul li:last-child {border-right:none !important;}#yiv2475189629  

[Jatmiko]

Dear Pak Heru,

File revisi terlampir

Suwun,

On Tue, Nov 24, 2020 at 12:02 PM Heru Adi [hidden email] [belajar-excel]
<[hidden email]> wrote:

>
>
> Dear pak abu abdillah,
>
> Mohon bantuan nya lagi pak, masih terkait data yg td.
> Untuk formula =MATCH($I4&J3;$B$4:$B$33&$G$4:$G$33;0))
> di bagian J3 nya apa bisa dibuat absolut manjadi J$3 ?
> Sehingga ketika rumus nya saya drag ke bawah referensi nya gak bergeser.
> Sudah saya coba tapi malah terjadi error, mohon koreksinya .
>
> Makasih pak :)
>
> Dikirim dari Yahoo Mail di Android
> <https://go.onelink.me/107872968?pid=InProduct&c=Global_Internal_YGrowth_AndroidEmailSig__AndroidUsers&af_wl=ym&af_sub1=Internal&af_sub2=Global_YGrowth&af_sub3=EmailSignature>
>
> Pada Sel, 24 Nov 2020 pada 9:14, Heru Adi [hidden email]
> [belajar-excel]
> <[hidden email]> menulis:
>
>
> Boleh pak, boleh banget malah hehe.
> Terimakasih banyak pak abu abdillah.. atas bantuan nya. Sudah sesuai
> keinginan .
> Mudah2an ilmu bapak berkah.
> Sekali lg terimakasih banyak pak :)
>
> Dikirim dari Yahoo Mail di Android
> <https://go.onelink.me/107872968?pid=InProduct&c=Global_Internal_YGrowth_AndroidEmailSig__AndroidUsers&af_wl=ym&af_sub1=Internal&af_sub2=Global_YGrowth&af_sub3=EmailSignature>
>
> Pada Sel, 24 Nov 2020 pada 9:04, Abu Abdillaah [hidden email]
> [belajar-excel]
> <[hidden email]> menulis:
>
>
> Dear Pak Heru,
>
> Apakah boleh ditambah kolom bantuan?
> File terlampir.
> Apakah sudah sesuai keinginan?
>
> Suwun,
>
> On Tue, Nov 24, 2020 at 8:03 AM Heru Adi [hidden email]
> [belajar-excel] <[hidden email]> wrote:
>
>
>
> Assalamu'alaikum.
> Mohon bantuan nya teman2 . Bagaimana cara merapikan data sesuai dengan
> kriteria.
> Contoh file terlampir.
> Sebelumnya saya ucapkan terimakasih banyak
>
> Dikirim dari Yahoo Mail di Android
> <https://go.onelink.me/107872968?pid=InProduct&c=Global_Internal_YGrowth_AndroidEmailSig__AndroidUsers&af_wl=ym&af_sub1=Internal&af_sub2=Global_YGrowth&af_sub3=EmailSignature>
>
>
>