How do I remove the repested numbers in list of nembers in Excel?

  • Thread starter How do I remove the repested numbers in
  • Start date
H

How do I remove the repested numbers in

thank you for answer this question.
How do iremove the repeated number in list of nembers in Excel?
 
M

Max

How do I remove the repested numbers in said:
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
 
Top