[belajar-excel] Digest Number 4231

Milis Belajar Microsoft Excel Group

5 Messages

Digest #4231

1a

Re: Data Belum Setor [1 Attachment] by "nangagus"

2a

Mengurutkan data berdasarkan tgl yg lebih muda by "farud oke"

2b

Re: Mengurutkan data berdasarkan tgl yg lebih muda [1 Attachment] by "hendrik karnadi" hendrikkarnadi

2c

Re: Mengurutkan data berdasarkan tgl yg lebih muda by "farud oke"

2d

Re: Mengurutkan data berdasarkan tgl yg lebih muda [1 Attachment] by "Nang Agus"

Messages

1a

Re: Data Belum Setor [1 Attachment]

Mon Jul 10, 2017 11:28 pm (PDT) . Posted by:

"nangagus"

Walaikumsalam warahmatullah.

Dear anang.

Pakai kolom bantu yaa....

coba di sheet Master Cell F4 diketik formula:
=IF(IFERROR(MATCH(C4;Realisasi!$C$4:$C$12;0);0)>0;0;MAX(F3:$F$3)+1)
tarik (copy) formula tersebut sampai F23. maksud formula tersebut adalah
memberi nomor bagi yang belum setor.

kemudian di sheet belum setor cell C4 diketik formula:
=INDEX(Master!C$4:C$23;MATCH(ROW($A1);Master!$F$4:$F$23;0))
tarik(copy) formula tersebut ke kanan dan bawah sampai eror (E14)

Jangan lupa karakter ; diubah menjadi , apabila regional setting
komputer setempat bukan Indonesia.

Wasalamualaikum warahmatullah

NangAgus

On 7/11/17 2:21 AM, acag41@yahoo.com [belajar-excel] wrote:
>
> Wa'alaikumsalam wr. wb., master excel
>
>
> bagaimana caranya membuat data belum setor dengan membandingkan data
> master yang ada?
>
>
> file terlampir
>
>
> Wassalam,
> Anang
>
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

2a

Mengurutkan data berdasarkan tgl yg lebih muda

Tue Jul 11, 2017 2:31 pm (PDT) . Posted by:

"farud oke"

Assalamualaikum master2 excel..
Mohon bantuannya..bagaimana caranya mengurutkan data berdasarkan tanggal yg
lebih muda dan data di sebelahnya mengikuti.untuk lebih jelasnya file
terlampir.
Atas bantuan para master sejalian saya sampaikan terimakasih

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

2b

Re: Mengurutkan data berdasarkan tgl yg lebih muda [1 Attachment]

Tue Jul 11, 2017 4:24 pm (PDT) . Posted by:

"hendrik karnadi" hendrikkarnadi

Hai Farud,
Apakah tipe data tanggalnya sdh berupa tanggal?Kalau sdh...tinggal di sort berdasarkan tanggal.
Salam,HK

Sent from Yahoo Mail on Android

On Wed, Jul 12, 2017 at 4:32, farud oke farud.oke@gmail.com [belajar-excel]<belajar-excel@yahoogroups.com> wrote:  

Assalamualaikum master2 excel..
Mohon bantuannya..bagaimana caranya mengurutkan data berdasarkan tanggal yg lebih muda dan data di sebelahnya mengikuti.untuk lebih jelasnya file terlampir.
Atas bantuan para master sejalian saya sampaikan terimakasih
#yiv5356127746 #yiv5356127746 -- #yiv5356127746ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5356127746 #yiv5356127746ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5356127746 #yiv5356127746ygrp-mkp #yiv5356127746hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5356127746 #yiv5356127746ygrp-mkp #yiv5356127746ads {margin-bottom:10px;}#yiv5356127746 #yiv5356127746ygrp-mkp .yiv5356127746ad {padding:0 0;}#yiv5356127746 #yiv5356127746ygrp-mkp .yiv5356127746ad p {margin:0;}#yiv5356127746 #yiv5356127746ygrp-mkp .yiv5356127746ad a {color:#0000ff;text-decoration:none;}#yiv5356127746 #yiv5356127746ygrp-sponsor #yiv5356127746ygrp-lc {font-family:Arial;}#yiv5356127746 #yiv5356127746ygrp-sponsor #yiv5356127746ygrp-lc #yiv5356127746hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5356127746 #yiv5356127746ygrp-sponsor #yiv5356127746ygrp-lc .yiv5356127746ad {margin-bottom:10px;padding:0 0;}#yiv5356127746 #yiv5356127746actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5356127746 #yiv5356127746activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5356127746 #yiv5356127746activity span {font-weight:700;}#yiv5356127746 #yiv5356127746activity span:first-child {text-transform:uppercase;}#yiv5356127746 #yiv5356127746activity span a {color:#5085b6;text-decoration:none;}#yiv5356127746 #yiv5356127746activity span span {color:#ff7900;}#yiv5356127746 #yiv5356127746activity span .yiv5356127746underline {text-decoration:underline;}#yiv5356127746 .yiv5356127746attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv5356127746 .yiv5356127746attach div a {text-decoration:none;}#yiv5356127746 .yiv5356127746attach img {border:none;padding-right:5px;}#yiv5356127746 .yiv5356127746attach label {display:block;margin-bottom:5px;}#yiv5356127746 .yiv5356127746attach label a {text-decoration:none;}#yiv5356127746 blockquote {margin:0 0 0 4px;}#yiv5356127746 .yiv5356127746bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv5356127746 .yiv5356127746bold a {text-decoration:none;}#yiv5356127746 dd.yiv5356127746last p a {font-family:Verdana;font-weight:700;}#yiv5356127746 dd.yiv5356127746last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5356127746 dd.yiv5356127746last p span.yiv5356127746yshortcuts {margin-right:0;}#yiv5356127746 div.yiv5356127746attach-table div div a {text-decoration:none;}#yiv5356127746 div.yiv5356127746attach-table {width:400px;}#yiv5356127746 div.yiv5356127746file-title a, #yiv5356127746 div.yiv5356127746file-title a:active, #yiv5356127746 div.yiv5356127746file-title a:hover, #yiv5356127746 div.yiv5356127746file-title a:visited {text-decoration:none;}#yiv5356127746 div.yiv5356127746photo-title a, #yiv5356127746 div.yiv5356127746photo-title a:active, #yiv5356127746 div.yiv5356127746photo-title a:hover, #yiv5356127746 div.yiv5356127746photo-title a:visited {text-decoration:none;}#yiv5356127746 div#yiv5356127746ygrp-mlmsg #yiv5356127746ygrp-msg p a span.yiv5356127746yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5356127746 .yiv5356127746green {color:#628c2a;}#yiv5356127746 .yiv5356127746MsoNormal {margin:0 0 0 0;}#yiv5356127746 o {font-size:0;}#yiv5356127746 #yiv5356127746photos div {float:left;width:72px;}#yiv5356127746 #yiv5356127746photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv5356127746 #yiv5356127746photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5356127746 #yiv5356127746reco-category {font-size:77%;}#yiv5356127746 #yiv5356127746reco-desc {font-size:77%;}#yiv5356127746 .yiv5356127746replbq {margin:4px;}#yiv5356127746 #yiv5356127746ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv5356127746 #yiv5356127746ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5356127746 #yiv5356127746ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5356127746 #yiv5356127746ygrp-mlmsg select, #yiv5356127746 input, #yiv5356127746 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv5356127746 #yiv5356127746ygrp-mlmsg pre, #yiv5356127746 code {font:115% monospace;}#yiv5356127746 #yiv5356127746ygrp-mlmsg * {line-height:1.22em;}#yiv5356127746 #yiv5356127746ygrp-mlmsg #yiv5356127746logo {padding-bottom:10px;}#yiv5356127746 #yiv5356127746ygrp-msg p a {font-family:Verdana;}#yiv5356127746 #yiv5356127746ygrp-msg p#yiv5356127746attach-count span {color:#1E66AE;font-weight:700;}#yiv5356127746 #yiv5356127746ygrp-reco #yiv5356127746reco-head {color:#ff7900;font-weight:700;}#yiv5356127746 #yiv5356127746ygrp-reco {margin-bottom:20px;padding:0px;}#yiv5356127746 #yiv5356127746ygrp-sponsor #yiv5356127746ov li a {font-size:130%;text-decoration:none;}#yiv5356127746 #yiv5356127746ygrp-sponsor #yiv5356127746ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv5356127746 #yiv5356127746ygrp-sponsor #yiv5356127746ov ul {margin:0;padding:0 0 0 8px;}#yiv5356127746 #yiv5356127746ygrp-text {font-family:Georgia;}#yiv5356127746 #yiv5356127746ygrp-text p {margin:0 0 1em 0;}#yiv5356127746 #yiv5356127746ygrp-text tt {font-size:120%;}#yiv5356127746 #yiv5356127746ygrp-vital ul li:last-child {border-right:none !important;}#yiv5356127746

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

2c

Re: Mengurutkan data berdasarkan tgl yg lebih muda

Tue Jul 11, 2017 5:55 pm (PDT) . Posted by:

"farud oke"

Klo dengan sort mas.. kan masih melakukan "klik" pada sort-nya,yg di
inginkan saya di kolom/sheet yg di inginkan akan masuk otomatis dan
langsung berurutan mas..

Pada tanggal 12 Jul 2017 6.24 AM, "hendrik karnadi hendrikkarnadi@yahoo.com
[belajar-excel]" <belajar-excel@yahoogroups.com> menulis:

>
>
> Hai Farud,
>
> Apakah tipe data tanggalnya sdh berupa tanggal?
> Kalau sdh...tinggal di sort berdasarkan tanggal.
>
> Salam,
> HK
>
>
> Sent from Yahoo Mail on Android
> <https://overview.mail.yahoo.com/mobile/?.src=Android>
>
>
>
> Assalamualaikum master2 excel..
> Mohon bantuannya..bagaimana caranya mengurutkan data berdasarkan tanggal
> yg lebih muda dan data di sebelahnya mengikuti.untuk lebih jelasnya file
> terlampir.
> Atas bantuan para master sejalian saya sampaikan terimakasih
>
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

2d

Re: Mengurutkan data berdasarkan tgl yg lebih muda [1 Attachment]

Tue Jul 11, 2017 6:31 pm (PDT) . Posted by:

"Nang Agus"

Walaikumsalam warahmatullah,
Pakai pivot atau pakai filter lebih mudah, namun kalau mau pakai formula
juga boleh.
hanya tanggalnya saja kan yang urut? coba di K3 pakai formula ini:
=SMALL($B$3:$B$11,ROW(1:1))
copy ke bawah.

2017-07-11 21:58 GMT+07:00 farud oke farud.oke@gmail.com [belajar-excel] <
belajar-excel@yahoogroups.com>:

>
>
> Assalamualaikum master2 excel..
> Mohon bantuannya..bagaimana caranya mengurutkan data berdasarkan tanggal
> yg lebih muda dan data di sebelahnya mengikuti.untuk lebih jelasnya file
> terlampir.
> Atas bantuan para master sejalian saya sampaikan terimakasih
>
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com
posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com
berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com
keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use