CODEWITHSUNDEEP
excelexcel-formula
Wen Jun
Wen Jun

Reputation: 552

Remove duplicates within a row

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

Upvotes: 3

Views: 23626

Answers (2)

Ronaldo.K
Ronaldo.K

Reputation: 303

First, split cells to columns using [Text to columns] in the [DATA] tab
2: transpose data
3: [Remove Duplicates] in the [DATA] tab
4: transpose data
5: concat cells

Upvotes: 0

jrad
jrad

Reputation: 3190

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, .

Upvotes: 3

Related Questions