Question

which button under data tab is used to remove a duplicate value from the column.

Answer 1

Answer:

Go to the Data tab > Data Tools group, and click the Remove Duplicates button. The Remove Duplicates dialog box will open, you select the columns to check for duplicates, and click OK.

Explanation:

hope it helps