Tecnologia, programação e muito Visual FoxPro.

quinta-feira, 25 de agosto de 2011

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.

Nenhum comentário:

Arquivo do blog