||Top Ten Excel Annoyances|
|Subject:||Deleting a cell (or cells) with a formula|
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?