Formula to extract a unique list of values from a row

[smide]

Hello.

In row 2, cells A2:C2 and E2:F2 I have product values and in cells H2:I2 'adjusted' product values. I need to compare those two ranges (A2:F2 and H2:I2) and to extract unique 'adjusted' values in cells J2 and K2, if there are such a values of course.

example.

	A​	B​	C​	D​	E​	F​	G​	H​	I​	J​	K​
1​										Results​	Results​
2​	2​	3​	5​		8​	4​		1​	3​	1​
3​	4​	12​	9​		19​	25​		11​	20​	11​	20​
4​	67​	98​	33​		22​	54​		33​	54​

explanation: row 2 - comparing A2:F2 with H2:I2 only number 1 in cell H2 is unique so result in cells J2 and K2 is 1 and blank cell
row 3 - both numbers in H3 and I3 are unique, results in cells J3 and K3 are 11 and 20
row 4 - neither of cell values in cells H4 (33) and I4 (54) are unique (they already exist in range A4:F4) so both result-cells J4 and K4 are blank

 

[Georgiboy]

Simple option:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M
2												Results	Results
3	2	2	3	5		8	4		1	3		1
4	3	4	12	9		19	25		11	20		11	20
5	4	67	98	33		22	54		33	54
Sheet1

Cell Formulas
Range	Formula
L3:L5	L3	=IF(COUNTIF(A3:G3,I3)<1,I3,"")
M3:M5	M3	=IF(COUNTIF(A3:G3,J3)<1,J3,"")