Tecnologia, programação e muito Visual FoxPro.

quinta-feira, 25 de agosto de 2011

Re: ]] XL-mania [[ Remove Duplikat

Coba array formula unique list berikut dipasang pada cell a24. Kemudian copy kebawah.
=INDEX($B$2:$B$13,MATCH(0,COUNTIF(A$23:A23,$B$2:$B$13),0))

Regards.
Kid.

On Thu, Aug 25, 2011 at 11:58, Datacenter SBE <datacenter.sbe@ustp.co.id> wrote:

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