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 <[email protected]> menulis:
Dari: Datacenter SBE <[email protected]>
Judul: ]] XL-mania [[ Remove Duplikat
Kepada: "[email protected]" <[email protected]>
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.
|
ghozi 25082011 Contoh Data.xls
Description: MS-Excel spreadsheet
