Excel 2011 for Mac: Select a range of cells that contain conditional.įiltering for unique values and removing duplicate values are two closely related tasks because the displayed results are the same - a list of unique values. Then choose Format, Conditional Formatting, and then click the Delete button.
In this article I'll first cover show how to identify duplicate values in a single.
