Surely you can use Autofilter for this (no sorting/unsorting required); it will give you a dropdown with a sorted-and -distinct list to choose from (with selection boxes), you filter on those values. Then you can select all the filtered results, then press F5 on the keyboard, Special Cells…, Visible cells only, then clear the Autofilter using the dropdown in that column's header.