Top Ten Excel Annoyances
Subject:   Deleting a cell (or cells) with a formula
Date:   2007-07-10 23:09:09
From:   Lurcherous
I would like to use a formula which would delete cells within a selected array if they displayed a certain value AND then allow the remainging cells to be shifted up. I.e. something like,
=IF(A1 = 2, DELETE, UP, A1) so that the last statement, A1, returns the value of the cell. Maybe a conditional format?
I am aware that this formula has a circular nature however, is it possible?