Create separate sheet to print only rows with no value in specific cells

[EdNerd]

(XL 2007) I need to see if I can use formulas to pull values from one worksheet into another based on whether a certain cell has a value or not. I'm trying to create a printable page, devoid of Conditional Formatting colors and showing only values for rows in which the cell in (for example) Col E in that row is blank. But no blanks for rows that don't meet criterion. And formulas only, no VBA please.

I could just run a formula down each column: =IF(Sheet1!E5 = "", Sheet!A5,""), =IF(Sheet1!E5 = "", Sheet!B5,""), etc. But that will give me blank rows where E5 is not blank.

I'm thinking I'm looking at an array formula?? How would I sset that up?

Ed

 

[EdNerd]

Apologies - I do not see a way to edit the previous post.

I do have the following array formula that will copy everything over:
=IFERROR(INDEX(PC57!A6:A100,SMALL((IF(LEN(PC57!A6:A100),ROW(INDIRECT("1:"&ROWS(PC57!A6:A100))))),ROW(A1)),1),"")

Unfortunately, it's not dowing me much good because I can't figure out how to adjust it to leave out values with col E blank.

 

[EdNerd]

Never mind. I got something acceptable working.