Remove duplicates within a row

Question

How do I remove duplicates within a row for Excel without using VBA?

What i have:

Row 1: 1 | 1 | 2 | 2 | 3 | 3

What i want:

Row 1: 1 | 2 | 3

Answer 1

To check for duplicates, choose the cells you want to check.

Note that duplicates in the Values section of a PivotTable report cannot be highlighted in Excel.

Duplicate Values can be found by going to Home > Conditional Formatting > Highlight Cells Rules > Duplicate Values.

Select the formatting you want to apply to the duplicate values in the box next to values with, and then click OK.