beginner-excel
New Member
- Joined
- Jun 30, 2008
- Messages
- 36
Hello,
I have three cells with data (Subtotal; (blank) means there's no data in the cell):
Column H | Column I | Column J | Column K | Column L
----------------------------------------------------
Subtotal | (blank) | 0.0 | 0.0 | (blank)
-----------------------------------------------------
(blank row)
-----------------------------------------------------
Total | (blank) | 3.0 | 1.0 | (blank)
I want to find Subtotal and if it has 0.0 and 0.0 in columns J and K, then delete those cells (not the entire row only the cells), and move cells up so that the result is:
Column H | Column I | Column J | Column K | Column L
----------------------------------------------------
(blank cells)
-----------------------------------------------------
Total | (blank) | 3.0 | 1.0 | (blank)
If possible, I'd like to delete the blank cells as well.
Help! I tried to do a search for deleting cells based on the value of one cell but only saw deleting rows based on the value of one cell.
I have three cells with data (Subtotal; (blank) means there's no data in the cell):
Column H | Column I | Column J | Column K | Column L
----------------------------------------------------
Subtotal | (blank) | 0.0 | 0.0 | (blank)
-----------------------------------------------------
(blank row)
-----------------------------------------------------
Total | (blank) | 3.0 | 1.0 | (blank)
I want to find Subtotal and if it has 0.0 and 0.0 in columns J and K, then delete those cells (not the entire row only the cells), and move cells up so that the result is:
Column H | Column I | Column J | Column K | Column L
----------------------------------------------------
(blank cells)
-----------------------------------------------------
Total | (blank) | 3.0 | 1.0 | (blank)
If possible, I'd like to delete the blank cells as well.
Help! I tried to do a search for deleting cells based on the value of one cell but only saw deleting rows based on the value of one cell.