I have a spreadsheet where some rows have data in each column, and some rows only in certain columns. Here's a very simplified example - the actual files usually have up to 1500 rows.
What I need to do is fill in the formulas in columns C, H, and I. H is no problem, it goes on every row. But the others only go on the first row of each sub-chunk of data. I want to be able to fill down without going through thousands of rows, deleting the in-between zeros. I did find that if I filtered out the blanks from column D, manually filling down would do that, but if I tried it via a macro, it would put the formula in every row.
Furthermore, the formula in column I takes the minimum from all the rows in each chunk. It varies, it could be two rows in one chunk and fifty in the next. I'd like to see if it's possible to have it fill down only into the appropriate rows AND figure out the correct range to take the minimum from. Again, I'd rather not go through thousands of rows adjusting the range.
Is there any way to do this?
What I need to do is fill in the formulas in columns C, H, and I. H is no problem, it goes on every row. But the others only go on the first row of each sub-chunk of data. I want to be able to fill down without going through thousands of rows, deleting the in-between zeros. I did find that if I filtered out the blanks from column D, manually filling down would do that, but if I tried it via a macro, it would put the formula in every row.
Furthermore, the formula in column I takes the minimum from all the rows in each chunk. It varies, it could be two rows in one chunk and fifty in the next. I'd like to see if it's possible to have it fill down only into the appropriate rows AND figure out the correct range to take the minimum from. Again, I'd rather not go through thousands of rows adjusting the range.
Is there any way to do this?