View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default How do I remove the repested numbers in list of nembers in Excel?

"How do I remove the repested numbers in" wrote:
How do i remove the repeated number in list of numbers in Excel?


One way ..

Assuming the list of numbers is running in A2 down, with a textlabel in A1

Select col A, click Data Filter Advanced Filter
Check "Copy to another location"
Copy to: B1 (say)
Check: Unique records only
Click OK

The uniques list will appear in col B
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---