A method I consider more reliable is to:
- ensure relevant columns are headed with labels
- select all the relevant columns
- Data > Sort & Filter - Advanced, select Copy to another location
- confirm List range: is correct (or adjust)
- Copy to: "X", tick Unique records only and OK
where "X" is a reference to the top left cell of an unoccupied array, in the same sheet, whose size can accommodate all the data in the 'relevant' columns.
- Delete 'relevant' columns (if desired).
It can be advantageous that with this approach the duplicate records are not automatically deleted and it works as I would expect whereas Remove Duplicates does not for, for example, the dataset in SU Question 572226 Excel “Remove Duplicates” feature does not remove all duplicates.
Note that Copy to: must reference the same sheet so this solution is limited to a maximum of 16,384/2 columns.
An answer to your exact question therefore is "depends upon what is in your columns".