pulling values from a column and reordering them in another column without spaces

Hi,

I have a couple of columns that look like this in basic form:

Column A Column B
A 1
B 1
C 0
D 2
E 1
F 0
G 2

What I want is in a separate worksheet for it to pull the names (A, B, E) that have 1s next to them in column B and put them in a list.

I could do this kinda manually, but how can I create a nice list in a separate column on a separate worksheet just of the names (column A values) where there is a 1 in column B? All I can think to do is vlookup the data and put blanks where its not equal to 1 and then manually delete out the other rows.

Thanks a lot for the help

Are you confirming the formula in A1 with CTRL+SHIFT+ENTER and not just ENTER.. You should see { } brackets appear around the formula.. then you can copy it down the column

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

Originally Posted by rantarctica

ahh ok i see. what is the significance of the control shift enter

works now though

thanks a lot

It signifies an array formula...

For your reference... http://www.cpearson.com/excel/ArrayFormulas.aspx