Bolehkan pakai fungsi* RemDupText* saja pak Misal data di B3 *=RemDupText(B3)* [image: Contoh Hasil RemDupText.GIF]
2011/8/26 M. Hadi Maksun <[email protected]> > Selamat sore para master XL > > Saya, ingin bertanya kepada para master XL > bagaimana me-Remove Duplikat isi cell dg sparator "," semisal isi cel > semula > * MF1110019, MF1110016, MF1110017, MF1110018, MF1110020, MF1110019, > MF1110016, MF1110017, MF1110018, MF1110020, MF1110019, MF1110016, > MF1110020, MF1110017, MF1110018, MF1110016, MF1110019, MF1110017, > MF1110018, MF1110020* > > sekaligus tersortir menjadi. > * MF1110016, MF1110017, MF1110018, MF1110019, MF1110020* > > Terimakasih, atas penjelasannya. > trimakasih > -- > Rgds, > > M. Hadi Maksun
<<Contoh Hasil RemDupText.GIF>>
ctv_Fungsi RemDupText.xls
Description: MS-Excel spreadsheet
