9 Messages
Digest #3503
2a
Bls: [belajar-excel] Menghapus data yang sama/ double secara otomati by "pokja konsultan" konsultan_pokja
2b
Bls: [belajar-excel] Menghapus data yang sama/ double secara otomati by "Lazuardi Biru" lazuardi_biru84
2c
Fw: Bls: [belajar-excel] Menghapus data yang sama/ double secara oto by "hendrik karnadi" hendrikkarnadi
2d
Bls: Bls: [belajar-excel] Menghapus data yang sama/ double secara ot by "Lazuardi Biru" lazuardi_biru84
2e
Re: Bls: Bls: [belajar-excel] Menghapus data yang sama/ double secar by "hendrik karnadi" hendrikkarnadi
Messages
Thu Jul 9, 2015 11:40 am (PDT) . Posted by:
"Mr. Kid" nmkid.family@ymail.com
Hai Heru,
Coba lihat-lihat file ini
<https://app.box.com/s/cwrwttemari5fhxdjvxgeq27q7itkx63>. Silakan
dikembangkan sesuai kebutuhan.
Wassalam,
Kid
2015-07-02 14:44 GMT+07:00 Heru Safrudin superheruu@gmail.com
[belajar-excel] <belajar-excel@yahoogroups.com>:
>
>
> Bagaimana caranya kita bisa meletakkan control webcam atau perekam gambar
> yg lain di worksheet ?
> Tujuannya untuk mengambil gambar/foto karyawan dan menyimpan di database
>
> Terima kasih atas pencerahannya
>
> Wassalam,
>
> Heru Safrudin
>
>
>
Coba lihat-lihat file ini
<https://app.box.com/s/cwrwttemari5fhxdjvxgeq27q7itkx63>. Silakan
dikembangkan sesuai kebutuhan.
Wassalam,
Kid
2015-07-02 14:44 GMT+07:00 Heru Safrudin superheruu@gmail.com
[belajar-excel] <belajar-excel@yahoogroups.com>:
>
>
> Bagaimana caranya kita bisa meletakkan control webcam atau perekam gambar
> yg lain di worksheet ?
> Tujuannya untuk mengambil gambar/foto karyawan dan menyimpan di database
>
> Terima kasih atas pencerahannya
>
> Wassalam,
>
> Heru Safrudin
>
>
>
Thu Jul 9, 2015 11:19 pm (PDT) . Posted by:
"Heru Safrudin" superheruu
Wah kalo lihat codenya kayaknya cocok tuh, sayang gak bisa dibuka soalnya
Excel saya masih 2003, bisakah dikonversi ke 2003 ?
Wassalam,
Heru Safrudin
PT. BISI International, Tbk.
Pada 2015 7 10 01:40, "'Mr. Kid' mr.nmkid@gmail.com [belajar-excel]" <
belajar-excel@yahoogroups.com> menulis:
>
>
> Hai Heru,
>
> Coba lihat-lihat file ini
> <https://app.box.com/s/cwrwttemari5fhxdjvxgeq27q7itkx63>. Silakan
> dikembangkan sesuai kebutuhan.
>
> Wassalam,
> Kid
>
>
> 2015-07-02 14:44 GMT+07:00 Heru Safrudin superheruu@gmail.com
> [belajar-excel] <belajar-excel@yahoogroups.com>:
>
>>
>>
>> Bagaimana caranya kita bisa meletakkan control webcam atau perekam gambar
>> yg lain di worksheet ?
>> Tujuannya untuk mengambil gambar/foto karyawan dan menyimpan di database
>>
>> Terima kasih atas pencerahannya
>>
>> Wassalam,
>>
>> Heru Safrudin
>>
>>
>
>
Excel saya masih 2003, bisakah dikonversi ke 2003 ?
Wassalam,
Heru Safrudin
PT. BISI International, Tbk.
Pada 2015 7 10 01:40, "'Mr. Kid' mr.nmkid@gmail.com [belajar-excel]" <
belajar-excel@yahoogroups.com> menulis:
>
>
> Hai Heru,
>
> Coba lihat-lihat file ini
> <https://app.box.com/s/cwrwttemari5fhxdjvxgeq27q7itkx63>. Silakan
> dikembangkan sesuai kebutuhan.
>
> Wassalam,
> Kid
>
>
> 2015-07-02 14:44 GMT+07:00 Heru Safrudin superheruu@gmail.com
> [belajar-excel] <belajar-excel@yahoogroups.com>:
>
>>
>>
>> Bagaimana caranya kita bisa meletakkan control webcam atau perekam gambar
>> yg lain di worksheet ?
>> Tujuannya untuk mengambil gambar/foto karyawan dan menyimpan di database
>>
>> Terima kasih atas pencerahannya
>>
>> Wassalam,
>>
>> Heru Safrudin
>>
>>
>
>
Fri Jul 10, 2015 12:54 am (PDT) . Posted by:
"Mr. Kid" nmkid.family@ymail.com
Konversi ke xl2003 bisa dilakukan dengan proses save as. Andai muncul
masalah, biasanya disebabkan activex control dasar yang perlu pembuatan
ulang, mulai dari userform, textbox, dsb.. Untuk module dasarnya tetap di
general module selain module modInput.
Penggunaan pada xl2010 ke atas yang menggunakan office 64 bit, pastikan
reference quartz.dll ke file yang ada di folder system32 dan dilakukan
penyesuaian deklarasi API Function dengan ptrsafe.
Silakan disesuaikan dan dikembangkan sesuai kebutuhan setempat.
2015-07-10 13:19 GMT+07:00 Heru Safrudin superheruu@gmail.com
[belajar-excel] <belajar-excel@yahoogroups.com>:
>
>
> Wah kalo lihat codenya kayaknya cocok tuh, sayang gak bisa dibuka soalnya
> Excel saya masih 2003, bisakah dikonversi ke 2003 ?
>
> Wassalam,
>
> Heru Safrudin
> PT. BISI International, Tbk.
> Pada 2015 7 10 01:40, "'Mr. Kid' mr.nmkid@gmail.com [belajar-excel]" <
> belajar-excel@yahoogroups.com> menulis:
>
>>
>>
>> Hai Heru,
>>
>> Coba lihat-lihat file ini
>> <https://app.box.com/s/cwrwttemari5fhxdjvxgeq27q7itkx63>. Silakan
>> dikembangkan sesuai kebutuhan.
>>
>> Wassalam,
>> Kid
>>
>>
>> 2015-07-02 14:44 GMT+07:00 Heru Safrudin superheruu@gmail.com
>> [belajar-excel] <belajar-excel@yahoogroups.com>:
>>
>>>
>>>
>>> Bagaimana caranya kita bisa meletakkan control webcam atau perekam
>>> gambar yg lain di worksheet ?
>>> Tujuannya untuk mengambil gambar/foto karyawan dan menyimpan di database
>>>
>>> Terima kasih atas pencerahannya
>>>
>>> Wassalam,
>>>
>>> Heru Safrudin
>>>
>>>
>>
>
masalah, biasanya disebabkan activex control dasar yang perlu pembuatan
ulang, mulai dari userform, textbox, dsb.. Untuk module dasarnya tetap di
general module selain module modInput.
Penggunaan pada xl2010 ke atas yang menggunakan office 64 bit, pastikan
reference quartz.dll ke file yang ada di folder system32 dan dilakukan
penyesuaian deklarasi API Function dengan ptrsafe.
Silakan disesuaikan dan dikembangkan sesuai kebutuhan setempat.
2015-07-10 13:19 GMT+07:00 Heru Safrudin superheruu@gmail.com
[belajar-excel] <belajar-excel@yahoogroups.com>:
>
>
> Wah kalo lihat codenya kayaknya cocok tuh, sayang gak bisa dibuka soalnya
> Excel saya masih 2003, bisakah dikonversi ke 2003 ?
>
> Wassalam,
>
> Heru Safrudin
> PT. BISI International, Tbk.
> Pada 2015 7 10 01:40, "'Mr. Kid' mr.nmkid@gmail.com [belajar-excel]" <
> belajar-excel@yahoogroups.com> menulis:
>
>>
>>
>> Hai Heru,
>>
>> Coba lihat-lihat file ini
>> <https://app.box.com/s/cwrwttemari5fhxdjvxgeq27q7itkx63>. Silakan
>> dikembangkan sesuai kebutuhan.
>>
>> Wassalam,
>> Kid
>>
>>
>> 2015-07-02 14:44 GMT+07:00 Heru Safrudin superheruu@gmail.com
>> [belajar-excel] <belajar-excel@yahoogroups.com>:
>>
>>>
>>>
>>> Bagaimana caranya kita bisa meletakkan control webcam atau perekam
>>> gambar yg lain di worksheet ?
>>> Tujuannya untuk mengambil gambar/foto karyawan dan menyimpan di database
>>>
>>> Terima kasih atas pencerahannya
>>>
>>> Wassalam,
>>>
>>> Heru Safrudin
>>>
>>>
>>
>
Thu Jul 9, 2015 7:16 pm (PDT) . Posted by:
"pokja konsultan" konsultan_pokja
Kalau mau menghapusnya dengan formula gimana Misal : SRINING KUSTIYAH (3)berarti nama tersebut ada 3 data yang sama, tapi hanya 1 nama yang di tulis.
Pada Rabu, 8 Juli 2015 18:18, "'Paulroth' iq_bal76id@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Dear konsultan pokja,Bisa gunakan menu remove duplicate.Block seluruh data, klik ribbon data, dan pilih icon remove duplicate.> klik ok /yes.Done. ThanksRegardMuhammad Iqbal From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: Wednesday, July 08, 2015 2:17 PM
To: belajar-excel@yahoogroups.com
Subject: [belajar-excel] Menghapus data yang sama/ double secara otomatis [1 Attachment] Saya ingin menghapus data yang sama / double secara otomatis. Gimana caranya ya. Trima kasih atas bantuannya #yiv2601681551 #yiv2601681551 -- #yiv2601681551ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2601681551 #yiv2601681551ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2601681551 #yiv2601681551ygrp-mkp #yiv2601681551hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2601681551 #yiv2601681551ygrp-mkp #yiv2601681551ads {margin-bottom:10px;}#yiv2601681551 #yiv2601681551ygrp-mkp .yiv2601681551ad {padding:0 0;}#yiv2601681551 #yiv2601681551ygrp-mkp .yiv2601681551ad p {margin:0;}#yiv2601681551 #yiv2601681551ygrp-mkp .yiv2601681551ad a {color:#0000ff;text-decoration:none;}#yiv2601681551 #yiv2601681551ygrp-sponsor #yiv2601681551ygrp-lc {font-family:Arial;}#yiv2601681551 #yiv2601681551ygrp-sponsor #yiv2601681551ygrp-lc #yiv2601681551hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2601681551 #yiv2601681551ygrp-sponsor #yiv2601681551ygrp-lc .yiv2601681551ad {margin-bottom:10px;padding:0 0;}#yiv2601681551 #yiv2601681551actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2601681551 #yiv2601681551activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2601681551 #yiv2601681551activity span {font-weight:700;}#yiv2601681551 #yiv2601681551activity span:first-child {text-transform:uppercase;}#yiv2601681551 #yiv2601681551activity span a {color:#5085b6;text-decoration:none;}#yiv2601681551 #yiv2601681551activity span span {color:#ff7900;}#yiv2601681551 #yiv2601681551activity span .yiv2601681551underline {text-decoration:underline;}#yiv2601681551 .yiv2601681551attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2601681551 .yiv2601681551attach div a {text-decoration:none;}#yiv2601681551 .yiv2601681551attach img {border:none;padding-right:5px;}#yiv2601681551 .yiv2601681551attach label {display:block;margin-bottom:5px;}#yiv2601681551 .yiv2601681551attach label a {text-decoration:none;}#yiv2601681551 blockquote {margin:0 0 0 4px;}#yiv2601681551 .yiv2601681551bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2601681551 .yiv2601681551bold a {text-decoration:none;}#yiv2601681551 dd.yiv2601681551last p a {font-family:Verdana;font-weight:700;}#yiv2601681551 dd.yiv2601681551last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2601681551 dd.yiv2601681551last p span.yiv2601681551yshortcuts {margin-right:0;}#yiv2601681551 div.yiv2601681551attach-table div div a {text-decoration:none;}#yiv2601681551 div.yiv2601681551attach-table {width:400px;}#yiv2601681551 div.yiv2601681551file-title a, #yiv2601681551 div.yiv2601681551file-title a:active, #yiv2601681551 div.yiv2601681551file-title a:hover, #yiv2601681551 div.yiv2601681551file-title a:visited {text-decoration:none;}#yiv2601681551 div.yiv2601681551photo-title a, #yiv2601681551 div.yiv2601681551photo-title a:active, #yiv2601681551 div.yiv2601681551photo-title a:hover, #yiv2601681551 div.yiv2601681551photo-title a:visited {text-decoration:none;}#yiv2601681551 div#yiv2601681551ygrp-mlmsg #yiv2601681551ygrp-msg p a span.yiv2601681551yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2601681551 .yiv2601681551green {color:#628c2a;}#yiv2601681551 .yiv2601681551MsoNormal {margin:0 0 0 0;}#yiv2601681551 o {font-size:0;}#yiv2601681551 #yiv2601681551photos div {float:left;width:72px;}#yiv2601681551 #yiv2601681551photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv2601681551 #yiv2601681551photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2601681551 #yiv2601681551reco-category {font-size:77%;}#yiv2601681551 #yiv2601681551reco-desc {font-size:77%;}#yiv2601681551 .yiv2601681551replbq {margin:4px;}#yiv2601681551 #yiv2601681551ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2601681551 #yiv2601681551ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2601681551 #yiv2601681551ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2601681551 #yiv2601681551ygrp-mlmsg select, #yiv2601681551 input, #yiv2601681551 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2601681551 #yiv2601681551ygrp-mlmsg pre, #yiv2601681551 code {font:115% monospace;}#yiv2601681551 #yiv2601681551ygrp-mlmsg * {line-height:1.22em;}#yiv2601681551 #yiv2601681551ygrp-mlmsg #yiv2601681551logo {padding-bottom:10px;}#yiv2601681551 #yiv2601681551ygrp-msg p a {font-family:Verdana;}#yiv2601681551 #yiv2601681551ygrp-msg p#yiv2601681551attach-count span {color:#1E66AE;font-weight:700;}#yiv2601681551 #yiv2601681551ygrp-reco #yiv2601681551reco-head {color:#ff7900;font-weight:700;}#yiv2601681551 #yiv2601681551ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2601681551 #yiv2601681551ygrp-sponsor #yiv2601681551ov li a {font-size:130%;text-decoration:none;}#yiv2601681551 #yiv2601681551ygrp-sponsor #yiv2601681551ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2601681551 #yiv2601681551ygrp-sponsor #yiv2601681551ov ul {margin:0;padding:0 0 0 8px;}#yiv2601681551 #yiv2601681551ygrp-text {font-family:Georgia;}#yiv2601681551 #yiv2601681551ygrp-text p {margin:0 0 1em 0;}#yiv2601681551 #yiv2601681551ygrp-text tt {font-size:120%;}#yiv2601681551 #yiv2601681551ygrp-vital ul li:last-child {border-right:none !important;}#yiv2601681551
Pada Rabu, 8 Juli 2015 18:18, "'Paulroth' iq_bal76id@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Dear konsultan pokja,Bisa gunakan menu remove duplicate.Block seluruh data, klik ribbon data, dan pilih icon remove duplicate.> klik ok /yes.Done. ThanksRegardMuhammad Iqbal From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: Wednesday, July 08, 2015 2:17 PM
To: belajar-excel@yahoogroups.com
Subject: [belajar-excel] Menghapus data yang sama/ double secara otomatis [1 Attachment] Saya ingin menghapus data yang sama / double secara otomatis. Gimana caranya ya. Trima kasih atas bantuannya #yiv2601681551 #yiv2601681551 -- #yiv2601681551ygrp-
Thu Jul 9, 2015 9:57 pm (PDT) . Posted by:
"Lazuardi Biru" lazuardi_biru84
dhdear pokja
mungkin seperti file terlampir..
salam
lb
Pada Jumat, 10 Juli 2015 9:16, "pokja konsultan konsultan_pokja@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Kalau mau menghapusnya dengan formula gimana Misal : SRINING KUSTIYAH (3)berarti nama tersebut ada 3 data yang sama, tapi hanya 1 nama yang di tulis.
Pada Rabu, 8 Juli 2015 18:18, "'Paulroth' iq_bal76id@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Dear konsultan pokja,Bisa gunakan menu remove duplicate.Block seluruh data, klik ribbon data, dan pilih icon remove duplicate.> klik ok /yes.Done. ThanksRegardMuhammad Iqbal From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: Wednesday, July 08, 2015 2:17 PM
To: belajar-excel@yahoogroups.com
Subject: [belajar-excel] Menghapus data yang sama/ double secara otomatis [1 Attachment] Saya ingin menghapus data yang sama / double secara otomatis. Gimana caranya ya. Trima kasih atas bantuannya
#yiv4898291767 #yiv4898291767 -- #yiv4898291767ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4898291767 #yiv4898291767ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4898291767 #yiv4898291767ygrp-mkp #yiv4898291767hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv4898291767 #yiv4898291767ygrp-mkp #yiv4898291767ads {margin-bottom:10px;}#yiv4898291767 #yiv4898291767ygrp-mkp .yiv4898291767ad {padding:0 0;}#yiv4898291767 #yiv4898291767ygrp-mkp .yiv4898291767ad p {margin:0;}#yiv4898291767 #yiv4898291767ygrp-mkp .yiv4898291767ad a {color:#0000ff;text-decoration:none;}#yiv4898291767 #yiv4898291767ygrp-sponsor #yiv4898291767ygrp-lc {font-family:Arial;}#yiv4898291767 #yiv4898291767ygrp-sponsor #yiv4898291767ygrp-lc #yiv4898291767hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4898291767 #yiv4898291767ygrp-sponsor #yiv4898291767ygrp-lc .yiv4898291767ad {margin-bottom:10px;padding:0 0;}#yiv4898291767 #yiv4898291767actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4898291767 #yiv4898291767activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4898291767 #yiv4898291767activity span {font-weight:700;}#yiv4898291767 #yiv4898291767activity span:first-child {text-transform:uppercase;}#yiv4898291767 #yiv4898291767activity span a {color:#5085b6;text-decoration:none;}#yiv4898291767 #yiv4898291767activity span span {color:#ff7900;}#yiv4898291767 #yiv4898291767activity span .yiv4898291767underline {text-decoration:underline;}#yiv4898291767 .yiv4898291767attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv4898291767 .yiv4898291767attach div a {text-decoration:none;}#yiv4898291767 .yiv4898291767attach img {border:none;padding-right:5px;}#yiv4898291767 .yiv4898291767attach label {display:block;margin-bottom:5px;}#yiv4898291767 .yiv4898291767attach label a {text-decoration:none;}#yiv4898291767 blockquote {margin:0 0 0 4px;}#yiv4898291767 .yiv4898291767bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv4898291767 .yiv4898291767bold a {text-decoration:none;}#yiv4898291767 dd.yiv4898291767last p a {font-family:Verdana;font-weight:700;}#yiv4898291767 dd.yiv4898291767last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4898291767 dd.yiv4898291767last p span.yiv4898291767yshortcuts {margin-right:0;}#yiv4898291767 div.yiv4898291767attach-table div div a {text-decoration:none;}#yiv4898291767 div.yiv4898291767attach-table {width:400px;}#yiv4898291767 div.yiv4898291767file-title a, #yiv4898291767 div.yiv4898291767file-title a:active, #yiv4898291767 div.yiv4898291767file-title a:hover, #yiv4898291767 div.yiv4898291767file-title a:visited {text-decoration:none;}#yiv4898291767 div.yiv4898291767photo-title a, #yiv4898291767 div.yiv4898291767photo-title a:active, #yiv4898291767 div.yiv4898291767photo-title a:hover, #yiv4898291767 div.yiv4898291767photo-title a:visited {text-decoration:none;}#yiv4898291767 div#yiv4898291767ygrp-mlmsg #yiv4898291767ygrp-msg p a span.yiv4898291767yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4898291767 .yiv4898291767green {color:#628c2a;}#yiv4898291767 .yiv4898291767MsoNormal {margin:0 0 0 0;}#yiv4898291767 o {font-size:0;}#yiv4898291767 #yiv4898291767photos div {float:left;width:72px;}#yiv4898291767 #yiv4898291767photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv4898291767 #yiv4898291767photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4898291767 #yiv4898291767reco-category {font-size:77%;}#yiv4898291767 #yiv4898291767reco-desc {font-size:77%;}#yiv4898291767 .yiv4898291767replbq {margin:4px;}#yiv4898291767 #yiv4898291767ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv4898291767 #yiv4898291767ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4898291767 #yiv4898291767ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4898291767 #yiv4898291767ygrp-mlmsg select, #yiv4898291767 input, #yiv4898291767 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv4898291767 #yiv4898291767ygrp-mlmsg pre, #yiv4898291767 code {font:115% monospace;}#yiv4898291767 #yiv4898291767ygrp-mlmsg * {line-height:1.22em;}#yiv4898291767 #yiv4898291767ygrp-mlmsg #yiv4898291767logo {padding-bottom:10px;}#yiv4898291767 #yiv4898291767ygrp-msg p a {font-family:Verdana;}#yiv4898291767 #yiv4898291767ygrp-msg p#yiv4898291767attach-count span {color:#1E66AE;font-weight:700;}#yiv4898291767 #yiv4898291767ygrp-reco #yiv4898291767reco-head {color:#ff7900;font-weight:700;}#yiv4898291767 #yiv4898291767ygrp-reco {margin-bottom:20px;padding:0px;}#yiv4898291767 #yiv4898291767ygrp-sponsor #yiv4898291767ov li a {font-size:130%;text-decoration:none;}#yiv4898291767 #yiv4898291767ygrp-sponsor #yiv4898291767ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv4898291767 #yiv4898291767ygrp-sponsor #yiv4898291767ov ul {margin:0;padding:0 0 0 8px;}#yiv4898291767 #yiv4898291767ygrp-text {font-family:Georgia;}#yiv4898291767 #yiv4898291767ygrp-text p {margin:0 0 1em 0;}#yiv4898291767 #yiv4898291767ygrp-text tt {font-size:120%;}#yiv4898291767 #yiv4898291767ygrp-vital ul li:last-child {border-right:none !important;}#yiv4898291767
mungkin seperti file terlampir..
salam
lb
Pada Jumat, 10 Juli 2015 9:16, "pokja konsultan konsultan_pokja@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Kalau mau menghapusnya dengan formula gimana Misal : SRINING KUSTIYAH (3)berarti nama tersebut ada 3 data yang sama, tapi hanya 1 nama yang di tulis.
Pada Rabu, 8 Juli 2015 18:18, "'Paulroth' iq_bal76id@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Dear konsultan pokja,Bisa gunakan menu remove duplicate.Block seluruh data, klik ribbon data, dan pilih icon remove duplicate.> klik ok /yes.Done. ThanksRegardMuhammad Iqbal From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: Wednesday, July 08, 2015 2:17 PM
To: belajar-excel@yahoogroups.com
Subject: [belajar-excel] Menghapus data yang sama/ double secara otomatis [1 Attachment] Saya ingin menghapus data yang sama / double secara otomatis. Gimana caranya ya. Trima kasih atas bantuannya
#yiv4898291767 #yiv4898291767 -- #yiv4898291767ygrp-
Thu Jul 9, 2015 10:09 pm (PDT) . Posted by:
"hendrik karnadi" hendrikkarnadi
Bagus pak formulannya.Bagaimana kalau diambil langsung dari sumbernya, yaitu Range("B3:D12") ?
Salam,HK
----- Forwarded Message -----
From: "Lazuardi Biru lazuardi_biru84@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
To: "belajar-excel@yahoogroups.com" <belajar-excel@yahoogroups.com>
Sent: Friday, 10 July 2015, 11:54
Subject: Bls: [belajar-excel] Menghapus data yang sama/ double secara otomatis [1 Attachment]
dhdear pokja
mungkin seperti file terlampir..
salam
lb
Pada Jumat, 10 Juli 2015 9:16, "pokja konsultan konsultan_pokja@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Kalau mau menghapusnya dengan formula gimana Misal : SRINING KUSTIYAH (3)berarti nama tersebut ada 3 data yang sama, tapi hanya 1 nama yang di tulis.
Pada Rabu, 8 Juli 2015 18:18, "'Paulroth' iq_bal76id@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Dear konsultan pokja,Bisa gunakan menu remove duplicate.Block seluruh data, klik ribbon data, dan pilih icon remove duplicate.> klik ok /yes.Done. ThanksRegardMuhammad Iqbal From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: Wednesday, July 08, 2015 2:17 PM
To: belajar-excel@yahoogroups.com
Subject: [belajar-excel] Menghapus data yang sama/ double secara otomatis [1 Attachment] Saya ingin menghapus data yang sama / double secara otomatis. Gimana caranya ya. Trima kasih atas bantuannya
#yiv9429721367 #yiv9429721367 -- #yiv9429721367ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9429721367 #yiv9429721367ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9429721367 #yiv9429721367ygrp-mkp #yiv9429721367hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv9429721367 #yiv9429721367ygrp-mkp #yiv9429721367ads {margin-bottom:10px;}#yiv9429721367 #yiv9429721367ygrp-mkp .yiv9429721367ad {padding:0 0;}#yiv9429721367 #yiv9429721367ygrp-mkp .yiv9429721367ad p {margin:0;}#yiv9429721367 #yiv9429721367ygrp-mkp .yiv9429721367ad a {color:#0000ff;text-decoration:none;}#yiv9429721367 #yiv9429721367ygrp-sponsor #yiv9429721367ygrp-lc {font-family:Arial;}#yiv9429721367 #yiv9429721367ygrp-sponsor #yiv9429721367ygrp-lc #yiv9429721367hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9429721367 #yiv9429721367ygrp-sponsor #yiv9429721367ygrp-lc .yiv9429721367ad {margin-bottom:10px;padding:0 0;}#yiv9429721367 #yiv9429721367actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9429721367 #yiv9429721367activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9429721367 #yiv9429721367activity span {font-weight:700;}#yiv9429721367 #yiv9429721367activity span:first-child {text-transform:uppercase;}#yiv9429721367 #yiv9429721367activity span a {color:#5085b6;text-decoration:none;}#yiv9429721367 #yiv9429721367activity span span {color:#ff7900;}#yiv9429721367 #yiv9429721367activity span .yiv9429721367underline {text-decoration:underline;}#yiv9429721367 .yiv9429721367attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv9429721367 .yiv9429721367attach div a {text-decoration:none;}#yiv9429721367 .yiv9429721367attach img {border:none;padding-right:5px;}#yiv9429721367 .yiv9429721367attach label {display:block;margin-bottom:5px;}#yiv9429721367 .yiv9429721367attach label a {text-decoration:none;}#yiv9429721367 blockquote {margin:0 0 0 4px;}#yiv9429721367 .yiv9429721367bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv9429721367 .yiv9429721367bold a {text-decoration:none;}#yiv9429721367 dd.yiv9429721367last p a {font-family:Verdana;font-weight:700;}#yiv9429721367 dd.yiv9429721367last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9429721367 dd.yiv9429721367last p span.yiv9429721367yshortcuts {margin-right:0;}#yiv9429721367 div.yiv9429721367attach-table div div a {text-decoration:none;}#yiv9429721367 div.yiv9429721367attach-table {width:400px;}#yiv9429721367 div.yiv9429721367file-title a, #yiv9429721367 div.yiv9429721367file-title a:active, #yiv9429721367 div.yiv9429721367file-title a:hover, #yiv9429721367 div.yiv9429721367file-title a:visited {text-decoration:none;}#yiv9429721367 div.yiv9429721367photo-title a, #yiv9429721367 div.yiv9429721367photo-title a:active, #yiv9429721367 div.yiv9429721367photo-title a:hover, #yiv9429721367 div.yiv9429721367photo-title a:visited {text-decoration:none;}#yiv9429721367 div#yiv9429721367ygrp-mlmsg #yiv9429721367ygrp-msg p a span.yiv9429721367yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9429721367 .yiv9429721367green {color:#628c2a;}#yiv9429721367 .yiv9429721367MsoNormal {margin:0 0 0 0;}#yiv9429721367 o {font-size:0;}#yiv9429721367 #yiv9429721367photos div {float:left;width:72px;}#yiv9429721367 #yiv9429721367photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv9429721367 #yiv9429721367photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9429721367 #yiv9429721367reco-category {font-size:77%;}#yiv9429721367 #yiv9429721367reco-desc {font-size:77%;}#yiv9429721367 .yiv9429721367replbq {margin:4px;}#yiv9429721367 #yiv9429721367ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv9429721367 #yiv9429721367ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9429721367 #yiv9429721367ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9429721367 #yiv9429721367ygrp-mlmsg select, #yiv9429721367 input, #yiv9429721367 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv9429721367 #yiv9429721367ygrp-mlmsg pre, #yiv9429721367 code {font:115% monospace;}#yiv9429721367 #yiv9429721367ygrp-mlmsg * {line-height:1.22em;}#yiv9429721367 #yiv9429721367ygrp-mlmsg #yiv9429721367logo {padding-bottom:10px;}#yiv9429721367 #yiv9429721367ygrp-msg p a {font-family:Verdana;}#yiv9429721367 #yiv9429721367ygrp-msg p#yiv9429721367attach-count span {color:#1E66AE;font-weight:700;}#yiv9429721367 #yiv9429721367ygrp-reco #yiv9429721367reco-head {color:#ff7900;font-weight:700;}#yiv9429721367 #yiv9429721367ygrp-reco {margin-bottom:20px;padding:0px;}#yiv9429721367 #yiv9429721367ygrp-sponsor #yiv9429721367ov li a {font-size:130%;text-decoration:none;}#yiv9429721367 #yiv9429721367ygrp-sponsor #yiv9429721367ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv9429721367 #yiv9429721367ygrp-sponsor #yiv9429721367ov ul {margin:0;padding:0 0 0 8px;}#yiv9429721367 #yiv9429721367ygrp-text {font-family:Georgia;}#yiv9429721367 #yiv9429721367ygrp-text p {margin:0 0 1em 0;}#yiv9429721367 #yiv9429721367ygrp-text tt {font-size:120%;}#yiv9429721367 #yiv9429721367ygrp-vital ul li:last-child {border-right:none !important;}#yiv9429721367
Salam,HK
----- Forwarded Message -----
From: "Lazuardi Biru lazuardi_biru84@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
To: "belajar-excel@yahoogroups.com" <belajar-excel@yahoogroups.com>
Sent: Friday, 10 July 2015, 11:54
Subject: Bls: [belajar-excel] Menghapus data yang sama/ double secara otomatis [1 Attachment]
dhdear pokja
mungkin seperti file terlampir..
salam
lb
Pada Jumat, 10 Juli 2015 9:16, "pokja konsultan konsultan_pokja@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Kalau mau menghapusnya dengan formula gimana Misal : SRINING KUSTIYAH (3)berarti nama tersebut ada 3 data yang sama, tapi hanya 1 nama yang di tulis.
Pada Rabu, 8 Juli 2015 18:18, "'Paulroth' iq_bal76id@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Dear konsultan pokja,Bisa gunakan menu remove duplicate.Block seluruh data, klik ribbon data, dan pilih icon remove duplicate.> klik ok /yes.Done. ThanksRegardMuhammad Iqbal From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: Wednesday, July 08, 2015 2:17 PM
To: belajar-excel@yahoogroups.com
Subject: [belajar-excel] Menghapus data yang sama/ double secara otomatis [1 Attachment] Saya ingin menghapus data yang sama / double secara otomatis. Gimana caranya ya. Trima kasih atas bantuannya
#yiv9429721367 #yiv9429721367 -- #yiv9429721367ygrp-
Fri Jul 10, 2015 12:33 am (PDT) . Posted by:
"Lazuardi Biru" lazuardi_biru84
dh..pak hakformulanya copas di milis pak.. hhehe
coba pakai kolom bantu pak ya..
salamlb
Pada Jumat, 10 Juli 2015 12:09, "hendrik karnadi hendrikkarnadi@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Bagus pak formulannya.Bagaimana kalau diambil langsung dari sumbernya, yaitu Range("B3:D12") ?
Salam,HK
----- Forwarded Message -----
From: "Lazuardi Biru lazuardi_biru84@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
To: "belajar-excel@yahoogroups.com" <belajar-excel@yahoogroups.com>
Sent: Friday, 10 July 2015, 11:54
Subject: Bls: [belajar-excel] Menghapus data yang sama/ double secara otomatis [1 Attachment]
dhdear pokja
mungkin seperti file terlampir..
salam
lb
Pada Jumat, 10 Juli 2015 9:16, "pokja konsultan konsultan_pokja@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Kalau mau menghapusnya dengan formula gimana Misal : SRINING KUSTIYAH (3)berarti nama tersebut ada 3 data yang sama, tapi hanya 1 nama yang di tulis.
Pada Rabu, 8 Juli 2015 18:18, "'Paulroth' iq_bal76id@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Dear konsultan pokja,Bisa gunakan menu remove duplicate.Block seluruh data, klik ribbon data, dan pilih icon remove duplicate.> klik ok /yes.Done. ThanksRegardMuhammad Iqbal From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: Wednesday, July 08, 2015 2:17 PM
To: belajar-excel@yahoogroups.com
Subject: [belajar-excel] Menghapus data yang sama/ double secara otomatis [1 Attachment] Saya ingin menghapus data yang sama / double secara otomatis. Gimana caranya ya. Trima kasih atas bantuannya
#yiv8743192042 #yiv8743192042 -- #yiv8743192042ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8743192042 #yiv8743192042ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8743192042 #yiv8743192042ygrp-mkp #yiv8743192042hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8743192042 #yiv8743192042ygrp-mkp #yiv8743192042ads {margin-bottom:10px;}#yiv8743192042 #yiv8743192042ygrp-mkp .yiv8743192042ad {padding:0 0;}#yiv8743192042 #yiv8743192042ygrp-mkp .yiv8743192042ad p {margin:0;}#yiv8743192042 #yiv8743192042ygrp-mkp .yiv8743192042ad a {color:#0000ff;text-decoration:none;}#yiv8743192042 #yiv8743192042ygrp-sponsor #yiv8743192042ygrp-lc {font-family:Arial;}#yiv8743192042 #yiv8743192042ygrp-sponsor #yiv8743192042ygrp-lc #yiv8743192042hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8743192042 #yiv8743192042ygrp-sponsor #yiv8743192042ygrp-lc .yiv8743192042ad {margin-bottom:10px;padding:0 0;}#yiv8743192042 #yiv8743192042actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8743192042 #yiv8743192042activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8743192042 #yiv8743192042activity span {font-weight:700;}#yiv8743192042 #yiv8743192042activity span:first-child {text-transform:uppercase;}#yiv8743192042 #yiv8743192042activity span a {color:#5085b6;text-decoration:none;}#yiv8743192042 #yiv8743192042activity span span {color:#ff7900;}#yiv8743192042 #yiv8743192042activity span .yiv8743192042underline {text-decoration:underline;}#yiv8743192042 .yiv8743192042attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8743192042 .yiv8743192042attach div a {text-decoration:none;}#yiv8743192042 .yiv8743192042attach img {border:none;padding-right:5px;}#yiv8743192042 .yiv8743192042attach label {display:block;margin-bottom:5px;}#yiv8743192042 .yiv8743192042attach label a {text-decoration:none;}#yiv8743192042 blockquote {margin:0 0 0 4px;}#yiv8743192042 .yiv8743192042bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8743192042 .yiv8743192042bold a {text-decoration:none;}#yiv8743192042 dd.yiv8743192042last p a {font-family:Verdana;font-weight:700;}#yiv8743192042 dd.yiv8743192042last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8743192042 dd.yiv8743192042last p span.yiv8743192042yshortcuts {margin-right:0;}#yiv8743192042 div.yiv8743192042attach-table div div a {text-decoration:none;}#yiv8743192042 div.yiv8743192042attach-table {width:400px;}#yiv8743192042 div.yiv8743192042file-title a, #yiv8743192042 div.yiv8743192042file-title a:active, #yiv8743192042 div.yiv8743192042file-title a:hover, #yiv8743192042 div.yiv8743192042file-title a:visited {text-decoration:none;}#yiv8743192042 div.yiv8743192042photo-title a, #yiv8743192042 div.yiv8743192042photo-title a:active, #yiv8743192042 div.yiv8743192042photo-title a:hover, #yiv8743192042 div.yiv8743192042photo-title a:visited {text-decoration:none;}#yiv8743192042 div#yiv8743192042ygrp-mlmsg #yiv8743192042ygrp-msg p a span.yiv8743192042yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8743192042 .yiv8743192042green {color:#628c2a;}#yiv8743192042 .yiv8743192042MsoNormal {margin:0 0 0 0;}#yiv8743192042 o {font-size:0;}#yiv8743192042 #yiv8743192042photos div {float:left;width:72px;}#yiv8743192042 #yiv8743192042photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv8743192042 #yiv8743192042photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8743192042 #yiv8743192042reco-category {font-size:77%;}#yiv8743192042 #yiv8743192042reco-desc {font-size:77%;}#yiv8743192042 .yiv8743192042replbq {margin:4px;}#yiv8743192042 #yiv8743192042ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8743192042 #yiv8743192042ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8743192042 #yiv8743192042ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8743192042 #yiv8743192042ygrp-mlmsg select, #yiv8743192042 input, #yiv8743192042 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8743192042 #yiv8743192042ygrp-mlmsg pre, #yiv8743192042 code {font:115% monospace;}#yiv8743192042 #yiv8743192042ygrp-mlmsg * {line-height:1.22em;}#yiv8743192042 #yiv8743192042ygrp-mlmsg #yiv8743192042logo {padding-bottom:10px;}#yiv8743192042 #yiv8743192042ygrp-msg p a {font-family:Verdana;}#yiv8743192042 #yiv8743192042ygrp-msg p#yiv8743192042attach-count span {color:#1E66AE;font-weight:700;}#yiv8743192042 #yiv8743192042ygrp-reco #yiv8743192042reco-head {color:#ff7900;font-weight:700;}#yiv8743192042 #yiv8743192042ygrp-reco {margin-bottom:20px;padding:0px;}#yiv8743192042 #yiv8743192042ygrp-sponsor #yiv8743192042ov li a {font-size:130%;text-decoration:none;}#yiv8743192042 #yiv8743192042ygrp-sponsor #yiv8743192042ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv8743192042 #yiv8743192042ygrp-sponsor #yiv8743192042ov ul {margin:0;padding:0 0 0 8px;}#yiv8743192042 #yiv8743192042ygrp-text {font-family:Georgia;}#yiv8743192042 #yiv8743192042ygrp-text p {margin:0 0 1em 0;}#yiv8743192042 #yiv8743192042ygrp-text tt {font-size:120%;}#yiv8743192042 #yiv8743192042ygrp-vital ul li:last-child {border-right:none !important;}#yiv8743192042
coba pakai kolom bantu pak ya..
salamlb
Pada Jumat, 10 Juli 2015 12:09, "hendrik karnadi hendrikkarnadi@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Bagus pak formulannya.Bagaimana kalau diambil langsung dari sumbernya, yaitu Range("B3:D12") ?
Salam,HK
----- Forwarded Message -----
From: "Lazuardi Biru lazuardi_biru84@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
To: "belajar-excel@yahoogroups.com" <belajar-excel@yahoogroups.com>
Sent: Friday, 10 July 2015, 11:54
Subject: Bls: [belajar-excel] Menghapus data yang sama/ double secara otomatis [1 Attachment]
dhdear pokja
mungkin seperti file terlampir..
salam
lb
Pada Jumat, 10 Juli 2015 9:16, "pokja konsultan konsultan_pokja@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Kalau mau menghapusnya dengan formula gimana Misal : SRINING KUSTIYAH (3)berarti nama tersebut ada 3 data yang sama, tapi hanya 1 nama yang di tulis.
Pada Rabu, 8 Juli 2015 18:18, "'Paulroth' iq_bal76id@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Dear konsultan pokja,Bisa gunakan menu remove duplicate.Block seluruh data, klik ribbon data, dan pilih icon remove duplicate.> klik ok /yes.Done. ThanksRegardMuhammad Iqbal From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: Wednesday, July 08, 2015 2:17 PM
To: belajar-excel@yahoogroups.com
Subject: [belajar-excel] Menghapus data yang sama/ double secara otomatis [1 Attachment] Saya ingin menghapus data yang sama / double secara otomatis. Gimana caranya ya. Trima kasih atas bantuannya
#yiv8743192042 #yiv8743192042 -- #yiv8743192042ygrp-
Fri Jul 10, 2015 1:47 am (PDT) . Posted by:
"hendrik karnadi" hendrikkarnadi
Terima kasih Pak.
Salam,HK
From: "Lazuardi Biru lazuardi_biru84@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
To: "belajar-excel@yahoogroups.com" <belajar-excel@yahoogroups.com>
Sent: Friday, 10 July 2015, 14:33
Subject: Bls: Bls: [belajar-excel] Menghapus data yang sama/ double secara otomatis [1 Attachment]
dh..pak hakformulanya copas di milis pak.. hhehe
coba pakai kolom bantu pak ya..
salamlb
Pada Jumat, 10 Juli 2015 12:09, "hendrik karnadi hendrikkarnadi@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Bagus pak formulannya.Bagaimana kalau diambil langsung dari sumbernya, yaitu Range("B3:D12") ?
Salam,HK
----- Forwarded Message -----
From: "Lazuardi Biru lazuardi_biru84@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
To: "belajar-excel@yahoogroups.com" <belajar-excel@yahoogroups.com>
Sent: Friday, 10 July 2015, 11:54
Subject: Bls: [belajar-excel] Menghapus data yang sama/ double secara otomatis [1 Attachment]
dhdear pokja
mungkin seperti file terlampir..
salam
lb
Pada Jumat, 10 Juli 2015 9:16, "pokja konsultan konsultan_pokja@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Kalau mau menghapusnya dengan formula gimana Misal : SRINING KUSTIYAH (3)berarti nama tersebut ada 3 data yang sama, tapi hanya 1 nama yang di tulis.
Pada Rabu, 8 Juli 2015 18:18, "'Paulroth' iq_bal76id@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Dear konsultan pokja,Bisa gunakan menu remove duplicate.Block seluruh data, klik ribbon data, dan pilih icon remove duplicate.> klik ok /yes.Done. ThanksRegardMuhammad Iqbal From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: Wednesday, July 08, 2015 2:17 PM
To: belajar-excel@yahoogroups.com
Subject: [belajar-excel] Menghapus data yang sama/ double secara otomatis [1 Attachment] Saya ingin menghapus data yang sama / double secara otomatis. Gimana caranya ya. Trima kasih atas bantuannya
#yiv7259911606 #yiv7259911606 -- #yiv7259911606ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7259911606 #yiv7259911606ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7259911606 #yiv7259911606ygrp-mkp #yiv7259911606hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7259911606 #yiv7259911606ygrp-mkp #yiv7259911606ads {margin-bottom:10px;}#yiv7259911606 #yiv7259911606ygrp-mkp .yiv7259911606ad {padding:0 0;}#yiv7259911606 #yiv7259911606ygrp-mkp .yiv7259911606ad p {margin:0;}#yiv7259911606 #yiv7259911606ygrp-mkp .yiv7259911606ad a {color:#0000ff;text-decoration:none;}#yiv7259911606 #yiv7259911606ygrp-sponsor #yiv7259911606ygrp-lc {font-family:Arial;}#yiv7259911606 #yiv7259911606ygrp-sponsor #yiv7259911606ygrp-lc #yiv7259911606hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7259911606 #yiv7259911606ygrp-sponsor #yiv7259911606ygrp-lc .yiv7259911606ad {margin-bottom:10px;padding:0 0;}#yiv7259911606 #yiv7259911606actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7259911606 #yiv7259911606activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7259911606 #yiv7259911606activity span {font-weight:700;}#yiv7259911606 #yiv7259911606activity span:first-child {text-transform:uppercase;}#yiv7259911606 #yiv7259911606activity span a {color:#5085b6;text-decoration:none;}#yiv7259911606 #yiv7259911606activity span span {color:#ff7900;}#yiv7259911606 #yiv7259911606activity span .yiv7259911606underline {text-decoration:underline;}#yiv7259911606 .yiv7259911606attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7259911606 .yiv7259911606attach div a {text-decoration:none;}#yiv7259911606 .yiv7259911606attach img {border:none;padding-right:5px;}#yiv7259911606 .yiv7259911606attach label {display:block;margin-bottom:5px;}#yiv7259911606 .yiv7259911606attach label a {text-decoration:none;}#yiv7259911606 blockquote {margin:0 0 0 4px;}#yiv7259911606 .yiv7259911606bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7259911606 .yiv7259911606bold a {text-decoration:none;}#yiv7259911606 dd.yiv7259911606last p a {font-family:Verdana;font-weight:700;}#yiv7259911606 dd.yiv7259911606last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7259911606 dd.yiv7259911606last p span.yiv7259911606yshortcuts {margin-right:0;}#yiv7259911606 div.yiv7259911606attach-table div div a {text-decoration:none;}#yiv7259911606 div.yiv7259911606attach-table {width:400px;}#yiv7259911606 div.yiv7259911606file-title a, #yiv7259911606 div.yiv7259911606file-title a:active, #yiv7259911606 div.yiv7259911606file-title a:hover, #yiv7259911606 div.yiv7259911606file-title a:visited {text-decoration:none;}#yiv7259911606 div.yiv7259911606photo-title a, #yiv7259911606 div.yiv7259911606photo-title a:active, #yiv7259911606 div.yiv7259911606photo-title a:hover, #yiv7259911606 div.yiv7259911606photo-title a:visited {text-decoration:none;}#yiv7259911606 div#yiv7259911606ygrp-mlmsg #yiv7259911606ygrp-msg p a span.yiv7259911606yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7259911606 .yiv7259911606green {color:#628c2a;}#yiv7259911606 .yiv7259911606MsoNormal {margin:0 0 0 0;}#yiv7259911606 o {font-size:0;}#yiv7259911606 #yiv7259911606photos div {float:left;width:72px;}#yiv7259911606 #yiv7259911606photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv7259911606 #yiv7259911606photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7259911606 #yiv7259911606reco-category {font-size:77%;}#yiv7259911606 #yiv7259911606reco-desc {font-size:77%;}#yiv7259911606 .yiv7259911606replbq {margin:4px;}#yiv7259911606 #yiv7259911606ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv7259911606 #yiv7259911606ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7259911606 #yiv7259911606ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7259911606 #yiv7259911606ygrp-mlmsg select, #yiv7259911606 input, #yiv7259911606 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv7259911606 #yiv7259911606ygrp-mlmsg pre, #yiv7259911606 code {font:115% monospace;}#yiv7259911606 #yiv7259911606ygrp-mlmsg * {line-height:1.22em;}#yiv7259911606 #yiv7259911606ygrp-mlmsg #yiv7259911606logo {padding-bottom:10px;}#yiv7259911606 #yiv7259911606ygrp-msg p a {font-family:Verdana;}#yiv7259911606 #yiv7259911606ygrp-msg p#yiv7259911606attach-count span {color:#1E66AE;font-weight:700;}#yiv7259911606 #yiv7259911606ygrp-reco #yiv7259911606reco-head {color:#ff7900;font-weight:700;}#yiv7259911606 #yiv7259911606ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7259911606 #yiv7259911606ygrp-sponsor #yiv7259911606ov li a {font-size:130%;text-decoration:none;}#yiv7259911606 #yiv7259911606ygrp-sponsor #yiv7259911606ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7259911606 #yiv7259911606ygrp-sponsor #yiv7259911606ov ul {margin:0;padding:0 0 0 8px;}#yiv7259911606 #yiv7259911606ygrp-text {font-family:Georgia;}#yiv7259911606 #yiv7259911606ygrp-text p {margin:0 0 1em 0;}#yiv7259911606 #yiv7259911606ygrp-text tt {font-size:120%;}#yiv7259911606 #yiv7259911606ygrp-vital ul li:last-child {border-right:none !important;}#yiv7259911606
Salam,HK
From: "Lazuardi Biru lazuardi_biru84@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
To: "belajar-excel@yahoogroups.com" <belajar-excel@yahoogroups.com>
Sent: Friday, 10 July 2015, 14:33
Subject: Bls: Bls: [belajar-excel] Menghapus data yang sama/ double secara otomatis [1 Attachment]
dh..pak hakformulanya copas di milis pak.. hhehe
coba pakai kolom bantu pak ya..
salamlb
Pada Jumat, 10 Juli 2015 12:09, "hendrik karnadi hendrikkarnadi@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Bagus pak formulannya.Bagaimana kalau diambil langsung dari sumbernya, yaitu Range("B3:D12") ?
Salam,HK
----- Forwarded Message -----
From: "Lazuardi Biru lazuardi_biru84@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
To: "belajar-excel@yahoogroups.com" <belajar-excel@yahoogroups.com>
Sent: Friday, 10 July 2015, 11:54
Subject: Bls: [belajar-excel] Menghapus data yang sama/ double secara otomatis [1 Attachment]
dhdear pokja
mungkin seperti file terlampir..
salam
lb
Pada Jumat, 10 Juli 2015 9:16, "pokja konsultan konsultan_pokja@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Kalau mau menghapusnya dengan formula gimana Misal : SRINING KUSTIYAH (3)berarti nama tersebut ada 3 data yang sama, tapi hanya 1 nama yang di tulis.
Pada Rabu, 8 Juli 2015 18:18, "'Paulroth' iq_bal76id@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Dear konsultan pokja,Bisa gunakan menu remove duplicate.Block seluruh data, klik ribbon data, dan pilih icon remove duplicate.> klik ok /yes.Done. ThanksRegardMuhammad Iqbal From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: Wednesday, July 08, 2015 2:17 PM
To: belajar-excel@yahoogroups.com
Subject: [belajar-excel] Menghapus data yang sama/ double secara otomatis [1 Attachment] Saya ingin menghapus data yang sama / double secara otomatis. Gimana caranya ya. Trima kasih atas bantuannya
#yiv7259911606 #yiv7259911606 -- #yiv7259911606ygrp-
Fri Jul 10, 2015 12:58 am (PDT) . Posted by:
"Dede"
Daer BeExceller,
Bisakah data dari dua sheet dijadikan sebuah Pivot?
Data dibagi karena jumlah baris 1.272.785 bisa gak yah?
Salam,
DD
Bisakah data dari dua sheet dijadikan sebuah Pivot?
Data dibagi karena jumlah baris 1.272.785 bisa gak yah?
Salam,
DD
============================================================
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
---------------------------------------------------------------------
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
---------------------------------------------------------------------
Tidak ada komentar:
Posting Komentar