How to remove duplicated items from a list?

  • Thread starter Thread starter Eric
  • Start date Start date
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
 
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
 
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

using duplicate function 13
is there a simple formula that will remove all duplicates 3
How to remove the top & bottom 10% from a list? 3
How to easily migrate PST to Zoho account? 2
Merge 2 excel worksheets into one and remove duplicate entries. 1
Simple Methods to Export Gmail to Text? 1
Help with combining lists 1
How to determine the value? 2

Back
Top