Reputation: 59

Duplicate Values - keep one of the values

I have my excel workbook sorted in colors by duplicate values.

The excel document has all of the values of the duplicates selected, how do I keep one of the values instead of completely removing all of the duplicates, including the unique value.

Upvotes: 0

Answers (2)

MarioTheHedgehog

Reputation: 306

Just select your data/column(s) and go to Data / Remove Duplicates Or select data and press Alt + A, M.

Upvotes: 1

InContext

Reputation: 2501

in Excel 2007:

Data tab >> Remove Duplicates

Upvotes: 1

Duplicate Values - keep one of the values

Answers (2)

Related Questions