Return all texts where the adjacent cell is >0

How do you want the results returned? In a single cell, in rows, in columns?

As an array where all results follow each other down one column.

Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. Just before posting, scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

	A	B	C	D	E
1	a	1			a-c-d-r
2	b	-2
3	c	3
4	d	4
5	r	5

E1=TEXTJOIN("-",TRUE,IF(B1:B100>0,A1:A100,""))

Hi, CARACALLA. We're close, however, I need every result in its own line. I've updated the original post with an example.

How about

Formula:

=FILTER(A2:A20,B2:B20>0)

Originally Posted by Fluff13

How about

Formula:

=FILTER(A2:A20,B2:B20>0)

This worked perfectly, thanks!

Thanks to you CARACALLA as well.

works for all versions of excel


D2=IFERROR(INDEX($A$2:$A$100,SMALL(IF($B$2:$B$100>0,ROW($A$2:$A$100)-ROW($A$2)+1),ROWS($A$2:A2))),"")

Control+shift+enter . For office 365 only enter

copy down

You're welcome & thanks for the feedback.