0
votes
1answer
1k views

Excel - can't get the formula to copy correctly

Have an excel sheet. I want B3 = C3 * C2 So far everything is good. I want B4 = C4 * C2 Did these two manually. I have a lot of rows so I wanna copy the formula. The problem is, I select them ...
0
votes
1answer
214 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
135 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 ...