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?
|