Question

how can you remove duplicate value from a column​

Answer 1

$\huge\mathcal\color{red}{An}\color{orange}{Sw}\color{gold}{Er᭄}$

Remove Duplicates from a Single Column in Excel

1. Select the data.
2. Go to Data –> Data Tools –> Remove Duplicates.
3. In the Remove Duplicates dialog box:
4. If your data has headers, make sure the 'My data has headers' option is checked.
5. Make sure the column is selected (in this case there is only one column).

Answer 2

Answer:

Remove duplicate values

Select the range of cells that has duplicate values you want to remove. Tip: Remove any outlines or subtotals from your data before trying to remove duplicates.

Click Data > Remove Duplicates, and then Under Columns, check or uncheck the columns where you want to remove the duplicates. ...

Click OK.

Explanation:

Another answer...

eraser...we can remove it by erasing from eraser