Return all cells in the same row as a cell with value 0

[Patrick]

I have names in one column and an interger value 1-10 in
the second (or I can change to first if necessary). I want
to return all the names of people with 0 value in his/her
respective row. Probably simple, but I don't know how.

Thanks,

Patrick

 

[Jason Morin]

Select both column and go to Data > Filter > AutoFilter.
Select 0 on the dropdown menu for the integer column. For
more info on using Autofilter, see:

http://www.contextures.com/xlautofilter01.html

HTH
Jason
Atlanta, GA

 

[Patrick]

Not really what I want. I was not clear. I need to have a
third column that only returns the names from the first
column with a zero in the cell next to them.

This is what I want:

Column A Column B Column C

smith 1 jones
jones 0 king
homey 2
king 0

 

[Jason Morin]

Put this in C2 and press ctrl/shift/enter and fill down
until you see error values. Fill down as many rows as
there will be zeros in col. B (meaning if you expect 50
rows with zeros, fill down at least 50 rows).

=INDEX($A$1:$A$10,SMALL(IF($B$1:$B$10=0,ROW
($B$1:$B$10)),ROW()-1))

HTH
Jason
Atlanta, GA

 

[Patrick]

Well, works in the one cell, but not in any I fill
down....