Bls: ]] XL-mania [[ Remove Duplikat

untuk excel 2003 formula di formula di G2 formula array {=IF(ISNA(INDEX($B$2:$B$13;MATCH(0;COUNTIF(G$1:G1;$B$2:$B$13);0)));"";INDEX($B$2:$B$13;MATCH(0;COUNTIF(G$1:G1;$B$2:$B$13);0)))} untuk excel 2007 formula di formula di L2 formula array {=IFERROR(INDEX($B$2:$B$13;MATCH(0;COUNTIF(L$1:L1;$B$2:$B$13);0));"")} semua formula di copy ke bawah sampai data habis wassalam Ghozi Alkatiri --- Pada Kam, 25/8/11, Datacenter SBE <datacenter.sbe@ustp.co.id> menulis: Dari: Datacenter SBE <datacenter.sbe@ustp.co.id> Judul: ]] XL-mania [[ Remove Duplikat Kepada: "XL-mania@yahoogroups.com" <XL-mania@yahoogroups.com> Tanggal: Kamis, 25 Agustus, 2011, 11:58 AM Selamat siang para master XL Kami ingin bergabung dengan XL mania,,,,,,,,Saya ingin bertanya kepada para master XL   Di XL sudah disediakan  program Remove Duplikat,yang kami tanyakan bagaiman cara meremove duplikat dalam bentuk Rumus. Kami tunggu konfirmasinya trimakasih                 Regards Data Center UNION SAMPOERNA TRIPUTRA PERSADA PT.HHK-SUNGAI BILA EATATE       Unless specifically stated, any views or opinions expressed in this e-mail are those of the author only and does not constitute a formal view and/or opinion of PT. UNION SAMPOERNA TRIPUTRA PERSADA. All information and attachment in this e-mail is or may be confidential, legally privileged, and proprietary in nature or otherwise protected by law from disclosure and is intended solely for the use of the addressee(s). If you are not the intended recipient, you are hereby notified that any disclosure, dissemination, distribution, copying or use of any part of this e-mail is strictly prohibited and unlawful, and you shall therefore notify the sender immediately and delete the e-mail from your computer.