Listing choices on worksheet

[Greta]

I'm trying to get a list of products onto another
worksheet.
Sheet 1 looks like this (kind of):

Cable x
Monitor
Cabinet x
Tower x
Phone
Case x

What I need is for the items in Column A, that have an "X"
in Column B to be listed on Sheet 2 like this:

Cable
Cabinet
Tower
Case

P.S. I'm very familiar with SUMIF and guess it's something
similar?
Thanks,
Greta

 

[Dave R.]

Here is one way;
=IF(Sheet1!B1="x",Sheet1!A1,"")

though, this would leave spaces between cable and cabinet.

 

[Dave R.]

This may be of interest to return list without spaces;

http://tinyurl.com/389wp

 

[Greta]

Yeah, it wouldn't be a problem for me if I didn't need to
eliminate the spaces. I'll try the site you recommended.
Thank you for your help!