pick names from B2 if O2 meets criteria "x"

[BRIZZLE101]

Hi guys,

I'm trying to find a way to summarize a column. Basically if a cell in Data!O2:O500 has an "x", then I'd like to pull the name from B2:B500, skipping the cells that have nothing "".


B2 ---------O2
Jack x
Bill
Sam x



I would like my new list
Jack
Sam



I believe this is possible, but I'm having a huge brain fart.
BRIZZLE!

[benishiryo]

hi Brizzle, welcome to the forum. assuming your list starts from Q2, try this array formula:

Please Login or Register  to view this content.

[FDibbins]

in P2, copied down, use this...

=IFERROR(INDEX(OFFSET(INDEX($A$2:$A$17, MATCH("x",$O$2:$O$17, 0)),,, COUNTIF($O$2:$O$17, "x"), ), ROW(A1)), "")

adjust ranges as needed

[BRIZZLE101]

thanks benishiryo that works.
Thanks FDibbins, that kind of works initially. Results are skewed after a few cells.

Brizzle!

[FDibbins]

If you are not getting accurate results, you probably copied it to the wrong place, or you are not using x as the "selecter"