DELETE ROW

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If a CELL has 0 in it and I want to DELETE THE ENTIRE ROW
for every cell that is 0, can this be done with a formula,
if so, can you help?
 
The only way it can be done by a formula is to use a filter as well,
you would need a help column that checks the zero and then
filter on TRUE on the help column, select the visible range, F5 to select
visible cells only then
ctrl and - or edit>delete, entire row = yes


--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Hi
can't be done with a formula. A non macro approach would be:
- apply an Autofilter ('Data - filter')
- filter all '0' rows
- delete these rows
- remove the Autofilter
 
Thanks a million, will try it!
-----Original Message-----
The only way it can be done by a formula is to use a filter as well,
you would need a help column that checks the zero and then
filter on TRUE on the help column, select the visible range, F5 to select
visible cells only then
ctrl and - or edit>delete, entire row = yes


--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)





.
Click to expand...
 
Thanks a million Frank, I'll give it a try.
-----Original Message-----
Hi
can't be done with a formula. A non macro approach would be:
- apply an Autofilter ('Data - filter')
- filter all '0' rows
- delete these rows
- remove the Autofilter

--
Regards
Frank Kabel
Frankfurt, Germany



.
Click to expand...
 
Back
Top