Gunakan advance filter dengan setting sbb:
From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com] On Behalf Of Niki Dwinarni Sent: Friday, January 06, 2012 10:07 AM To: Group Excell Subject: [belajar-excel] Short Listed Dear B-Excell, Bagaimana Formula untuk short listed untuk data seperti di attachfile? Thank's & regard Niki ======================================================= Mods Note: Dgn istilah BARU "Short List" itu, ybs menanyakan bgmana membuat daftar berisi data unique (list of Unique Values) dari suatu daftar yg mengandng data-data kembar. =======================================================
<<image001.png>>
<<image002.jpg>>
<<image003.jpg>>