Construct Column From Checked Values

[MotrColt]

Alright I'm guessing this is a pretty common thing in excel and has likely been asked, but I can't think of the correct language to search for a solution to it! I thinks its easier just to post what I want than try and explain it.

Anyways, say I have number 1-10 in column A1-A10. In column B I put an 'X' in B3, B5, B8,and B10. In Column C I want output in C1-C4 the values in A1-A10 that have an X next to them so 3, 5, 8, 10

Untitled.png

What formula would I input into column C to get this output. I'm guessing this would be done using an array (which i have very little experience using), or maybe you guys have some other solution.

Thanks for the help

[Pete_UK]

You can put this array* formula in C1:

=IFERROR(INDEX($A$1:$A$10,SMALL(IF($B$1:$B$10="x",ROW($B$1:$B$10)),ROWS($1:1))),"")

*Note that an array formula needs to be committed using the key combination of Ctrl-Shift-Enter (CSE), instead of the usual Enter.

Then you can copy the formula down as far as is required, using your usual way(s).

Hope this helps.

Pete