Need to know how to delete and shift cells up when an IF statement is blank

[audput]

I need to know how to delete and shift cells up when an if statement is blank by not using a macro. For instance, my formula is =IF(ISBLANK('Master List !A12),"",IF('Master List '!A12>0,'Master List'!B12,"")). If this formula returns a blank in that cell I want it to shift the cells up to show only the ones with values. What would be the formula I would use?

[mshale]

I'm pretty certain that it is not possible to do what you are asking. You will need a macro to do that.

However, you can use the filter function to filter out the blanks.

[audput]

Okay, if i use a macro then and want it to delete the rows that are blank and shift up the rows with values how would I do that. For instance my cells that I want it to search for blank rows are A1:A219. Thank you for your help!

[mshale]

this will do it until the end of the column:

Please Login or Register  to view this content.

[audput]

Okay, what if I want to hide the rows that are blank, but them unhide them when they come up with a value using a macro?

[mshale]

This should do the trick:

Please Login or Register  to view this content.

Run this each time the data changes.

[audput]

Thank you so much it worked!!!!