In Excel, given a worksheet "A", how do you create a sheet "B" that has a subset of the rows in "A"?

Posted by user32706 on Super User See other posts from Super User or by user32706
Published on 2010-03-30T01:30:43Z Indexed on 2010/03/30 1:33 UTC
Read the original article Hit count: 331

Filed under:

In Excel 2007, I have a sheet full of data "A". One of the columns in sheet "B" is called "Valid" and has either "yes" or "no".

I've created a second sheet "B". It's easy to make each row in "A" appear in "B" if the row is valid using an 'if' statement in each cell. But if it's invalid, there's a blank row.

I need "B" to show only the rows from "A" that are valid. TWO BIG CAVEATS: - No macros - No filtering (for long and complicated reasons).

I feel like it might be possible with vlookup used cleverly, but so far, I'm stumped.

© Super User or respective owner

Related posts about excel-2007