[belajar-excel] Digest Number 3731

Milis Belajar Microsoft Excel Group

7 Messages

Digest #3731

1a

Index Match Data Base KEMBAR by "nursay saefulloh" nursay_saefulloh

1b

Re: Index Match Data Base KEMBAR [1 Attachment] by "Mr. Kid" nmkid.family@ymail.com

1c

Bls: [belajar-excel] Index Match Data Base KEMBAR [1 Attachment] by "nursay saefulloh" nursay_saefulloh

1d

Re: Index Match Data Base KEMBAR [1 Attachment] by "Toby kenzo" tobykenzo

2a

Mencari format tanggal, bulan, tahun pada sederetan angka. by "Indra Sanjaya" indradjaja80an

2b

Re: Mencari format tanggal, bulan, tahun pada sederetan angka. [1 At by "Mr. Kid" nmkid.family@ymail.com

2c

Re: Mencari format tanggal, bulan, tahun pada sederetan angka. [1 At by "Hendrik Karnadi" hendrikkarnadi

Messages

1a

Index Match Data Base KEMBAR

Fri Jan 22, 2016 5:59 am (PST) . Posted by:

"nursay saefulloh" nursay_saefulloh

Ada data base pergantian spare part dan kalau mau membuatnya bagaimana,adapun yang lebih jelas data terlampir.

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

1b

Re: Index Match Data Base KEMBAR [1 Attachment]

Fri Jan 22, 2016 12:38 pm (PST) . Posted by:

"Mr. Kid" nmkid.family@ymail.com

Hai Nursay,

File terlampir memanfaatkan array formula filtering
<http://excel-mr-kid.blogspot.co.id/2011/04/formula-filter-data-filtering-formula.html>
.

Wassalam,
Kid

2016-01-22 19:59 GMT+07:00 nursay saefulloh nursay_saefulloh@yahoo.co.id
[belajar-excel] <belajar-excel@yahoogroups.com>:

>
>
> Ada data base pergantian spare part dan kalau mau membuatnya bagaimana,
> adapun yang lebih jelas data terlampir.
>
>
>

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

1c

Bls: [belajar-excel] Index Match Data Base KEMBAR [1 Attachment]

Fri Jan 22, 2016 6:37 pm (PST) . Posted by:

"nursay saefulloh" nursay_saefulloh

Terimakasih....atas bantuannya.TERBANTU SEKALI


Pada Sabtu, 23 Januari 2016 3:38, "'Mr. Kid' mr.nmkid@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Hai Nursay,

File terlampir memanfaatkan array formula filtering.

Wassalam,
Kid

2016-01-22 19:59 GMT+07:00 nursay saefulloh nursay_saefulloh@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com>:

  Ada data base pergantian spare part dan kalau mau membuatnya bagaimana,adapun yang lebih jelas data terlampir.


#yiv8984223188 #yiv8984223188 -- #yiv8984223188ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8984223188 #yiv8984223188ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8984223188 #yiv8984223188ygrp-mkp #yiv8984223188hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8984223188 #yiv8984223188ygrp-mkp #yiv8984223188ads {margin-bottom:10px;}#yiv8984223188 #yiv8984223188ygrp-mkp .yiv8984223188ad {padding:0 0;}#yiv8984223188 #yiv8984223188ygrp-mkp .yiv8984223188ad p {margin:0;}#yiv8984223188 #yiv8984223188ygrp-mkp .yiv8984223188ad a {color:#0000ff;text-decoration:none;}#yiv8984223188 #yiv8984223188ygrp-sponsor #yiv8984223188ygrp-lc {font-family:Arial;}#yiv8984223188 #yiv8984223188ygrp-sponsor #yiv8984223188ygrp-lc #yiv8984223188hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8984223188 #yiv8984223188ygrp-sponsor #yiv8984223188ygrp-lc .yiv8984223188ad {margin-bottom:10px;padding:0 0;}#yiv8984223188 #yiv8984223188actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8984223188 #yiv8984223188activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8984223188 #yiv8984223188activity span {font-weight:700;}#yiv8984223188 #yiv8984223188activity span:first-child {text-transform:uppercase;}#yiv8984223188 #yiv8984223188activity span a {color:#5085b6;text-decoration:none;}#yiv8984223188 #yiv8984223188activity span span {color:#ff7900;}#yiv8984223188 #yiv8984223188activity span .yiv8984223188underline {text-decoration:underline;}#yiv8984223188 .yiv8984223188attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8984223188 .yiv8984223188attach div a {text-decoration:none;}#yiv8984223188 .yiv8984223188attach img {border:none;padding-right:5px;}#yiv8984223188 .yiv8984223188attach label {display:block;margin-bottom:5px;}#yiv8984223188 .yiv8984223188attach label a {text-decoration:none;}#yiv8984223188 blockquote {margin:0 0 0 4px;}#yiv8984223188 .yiv8984223188bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8984223188 .yiv8984223188bold a {text-decoration:none;}#yiv8984223188 dd.yiv8984223188last p a {font-family:Verdana;font-weight:700;}#yiv8984223188 dd.yiv8984223188last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8984223188 dd.yiv8984223188last p span.yiv8984223188yshortcuts {margin-right:0;}#yiv8984223188 div.yiv8984223188attach-table div div a {text-decoration:none;}#yiv8984223188 div.yiv8984223188attach-table {width:400px;}#yiv8984223188 div.yiv8984223188file-title a, #yiv8984223188 div.yiv8984223188file-title a:active, #yiv8984223188 div.yiv8984223188file-title a:hover, #yiv8984223188 div.yiv8984223188file-title a:visited {text-decoration:none;}#yiv8984223188 div.yiv8984223188photo-title a, #yiv8984223188 div.yiv8984223188photo-title a:active, #yiv8984223188 div.yiv8984223188photo-title a:hover, #yiv8984223188 div.yiv8984223188photo-title a:visited {text-decoration:none;}#yiv8984223188 div#yiv8984223188ygrp-mlmsg #yiv8984223188ygrp-msg p a span.yiv8984223188yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8984223188 .yiv8984223188green {color:#628c2a;}#yiv8984223188 .yiv8984223188MsoNormal {margin:0 0 0 0;}#yiv8984223188 o {font-size:0;}#yiv8984223188 #yiv8984223188photos div {float:left;width:72px;}#yiv8984223188 #yiv8984223188photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv8984223188 #yiv8984223188photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8984223188 #yiv8984223188reco-category {font-size:77%;}#yiv8984223188 #yiv8984223188reco-desc {font-size:77%;}#yiv8984223188 .yiv8984223188replbq {margin:4px;}#yiv8984223188 #yiv8984223188ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8984223188 #yiv8984223188ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8984223188 #yiv8984223188ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8984223188 #yiv8984223188ygrp-mlmsg select, #yiv8984223188 input, #yiv8984223188 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8984223188 #yiv8984223188ygrp-mlmsg pre, #yiv8984223188 code {font:115% monospace;}#yiv8984223188 #yiv8984223188ygrp-mlmsg * {line-height:1.22em;}#yiv8984223188 #yiv8984223188ygrp-mlmsg #yiv8984223188logo {padding-bottom:10px;}#yiv8984223188 #yiv8984223188ygrp-msg p a {font-family:Verdana;}#yiv8984223188 #yiv8984223188ygrp-msg p#yiv8984223188attach-count span {color:#1E66AE;font-weight:700;}#yiv8984223188 #yiv8984223188ygrp-reco #yiv8984223188reco-head {color:#ff7900;font-weight:700;}#yiv8984223188 #yiv8984223188ygrp-reco {margin-bottom:20px;padding:0px;}#yiv8984223188 #yiv8984223188ygrp-sponsor #yiv8984223188ov li a {font-size:130%;text-decoration:none;}#yiv8984223188 #yiv8984223188ygrp-sponsor #yiv8984223188ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv8984223188 #yiv8984223188ygrp-sponsor #yiv8984223188ov ul {margin:0;padding:0 0 0 8px;}#yiv8984223188 #yiv8984223188ygrp-text {font-family:Georgia;}#yiv8984223188 #yiv8984223188ygrp-text p {margin:0 0 1em 0;}#yiv8984223188 #yiv8984223188ygrp-text tt {font-size:120%;}#yiv8984223188 #yiv8984223188ygrp-vital ul li:last-child {border-right:none !important;}#yiv8984223188

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

1d

Re: Index Match Data Base KEMBAR [1 Attachment]

Fri Jan 22, 2016 6:59 pm (PST) . Posted by:

"Toby kenzo" tobykenzo

Hai Nursay,

Bisa jg menggunakan vba dgn memanfaatkan combobox, autofilter method, copy destination.

TerimaKasih.

Sent from Yahoo Mail on Android

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

2a

Mencari format tanggal, bulan, tahun pada sederetan angka.

Fri Jan 22, 2016 9:30 pm (PST) . Posted by:

"Indra Sanjaya" indradjaja80an

Dear Para Master Excel,
Saya memiliki data berupa Nama, NIK, No KTP seperti tabel di bawah ini:

| No

| Nama

| NIK

| No KTP

|
| 1

| Meggy A

| 0101050370

| 3276041703700001

|
| 2

| Meggy B

| 0107060566

| 3275030405660020

|
| 3

| Meggy C

| 0112120272

| 3276051012720003

|
| 4

| Meggy D

| 1512070181

| 3174081101810005

|
| 5

| Meggy E

| 0106130769

| 3271030307690011

|
| 6

| SUSI A

| 0303100190

| 3174094301900001

|
| 7

| SUSI B

| 2801130993

| 3674036109930010

|
| 8

| SUSI C

| 2504121287

| 3276106412830002

|
| 9

| SUSI D

| 0712150792

| 3276045207920004

|
| 10

| SUSI E

| 0301111089

| 3175096610890005

|

Bagaimana mengubah 6 digit pertama pada kolom NIK dan digit ke 7 s.d. 12 pada kolom No KTP agar menjadi format tanggal, bulan, tahun?
Atas solusinya Saya haturkan banyak terima kasih.
Salam,
Indra Sanjaya.

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

2b

Re: Mencari format tanggal, bulan, tahun pada sederetan angka. [1 At

Fri Jan 22, 2016 10:46 pm (PST) . Posted by:

"Mr. Kid" nmkid.family@ymail.com

Hai Indra Sanjaya,

File terlampir menggunakan cukup banyak asumsi.

Regards,
Kid

2016-01-23 12:20 GMT+07:00 Indra Sanjaya indradjaja80an@yahoo.com
[belajar-excel] <belajar-excel@yahoogroups.com>:

>
>
> Dear Para Master Excel,
>
> Saya memiliki data berupa Nama, NIK, No KTP seperti tabel di bawah ini:
>
> *No*
> *Nama*
> *NIK*
> *No KTP*
> 1
> Meggy A
> 0101050370
> 3276041703700001
> 2
> Meggy B
> 0107060566
> 3275030405660020
> 3
> Meggy C
> 0112120272
> 3276051012720003
> 4
> Meggy D
> 1512070181
> 3174081101810005
> 5
> Meggy E
> 0106130769
> 3271030307690011
> 6
> SUSI A
> 0303100190
> 3174094301900001
> 7
> SUSI B
> 2801130993
> 3674036109930010
> 8
> SUSI C
> 2504121287
> 3276106412830002
> 9
> SUSI D
> 0712150792
> 3276045207920004
> 10
> SUSI E
> 0301111089
> 3175096610890005
>
> Bagaimana mengubah 6 digit pertama pada kolom NIK dan digit ke 7 s.d. 12
> pada kolom No KTP agar menjadi format tanggal, bulan, tahun?
>
> Atas solusinya Saya haturkan banyak terima kasih.
>
> Salam,
>
> Indra Sanjaya.
>
>
>

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

2c

Re: Mencari format tanggal, bulan, tahun pada sederetan angka. [1 At

Fri Jan 22, 2016 10:52 pm (PST) . Posted by:

"Hendrik Karnadi" hendrikkarnadi

Hai Indra,
Bisa diberi contoh hasil yang diiinginkan ?
Karena kalo digabung kan jadi text (12 digit)...yang mana yang mau dibuat format tgl ?

Salam,
HK

Sent from Samsung Mobile

<div>-------- Original message --------</div><div>From: "Indra Sanjaya indradjaja80an@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> </div><div>Date:23/01/2016 12:20 PM (GMT+07:00) </div><div>To: belajar-excel@yahoogroups.com </div><div>Subject: [belajar-excel] Mencari format tanggal, bulan, tahun pada sederetan angka. [1 Attachment] </div><div>
</div>Dear Para Master Excel,

Saya memiliki data berupa Nama, NIK, No KTP seperti tabel di bawah ini:

No
Nama
NIK
No KTP
1
Meggy A
0101050370
3276041703700001
2
Meggy B
0107060566
3275030405660020
3
Meggy C
0112120272
3276051012720003
4
Meggy D
1512070181
3174081101810005
5
Meggy E
0106130769
3271030307690011
6
SUSI A
0303100190
3174094301900001
7
SUSI B
2801130993
3674036109930010
8
SUSI C
2504121287
3276106412830002
9
SUSI D
0712150792
3276045207920004
10
SUSI E
0301111089
3175096610890005

Bagaimana mengubah 6 digit pertama pada kolom NIK dan digit ke 7 s.d. 12 pada kolom No KTP agar menjadi format tanggal, bulan, tahun?

Atas solusinya Saya haturkan banyak terima kasih.

Salam,

Indra Sanjaya.

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

• Privacy • Unsubscribe • Terms of Use