Tagged Questions

0
votes
1answer
153 views

Delete rows in Excel based on returned value in row cell

I have a worksheet in Excel with values in some rows in column B that have been returned as zero (0) but still have a formula in the cell. I want to be able to delete just these rows using a macro.
-2
votes
1answer
118 views

How do I create a range from a cell value?

For example: A B 7926 3 FROM =COUNTIF(AQ$7926:AQ7970,"=0") 7926 3 FROM =COUNTIF(AQ$7926:AQ7971,"=0") 7926 3 FROM =COUNTIF(AQ$7926:AQ7972,"=0") 7926 3 ...