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

If you don't care about spaces and you have the six numbers in cells A1:F1, you can do this in cells A2:F2:

=IF(COUNTIF($A$1:A1, A1) > 1, "", A1)

And just drag it across. For your example, that would result in 1, ,2, ,3, .