[belajar-excel] Digest Number 4347

Milis Belajar Microsoft Excel Group

4 Messages

Digest #4347

1a

Hasilnya Header by "Dede Sulaeman"

1b

Re: Hasilnya Header [1 Attachment] by "nangagus"

1c

Re: Hasilnya Header by "Dede Sulaeman"

2a

Bls: [belajar-excel] Merubah format report A ke B [1 Attachment] by "mulki akbar" mulki_akbar

Messages

1a

Hasilnya Header

Wed Nov 8, 2017 1:23 am (PST) . Posted by:

"Dede Sulaeman"

Dear Be-Exceller,

Mohon masukannya.

Kasusnya adalah di range yang berwarna kuning harus terisi tanggal dari Ceklist terakhir.

Lebih jelasnya file terlampir.

Salam,

DD

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

1b

Re: Hasilnya Header [1 Attachment]

Wed Nov 8, 2017 5:51 am (PST) . Posted by:

"nangagus"

Dear DD

untuk threat baru sebaiknya buat email baru ke b-excel, bukan reply
treat yang tidak satu masalah.

coba gunakan formula:
=INDEX($E$2:$BN$2;;MAX(INDEX(($E5:$BN5="✔")*COLUMN($E5:$BN5);;))-4)

salam

NangAgus

On 08/11/2017 16:22, 'Dede Sulaeman' dede_sulaeman@pinusmerahabadi.co.id
[belajar-excel] wrote:
>
> Dear Be-Exceller,
>
> Mohon masukannya.
>
> Kasusnya adalah di range yang berwarna kuning harus terisi tanggal
> dari Ceklist terakhir.
>
> Lebih jelasnya file terlampir.
>
> Salam,
>
> DD
>
>

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

1c

Re: Hasilnya Header

Wed Nov 8, 2017 5:22 pm (PST) . Posted by:

"Dede Sulaeman"

Dear Mas Nang,

Terima kasih.

Case closed.

Salam,

DD

From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: 08 November 2017 20:51
To: belajar-excel@yahoogroups.com
Subject: Re: [belajar-excel] Hasilnya Header

Dear DD

untuk threat baru sebaiknya buat email baru ke b-excel, bukan reply treat yang tidak satu masalah.

coba gunakan formula:
=INDEX($E$2:$BN$2;;MAX(INDEX(($E5:$BN5="✔")*COLUMN($E5:$BN5);;))-4)

salam

NangAgus

On 08/11/2017 16:22, 'Dede Sulaeman' dede_sulaeman@pinusmerahabadi.co.id [belajar-excel] wrote:

Dear Be-Exceller,

Mohon masukannya.

Kasusnya adalah di range yang berwarna kuning harus terisi tanggal dari Ceklist terakhir.

Lebih jelasnya file terlampir.

Salam,

DD

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

2a

Bls: [belajar-excel] Merubah format report A ke B [1 Attachment]

Wed Nov 8, 2017 2:00 am (PST) . Posted by:

"mulki akbar" mulki_akbar

Dear Pak Kenang & Pak Ade,
Terimakasih atas pencerahannya. Insyaallah bermanfaat.

Wassalam,Mulki


Pada Rabu, 8 November 2017 7:07, "nangagus nangagus@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Dear Mulki Asalamualaikum warahmatullah
sesuai arahan pak Cik Lukman, file terlampir menggunakan formula, dan hanya sebatas data seperti contoh, silahkan dikembangkan sesuai kebutuhan dengan berbagai batasan formula selamat belajar Wasalamualaikum warahmatullah
Kenang
On 07/11/2017 13:39, Pak Cik Lukman pakciklukman@gmail.com [belajar-excel] wrote:

  dear mr Mulki,
mari kita coba aplikasiin formula yg sering digunakan =Index(match(countif(...)));0)) sering di gunakan oleh master2 disini dalam penyusunan data pivot dgn menggunakan formula 
formula ini sering dicontohkan oleh masta Nanang dan masta Odong Nando dalam menjawab pertanyaan rekan2 lain
salam,
2017-11-07 13:23 GMT+07:00 mulki akbar mulki_akbar@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com>:

  Dear Pak Ade,
Terimakasih atas jawabannya. Formatnya belum sesuai dg saya inginkan.
Kiranya ada alternatif lain?


Pada Selasa, 7 November 2017 10:34, "'M.Ade Alfarid' QA@kkmi.co.id [belajar-excel]" <belajar-excel@yahoogroups.com > menulis:


  Mungkin seperti ini? Coba gunakan format as table sebelahnya conditional formatting     Salam, Ade   From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: Tuesday, November 7, 2017 9:27 AM
To: BeExcel
Subject:[belajar-excel] Merubah format report A ke B [1 Attachment]     Assalamu'alaikum Wr. Wb.   Selamat Pagi dan Salam sejahtera,     Mohon bantuan rekan2 dan guru B-XLers atas kasus terlampir. Saya memiliki data dengan format awal (Tabel 1) yg ingin diubah menjadi seperti format pada Tabel 2.   Mohon pencerahannya. Jika kasus seperti ini pernah dibahas sebelumnya, kiranya rekan2 berkenan memberikan linknya utk saya cek.   Terimakasih atas perhatiannya.     Wassalam, Mulki  




#yiv1958305602 #yiv1958305602 -- #yiv1958305602ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1958305602 #yiv1958305602ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1958305602 #yiv1958305602ygrp-mkp #yiv1958305602hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv1958305602 #yiv1958305602ygrp-mkp #yiv1958305602ads {margin-bottom:10px;}#yiv1958305602 #yiv1958305602ygrp-mkp .yiv1958305602ad {padding:0 0;}#yiv1958305602 #yiv1958305602ygrp-mkp .yiv1958305602ad p {margin:0;}#yiv1958305602 #yiv1958305602ygrp-mkp .yiv1958305602ad a {color:#0000ff;text-decoration:none;}#yiv1958305602 #yiv1958305602ygrp-sponsor #yiv1958305602ygrp-lc {font-family:Arial;}#yiv1958305602 #yiv1958305602ygrp-sponsor #yiv1958305602ygrp-lc #yiv1958305602hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1958305602 #yiv1958305602ygrp-sponsor #yiv1958305602ygrp-lc .yiv1958305602ad {margin-bottom:10px;padding:0 0;}#yiv1958305602 #yiv1958305602actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1958305602 #yiv1958305602activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1958305602 #yiv1958305602activity span {font-weight:700;}#yiv1958305602 #yiv1958305602activity span:first-child {text-transform:uppercase;}#yiv1958305602 #yiv1958305602activity span a {color:#5085b6;text-decoration:none;}#yiv1958305602 #yiv1958305602activity span span {color:#ff7900;}#yiv1958305602 #yiv1958305602activity span .yiv1958305602underline {text-decoration:underline;}#yiv1958305602 .yiv1958305602attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv1958305602 .yiv1958305602attach div a {text-decoration:none;}#yiv1958305602 .yiv1958305602attach img {border:none;padding-right:5px;}#yiv1958305602 .yiv1958305602attach label {display:block;margin-bottom:5px;}#yiv1958305602 .yiv1958305602attach label a {text-decoration:none;}#yiv1958305602 blockquote {margin:0 0 0 4px;}#yiv1958305602 .yiv1958305602bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv1958305602 .yiv1958305602bold a {text-decoration:none;}#yiv1958305602 dd.yiv1958305602last p a {font-family:Verdana;font-weight:700;}#yiv1958305602 dd.yiv1958305602last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1958305602 dd.yiv1958305602last p span.yiv1958305602yshortcuts {margin-right:0;}#yiv1958305602 div.yiv1958305602attach-table div div a {text-decoration:none;}#yiv1958305602 div.yiv1958305602attach-table {width:400px;}#yiv1958305602 div.yiv1958305602file-title a, #yiv1958305602 div.yiv1958305602file-title a:active, #yiv1958305602 div.yiv1958305602file-title a:hover, #yiv1958305602 div.yiv1958305602file-title a:visited {text-decoration:none;}#yiv1958305602 div.yiv1958305602photo-title a, #yiv1958305602 div.yiv1958305602photo-title a:active, #yiv1958305602 div.yiv1958305602photo-title a:hover, #yiv1958305602 div.yiv1958305602photo-title a:visited {text-decoration:none;}#yiv1958305602 div#yiv1958305602ygrp-mlmsg #yiv1958305602ygrp-msg p a span.yiv1958305602yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1958305602 .yiv1958305602green {color:#628c2a;}#yiv1958305602 .yiv1958305602MsoNormal {margin:0 0 0 0;}#yiv1958305602 o {font-size:0;}#yiv1958305602 #yiv1958305602photos div {float:left;width:72px;}#yiv1958305602 #yiv1958305602photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv1958305602 #yiv1958305602photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1958305602 #yiv1958305602reco-category {font-size:77%;}#yiv1958305602 #yiv1958305602reco-desc {font-size:77%;}#yiv1958305602 .yiv1958305602replbq {margin:4px;}#yiv1958305602 #yiv1958305602ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv1958305602 #yiv1958305602ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1958305602 #yiv1958305602ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1958305602 #yiv1958305602ygrp-mlmsg select, #yiv1958305602 input, #yiv1958305602 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv1958305602 #yiv1958305602ygrp-mlmsg pre, #yiv1958305602 code {font:115% monospace;}#yiv1958305602 #yiv1958305602ygrp-mlmsg * {line-height:1.22em;}#yiv1958305602 #yiv1958305602ygrp-mlmsg #yiv1958305602logo {padding-bottom:10px;}#yiv1958305602 #yiv1958305602ygrp-msg p a {font-family:Verdana;}#yiv1958305602 #yiv1958305602ygrp-msg p#yiv1958305602attach-count span {color:#1E66AE;font-weight:700;}#yiv1958305602 #yiv1958305602ygrp-reco #yiv1958305602reco-head {color:#ff7900;font-weight:700;}#yiv1958305602 #yiv1958305602ygrp-reco {margin-bottom:20px;padding:0px;}#yiv1958305602 #yiv1958305602ygrp-sponsor #yiv1958305602ov li a {font-size:130%;text-decoration:none;}#yiv1958305602 #yiv1958305602ygrp-sponsor #yiv1958305602ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv1958305602 #yiv1958305602ygrp-sponsor #yiv1958305602ov ul {margin:0;padding:0 0 0 8px;}#yiv1958305602 #yiv1958305602ygrp-text {font-family:Georgia;}#yiv1958305602 #yiv1958305602ygrp-text p {margin:0 0 1em 0;}#yiv1958305602 #yiv1958305602ygrp-text tt {font-size:120%;}#yiv1958305602 #yiv1958305602ygrp-vital ul li:last-child {border-right:none !important;}#yiv1958305602

Reply to sender . Reply to group . Reply via Web Post . All Messages (9) . 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

• Privacy • Unsubscribe • Terms of Use