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:

Please Login or Register  to view this content.

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

Originally Posted by Fluff13

How about

Formula:

Please Login or Register  to view this content.

This worked perfectly, thanks!

Thanks to you CARACALLA as well.

You're welcome & thanks for the feedback.