Horizontal Formula

[Geo Jul]

Dear All, May I kindly request that you help me with this formula?

my request to amend my formula to be used as horizontal

result

=IFERROR(INDEX($A$2:$A$15,MATCH(0,COUNTIF(K$8:K8,$A$2:$A$15),0),1),"")

as in our office, we use Excel 2016

Many thanks in advance

 

[6StringJazzer]

Horizontal for what ranges?

 

[Geo Jul]

Horizontal for what ranges?

thank you for your reply $A$2:$A$15

 

[6StringJazzer]

Your formula returns a single number.

It uses two vertical ranges.

What you do mean by "used as horizontal"?

 

[Geo Jul]

Your formula returns a single number. It uses two vertical ranges. What you do mean by "used as horizontal"?

 

[6StringJazzer]

If you are using Excel 365 please use this formula in D15:

=TRANSPOSE(UNIQUE($A$2:$A$15))

$scratch.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L
1	Product Code
2	Product 10
3	Product 16
4	Product 9
5	Product 20
6	Product 7
7	Product 3
8	Product 19
9	Product 19
10	Product 12
11	Product 10
12	Product 12
13	Product 10
14	Product 18
15	Product 3			Product 10	Product 16	Product 9	Product 20	Product 7	Product 3	Product 19	Product 12	Product 18
Sheet12

Cell Formulas
Range	Formula
D15:L15	D15	=TRANSPOSE(UNIQUE($A$2:$A$15))
Dynamic array formulas.

 

[kevin9999]

as in our office, we use Excel 2016

With 2016, this should work for you:

Book1
	A	B	C	D	E	F	G	H	I	J
1	Product Code
2	Product 2
3	Product 9		Product 2
4	Product 13		Product 9
5	Product 4		Product 13
6	Product 7		Product 4
7	Product 3		Product 7
8	Product 2		Product 3
9	Product 3		Product 19
10	Product 7
11	Product 19
12	Product 4
13	Product 13
14	Product 9
15	Product 19		Product 2	Product 9	Product 13	Product 4	Product 7	Product 3	Product 19
16
Sheet1

Cell Formulas
Range	Formula
C3:C11	C3	=IFERROR(INDEX($A$2:$A$15,MATCH(0,COUNTIF(C$2:C2,$A$2:$A$15),0),1),"")
C15:J15	C15	=IFERROR(INDEX($A$2:$A$15,MATCH(0,COUNTIF($B15:B15,$A$2:$A$15),0),1),"")

 

[6StringJazzer]

I missed that, I just looked at 365 in the user profile.

 

[kevin9999]

I missed that, I just looked at 365 in the user profile.

I'm always doing that...

 

[Geo Jul]

I missed that, I just looked at 365 in the user profile.

thank you very much for time and effort