I have an excel workbook with three sheets:
First Sheet
This sheet has three columns. Column A is simply a set of random numbers. Column B is empty and is designed so that the spreadsheet user can place an x next to values in Column A that the user would like to "mark". Column C has an "if" formula that basically says, =if(B1="x", A1, "")
So now, any "A" cell that I select by placing an "x" in the "B" column is copied into Column C.
Second Sheet
I'd like Column A in this sheet to pull the values from Column C in the previous sheet, but without skipping any lines. In other words, I want the values from Sheet1:ColumnC, but collapsed so that they're all next to each other--nice and neat.
Is this possible?
Bookmarks