Give the option to copy removed duplicates
As a user, add an option to copy the removed duplicates (ribbon data / remove duplicates) to another location. Could be a new generated sheet or a location to copy them
Jon Acampora commented
Great suggestion Ricardo! It would also be nice to select the columns to output on the new sheet or range.
This could be a checkbox that would "only copy selected columns to the destination". It would be handy when you are trying to create a list of unique values, and just want the output to be a single column from the range/Table.