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 <[email protected]>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. >
<<image001.jpg>>
re-Contoh Data.xls
Description: MS-Excel spreadsheet
