Index match

[donniedorian]

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

Anyone can help ?


[TABLE="width: 500"]
<tbody>[TR]
[TD]a
[/TD]
[TD]b
[/TD]
[TD]c
[/TD]
[TD]d
[/TD]
[TD]e
[/TD]
[TD]f
[/TD]
[TD]g
[/TD]
[TD]h
[/TD]
[TD]i
[/TD]
[TD]k
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]aaa
[/TD]
[TD]bbb
[/TD]
[TD]ccc
[/TD]
[TD]ddd
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]0
[/TD]
[TD]1
[/TD]
[TD]0
[/TD]
[TD]1
[/TD]
[TD][/TD]
[TD]bbb
[/TD]
[TD]ddd
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[TD]3
[/TD]
[TD]0
[/TD]
[TD][/TD]
[TD]aaa
[/TD]
[TD]bbb
[/TD]
[TD]ccc
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]2
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD][/TD]
[TD]aaa
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[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.