Listing choices on worksheet

  • Thread starter Thread starter Greta
  • Start date Start date
G

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
 
Here is one way;
=IF(Sheet1!B1="x",Sheet1!A1,"")

though, this would leave spaces between cable and cabinet.
 
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!
 
Back
Top