Multiple List, Find Unique Value and Return Column Header.

[Roj47]

Happy New Year,

Is there a formula that I am able to use to automatically generate the example to the right of the column which runs in real time please?

The table is based on a formula =unique(filter(arrays))

I am not always the best at explaining so apologise, essentially would like to know which shops sell each product but have it listed horizontally. If it works better vertical I can easily work with that.

Regards

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D	E	F	G
1
2	Shop A	Shop B	Shop C
3	a	b	d		a	Shop A	Shop C
4	b	c	e		b	Shop B	Shop A
5	c		f		d	Shop C	Shop A
6	d		a		c	Shop B	Shop A
7					e	Shop C
8					f	Shop C
9
Data

Cell Formulas
Range	Formula
E3:E8	E3	=UNIQUE(TOCOL(A3:C6,1))
F7:F8,F3:G6	F3	=TOROW(IF($A$3:$C$6=E3,$A$2:$C$2,1/0),2)
Dynamic array formulas.

 

[Roj47]

Happy New Year, all the best for 2024.

That is outstanding! Wow... There would have been zero chance I would have been able to construct that from on-line searches and patching together thread information from here.

Thank you, works 100%.

 

[Fluff]

You're welcome & thanks for the feedback.