how to delete duplicates in a row on excel

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…

  1. Sort the column (we’ll assume the column begins in cell A2) in ascending order.
  2. In cell B2 type the formula: =IF(A3=A2,1,0)
  3. Copy that formula down the same number of rows that are in column A.
  4. 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.