Question

which button under data tab is used to remove duplicate value from one or more columns​

Answer 1

To select the entire table, press Ctrl + A. With the range selected, 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

$\huge\underline{\overline{\mid{\bold{\red{ɪᴛᴢᴍøøɴʙøʏ-}}\mid}}}$

Answer 2

Answer:

Remove duplicates button.