View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Finding/Removing Duplicate Numbers In A Column ?

See

http://cpearson.com/excel/duplicat.htm

In article ,
"Robert11" wrote:

Hi,

I have a long list of numbers in a column.

How would I determine if there are duplicates, and "flag" them ?

How would I remove all the duplicates in a single, perhaps, step ?

Thanks,
B.