Membuat Daftar Data Dalam Kolom Excel

Kalau anda mempunyai tabel dengan ribuan data dan sebagian besar merupakan isinya sama (data duplikasi), bagaimana caranya mengenerate daftar dengan isi yang unik (masing-masing hanya satu data berlainan yang tampil dalam satu kolom ?

Ada dua cara untuk mendapatkannya yaitu: pertama dengan menggunakan fungsi Data | Autofilter, kemudian klik drop-down list untuk kolom yang diperlukan. Dengan melakukan perintah di atas anda akan mendapatkan daftar data unik di layar. Kalau dengan cara ini anda cukup puas, maka permasalahan sudah selesai.

Cara yang kedua adalah jika anda perlu memiliki daftar yang unik yang dapat dicopy dan paste kan ke range (kolom) lainnya. Untuik menghasilkan daftar yang unik tersebut, maka anda perlu menggunakan perintah Data | Filter | Advanced Filter. Contoh di bawah ini adalah cara untuk mendapatkan daftar tersebut di atas. Kita akan menggunakan kolom B pada Gambar 1.

Windows 81 Professional Key Paypal
windows office 10 serial key
buy genuine windows 7 ultimate sp1 key
windows 7 professional 32 bit product keygen
windows 7 home key serial
windows 8 pro product key original
exchange server 2007 mit service pack 2 key
windows 81 enterprise activation key
windows 8 professional key product
win 10 enterprise activation key
product key for windows 7
buy windows office 2010 key
windows 7 home premium sp1 64 bit cd key
windows 8 standard key
windows 7 enterprise hp oem key
windows 10 enterprise key sale
microsoft windows 7 home premium license key only
windows 8 pro cd key 64 bit
office 2010 64 bit product key
exchange server 2007 mit service pack 3 key
microsoft office professional plus 2010 key oem
windows 7 home premium key price
office 2010 key sale
microsoft office standard 2010 key oem
windows 81 license key issue
windows 7 key online activation
windows 81 enterprise key online
windows small business server 2008 premium key
windows 7 professional oem key asus
windows 7 home premium key for sale
windows 8 standard key cheap
windows 10 enterprise 64 bit cd key
product key for windows 81 enterprise edition
download windows 10 serial number keygen crack
windows 8 professional key paypal
buy windows 7 ultimate 64 bit product key online
key microsoft office professional plus 2013 x86 volume license
win10 professional key buy
buy windows server 2008 key online
windows home server 2011 license key
windows 81 pro key oem
windows 7 home keygen download
cheap windows 8 enterprise key
win 10 enterprise serial key
windows server 2012 evaluation license key
buy windows 7 home basic product key online
purchase windows 8 standard key
windows server 2008 32 bit trial product key
windows server 2008 key cheap
windows 81 professional key paypal
buy windows 7 professional key
buy windows 81 standard key online
cheap windows server 2012 key
windows 7 ultimate activation code 2012
windows 8 standard key code
key windows 8 professional
discount adobe cs6 master collection key
windows 8 professional genuine serial key
windows 7 professional sp1 activation key
product key for windows 7 enterprise 32 bit
windows 7 home premium product key online kaufen
windows 8 professional serial key download
windows 7 ultimate 64 bit product key buy
windows 7 pro key buy
buy windows 7 ultimate license key online
microsoft windows 7 home premium genuine key
buy windows 7 professional 64 bit product key online
windows 7 professional key 2015
windows 8 pro key shop
windows 81 standard key
windows 81 standard genuine key
windows 7 oem key lenovo
windows 8 professional genuine product key
cheap windows 7 ultimate key
genuine windows 10 free upgrade
windows 8 pro key oem
office 2010 key cheap
windows server 2012 key shop
windows 7 home premium license key
windows 7 ultimate key cheap
windows 8 standard cd key
purchase windows 81 standard key
cheap windows 7 enterprise key
Windows 8 Pro Product Key For Online Activation
windows 7 key finder
product key for windows 10
buy genuine windows 8 enterprise key
office 2010 genuine keygen
microsoft office 2010 product key paypal
buy windows 7 cd key online
windows 7 professional acer oem key
windows 7 64 bit cd key finder
office 2010 license key not working
windows 81 pro key serial
adobe acrobat xi professional key
windows 7 enterprise license key
office professional plus 2013 genuine key
windows 7 home premium sp1 genuine key
windows server 2008 r2 datacenter kms key
office 2010 32 bit product key
windows 10 key shop
win10 cd key
key windows 81 pro wmc
windows 8 enterprise x64 cd key
office professional plus 2013 key
buy office professional plus 2013 key online
windows 81 enterprise key cheap
windows server 2008 codename longhorn product key
windows 7 home premium 32 bit product key activation
win 10 enterprise license key
adobe cs6 master collection key buy
windows 81 product key online kaufen
windows 7 enterprise key code
windows 7 home key code
windows server 2008 license key change
windows server 8 standard key
windows 7 key code checker
windows 7 professional 64 bit product key buy
windows 8 ultimate 64 bit cd key
windows 81 pro rtm serial key
windows 8 pro product key for online activation
office professional plus 2013 preview activation key
product key for windows server 2012 r2
windows 7 home premium key on sale
windows server 2012 change cd key
office 2010 key buy online
win 10 enterprise 32 bit cd key
windows 10 activation key
windows 7 home 32 bit cd key
key office 2010 standard
buy win10 enterprise key online
key windows 81 pro with media center
windows 8 enterprise edition serial key
windows 81 cd key not working
buy genuine windows 10 professional key
windows 81 enterprise key mak
windows 7 professional key 64 bit
buy genuine windows 81 professional key
genuine windows 7 ultimate key finderrar
office 2010 key code change
adobe cs6 master collection license key
windows 7 professional upgrade key purchase
microsoft office professional plus 2010 key shop
windows 7 ultimate sp1 activation key
purchase windows 7 enterprise product key
product key for windows 7 home premium 64 bit genuine
chave key windows 7 ultimate 32 bits original
purchase windows 7 ultimate upgrade key
purchase windows 8 professional product key
windows 8 standard generic key
buy windows 81 oem key online
windows 10 key cheap sale
windows 7 home premium 64 bit product keygen
windows 7 activation key for sale
windows 8 enterprise key buy
find windows 81 product key oem
cheap windows 7 home premium key
ms office 2010 product key sale
genuine windows 81 product key
windows 8 serial key download
office 2013 pro plus 64 bit product key
cheap genuine windows 10 professional activation key sale
windows 81 product key buy
product key for windows 8 professional x86
windows 7 pro key cheap
microsoft project professional 2013 64 bit cd key
windows 7 home key ultimate
windows 8 pro 32 bit product key list
microsoft office professional plus 2010 serial key
key windows 7 ultimate 64 bits
windows 81 enterprise genuine product key
windows 8 standard key buy
key office 2010
discount windows 81 standard key
key windows 8 professional 32 bit
key windows 7 ultimate sp1
windows 7 key oem
windows 7 ultimate keygen download
product key for ms office professional plus 2013
purchase adobe cs6 master collection key
office 2010 key online
windows 7 enterprise product key serial
microsoft office professional plus 2013 rtm serial key
windows 7 home premium activation key oem
office 2010 product key
windows 7 ultimate 32 bit product key build 7600
Win 10 Key Original
windows server 2012 essentials beta key
buy windows 8 pro upgrade key
windows 7 ultimate serial key 64 bit
windows small business server 2011 standard key
windows server 2008 activation key management service is not enabled
discount windows 7 professional key
windows server 2008 key serial
windows 81 cd key
windows 81 key online kaufen
win 10 professional key oem
genuine product key for windows 10
purchase windows server 2008 standard product key
windows 7 ultimate key paypal
cheap windows 7 ultimate product key
windows server 2012 serial key trial
buy windows 7 home premium product key online
adobe cs6 master collection key serial
purchase windows 7 professional sp1 key
product key for windows server 2012 r2 evaluation
microsoft office standard 2013 64 bit cd key
cheap windows 7 key
buy windows server 2012 essentials key
product key for windows 7 home premium sp1
windows server 2008 r2 standard edition 32 bit product key
top 10 windows shortcut keys
windows 7 ultimate 32 bit product key 2013
windows 7 enterprise product key purchase
buy win10 professional key online
windows 7 cd key buy online
win10 key shop
windows small business server 2008 standard key
office professional plus 2013 key sale
windows 7 professional 64 bit key buy
windows server 2012 r2 essentials keygen
buy genuine windows server 2012 key
buy windows 81 standard key
windows 8 enterprise key download
buy windows 7 ultimate upgrade key
windows 10 license key
adobe acrobat xi professional key sale
window 7 serial key download
win 10 professional activation key
key windows 8 enterprise evaluation
buy windows 7 key from microsoft
buy cheap office 2010 key
microsoft office standard 2010 key shop
product key for windows 8 professional 64 bit
keygen windows 7 enterprise 32 bit product key
buy microsoft office professional plus 2010 product key online
buy genuine windows 10 product key
win10 64 bit cd key
buy genuine windows 7 key
win10 enterprise key paypal
windows 8 professional key code
microsoft office standard 2010 activation key
windows 81 pro preview 32bit product key
win 10 key original
windows 10 activation key enterprise
windows server 2012 product key activation
key windows 8 professional download
purchase windows 7 home basic product key
windows 81 product key serial number
windows 81 pro key 2014
windows 7 enterprise key online kaufen
windows server 2012 keygen
buy windows 7 keys in bulk
valid product key for windows 81 enterprise
windows 8 server 2012 cd key
genuine windows 8 pro key
buy windows 7 professional 64 bit key
windows server 2012 oem slp key
win10 enterprise key on sale
windows server 2008 r2 64 bit product key
buy windows 7 professional product key online
windows 81 pro activation key list
windows 8 professional key activation
windows 8 pro cd key
microsoft office standard 2010 64 bit cd key
office 2010 key paypal
exchange server 2013 license key
hp office 2010 oem key
windows 7 home premium 64 bit product key purchase
windows 7 home key online
product key for windows 8 enterprise n
key windows server 2008 r2
windows 7 ultimate key oem

Gambar 1

Gambar 1

  1. Klik kolom pada label hurufnya untuk memilih seluruh kolom yang berisi data dan copy dengan cara menekan Ctrl + C, ke menu Edit | Copy, atau dengan menekan icon Copy pada toolbar Standard . (Memilih seluruh kolom karena anda perlu seluruh isi data beserta judul kolomnya).
  2. Mem-Paste-kan data tersebut ke kolom lain (misalnya Kolom E)yang (ingat beri jarak dengan range sumber data), atau pada sheet baru. Setelah anda melakukan paste, kolom B masih tetap terpilih (lihat ada garis putus-putus disekeliling Kolom B). Akan tetapi jika anda secara tidak sengaja telah membatalkan peritah select, pastikan bahwa petunjuk sel (cell pointer) berada di dalam data yang baru anda paste (kolom E) sebelum melanjutkan. Catatan: Anda tidak perlu memilih seluruh data atau men-sort (urut data) dahulu untuk melakukan perintah ini.
  3. Ke menu Data | Filter | Advanced Filter. Secara otomatis, Excel akan menunjukkan bahwa filtering telah aktif. Kita lanjutkan saja, yaitu dengan memilih opsi copying the unique records to another location, sehing anda dapat membandingkan kedua daftar secara berdampingan.
  4. Pilih opsi (radio button) Select the Copy To Another Location (Gambar 2), pilih opsi Check Box Unique Records Only , dan ketik G1 pada input Copy To field.
  5. Klik OK, dan Excel akan mengcopykan daftar dengan data unik dari kolom sumber data ( kolom E) ke kolom baru ( kolom G). Bahkan hasinya akan urut abjad , seperti yang tampak pada Gambar 3

Gambar 2

 

Gambar3

 

Selamat berkarya !!!!

Leave a Reply

Your email address will not be published. Required fields are marked *