1. Select data source, in the enclosed picture, it is column A
2. Go to menu Data\Filter\Advanced Filter...
3. MS Excel will popup a dialog and say sth., just click button 'O.K.'
4. On the newly popuped dialog, select data destination, it is column
C in the enclosed picture.
5. Tick on 'Unique records only'
6. Click button 'O.K.", done.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment