excel newb
New Member
- Joined
- Mar 29, 2009
- Messages
- 15
Hi,
I have a column with "1" and "0". I'm looking for something like, if the value in a cell within the column is "0", then delete the 4 cells previous to the cell that contained "0" within the row. Instead of deleting, the values can also be replaced with anything e.g., zero or n/a etc. Whichever way it would work, would be great.
Thank you!
I have a column with "1" and "0". I'm looking for something like, if the value in a cell within the column is "0", then delete the 4 cells previous to the cell that contained "0" within the row. Instead of deleting, the values can also be replaced with anything e.g., zero or n/a etc. Whichever way it would work, would be great.
Thank you!