Forum Discussion

56008769's avatar
56008769
Copper Contributor
Jul 31, 2024

How to Return Text from Column 1 if Text in Other Rows Match

Hello, here is an example data set I am dealing with and what I am trying to find a formula for:     In reality, I have about 85 tasks.  In the second table, I want it to return for each day...
Excel on Mac
Formulas and Functions
Rodrigo_'s avatar
Rodrigo_
Iron Contributor
Jul 31, 2024

Hello 56008769,
Use this array formula on B17

=IFERROR(INDEX($A$2:$A$13,SMALL(IF(B$2:B$13="X",ROW($A$2:$A$13)-ROW($A$2)+1),ROW(1:1))),"")

 

 

Resources