Position | Target |
QB | Fade |
RB | Fade |
WR1 | Nelson Agholor |
WR2 | Fade |
WR3 | Fade |
TE | Zach Ertz |
QB | Fade |
RB | Alex Collins |
WR1 | Fade |
WR2 | Fade |
WR3 | Fade |
TE | Fade |
<tbody>
</tbody>
I have the following data, on another sheet I want to pull all the names in column B <> "Fade"
I was trying an array formula like this: =IF(ISERROR(SMALL(IF($B$2:$B$13<>"Fade",ROW($A$2:$A$13)),ROW())),"",INDEX($B$2:$B$13,SMALL(IF($B$2:$B$13<>"Fade",ROW($A$2:$A$13)),ROW())-1)) but I just can't get it to work. Any help would be appreciated.