I have 2 sheets with names in, some names between the 2 sheets are duplicates.

On a third sheet, can I copy the details from the other 2 sheets (that part I know) and get excel to remove the duplicates from the new sheet so I end up with a unique list?

Finally when I have the unique list made can I get excel to sort it in descending order automatically.

Thanks for your help.