View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_3_] Sheeloo[_3_] is offline
external usenet poster
 
Posts: 1,805
Default Delete Repeated Data?

If you have your numbers in Col A then enter this formula in B1 and copy down
till end of your data set..
=IF(COUNTIF($A$1:A1,A1)=1,A1,"")

It will replace duplicate numbers with blank except for the first occurence.

"evoxfan" wrote:

I have a column of numbers such as:
190.000
190.000
194.000
580.000
910.000
910.111
910.130
I want to delete the numbers that are repeated.

What is the best way to accomplish this?