Index match

[donniedorian]

Hi
I need an index match to get all the b1:e1 which are greater than 0

Anyone can help ?

a	b	c	d	e	f	g	h	i	k
1	aaa	bbb	ccc	ddd
2	0	1	0	1		bbb	ddd
3	1	2	3	0		aaa	bbb	ccc
4	2	0	0	0		aaa
5
6

<tbody>
</tbody>

 

[donniedorian]

The result starts in G2

 

[Aladin Akyurek]

The result starts in G2

In G2 control+shift=enter, not just enter, copy across, and down:

=IFERROR(INDEX($B$1:$E$1,SMALL(IF($B2:$E2>0,COLUMN($B$1:$E$1)-COLUMN($B$1)+1),COLUMNS($G2:G2))),"")

 

[donniedorian]

Thank you very much Aladin for the quick solution

 

[Aladin Akyurek]

Thank you very much Aladin for the quick solution

You are welcome.