Question

remove duplicates button is present in under dash tab​

Answer 1

Answer:

select your column, then select remove duplicates, if there are more columns in the sheet next to the one you’re trying to deduplicate Excel will ask if you want to expand the selection, if you don’t need that just select to stay with the current selection, pick your criteria and finish