Re: ]] XL-mania [[ Remove Duplikat isi cell

Bolehkan pakai fungsi RemDupText saja pak

Misal data di B3

=RemDupText(B3)

2011/8/26 M. Hadi Maksun <hadi@domusindo.com>

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