View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] TIJIPMATHEW@gmail.com is offline
external usenet poster
 
Posts: 1
Default How to remove duplicated items from a list?

On May 14, 11:05*am, Eric wrote:
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


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