Article:  |
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? |
||
Women in Technology
Hear us Roar
