google filter formula in excel?

[shinkirou]

Hi, here is my question:
I have a simple problem, 2 columns A (names) and B (values); I need to make appear only the names with value=0 in a new sheet. Since i was working on google docs till some days ago i used to use this formula:

Please Login or Register  to view this content.

which i can't replicate on excel.

Any suggestion?

Thanks in advance.

[loginjmor]

Hi -

On your second sheet, in cell A1 you could enter the following formula:

=Sheet1!A1

Assuming your first sheet tab is named Sheet1 (Excel's default name), you should see the first name on your list appear in the second sheet. Simply copy this formula down as far as you need to. Column B can either remain empty, or you can enter a zero in B1 and copy that down as well.

Hope this helps.

[shinkirou]

Nope, that's not what i need, i need to filter only the element in column A which have 0 as value in column B, here is an exemple:

Column A	Column B
Name1	5
Name2	0
Name3	1
name4	0

i need in another column this (which is what appears if i use the google formula that i posted before on a google doc):

Column C

Name2

Name4

Thanks for your time and help

[djapigo]

Did you see Andy's solution?

http://www.excelforum.com/excel-form...than-zero.html

[shinkirou]

Nope, didn't see that. Thanks for the info, but i'm n00b in excel and i don't knwo how to create that button nor to check how the function used in it is written.

[popipipo]

{=IFERROR(INDEX(A$1:A$4,SMALL(IF($B$1:$B$4=0,ROW($A$1:$A$4),""),ROW())),"")}
Try this array formula

[shinkirou]

thanks popipipo! That's what i was looking for. Now there's a last thing that i'd like to understand if possible. Your formula seems to work only if the data starts form the first row of the sheet (probably becouse of the row function, i suppose). How can i modify it to check data for examble that starts from A5 to A8 instead of A1 to A4?

Thanks again for the help!