3
2
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.
Thank you! That is an extremely clever and totally bizzaro way to go about doing that.
I don't think it'll work for my purposes because this spreadsheet is going to move around a lot, so the location of the target file for the query will change, unfortunately. – None – 2010-03-30T09:09:38.800