How to remove duplicated items from a list?

E

Eric

Does anyone have any suggestions on how to remove duplicated items from a list?
For example, there is a list of number under column A, and I would like to
remove any duplicated items and lists it under column B.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric
 
T

TIJIPMATHEW

Does anyone have any suggestions on how to remove duplicated items from a list?
For example, there is a list of number under column A, and I would like to
remove any duplicated items and lists it under column B.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric
Click to expand...

go to DATA --> Filter --> Advance Filter give copy to another
location (select the col B) and unique record only
 
E

Eric

Thank you for your suggestions
I don't want to use DATA --> Filter --> Advance Filter, do you have any
other approach?
Thank you for any suggestions
Eric
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Duplicate hashtags in OneNote 0
Setting language of a selected text in Office apps. 0
Formating bolded text exclusively. 0
Space at end of multi page list to accommodate new entries 1
Removing a repeated words 0
You'll need a new app to open this about link 1
Excel does not accept text format! 0
using duplicate function 19

Top