how do I delete duplicates from a row of 500 numbers in one column using excel?
Your question doesn’t really make any sense. How can one have a row of 500 numbers in one column? Do you have one cell that contains a list of 500 numbers?
If you meant a column of numbers rather than a row…
- Sort the column (we’ll assume the column begins in cell A2) in ascending order.
- In cell B2 type the formula: =IF(A3=A2,1,0)
- Copy that formula down the same number of rows that are in column A.
- Use auto filter to show only the rows that have 1’s in column B and delete those rows. The formulas in column B will probably show #REF! after you delete the rows but it doesn’t matter at that point.