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: 330
excel-2007
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