Delete Duplicate values horizontally.

[qazibelal]

Normally we remove duplicates through 'remove duplicate' or Unique() function in excel or through Power Query. But all these methods are applicable to identify duplicate as whole row or in a particular column.

Is there a way we can remove duplicates Horizontally i mean row wise?

 

[cmowla]

Well UNIQUE has an optional parameter to delete duplicates by column. But if you don't pass it, it deletes by row. (But yeah, Excel Data Ribbon itself appears to only do by row.)

a.xlsx
	A	B	C	D	E	F	G	H
1	a	a	a	b	c		a	a
2	a	b	c				a	b
3							a	c
4							b
5							c
Sheet7

Cell Formulas
Range	Formula
H1:H3	H1	=UNIQUE(G1:G5)
A2:C2	A2	=UNIQUE(A1:E1,1)
Dynamic array formulas.

 

[Peter_SSs]

or Unique() function

If you have the UNIQUE function, then do you need to update your account details? (currently shows Excel 2016 which does not have the UNIQUE function)