You cannot remove duplicate information when the range has an outline. To remove duplicates, clear the outline and perform ...