Question

Which button under data tab is used to remove a duplicate valur from one Or more 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...

I hope it may helpful to you ...

Answer 2

Explanation:

In Microsoft excel , a spreadsheet is the main area where data is entered. This spreadsheet is contains numerous cells.  

In Microsoft Excel spreadsheet, rows and columns are key components in defining the exact location of any cell. Now there is a possibility of data cells becoming duplicated. To remove duplicates, select the area and then go to data pane, click on data tools and then click Remove duplicates