Skip rows in excel

Question

I'm doing a budgeting spreadsheet in excel. Along the top, the columns are headed for each budget item I need to account for. The rows are each labelled with dates on a daily basis. At the end of each week I have a row that balances the totals for each week.

My question is this, I want to be able to fill down the date column and any other columns that have identical or pattern data, but I'd like to skip the total balance row that I have at the end of each week, thus maintaining the date sequence.

Any ideas?

Answer 1

I'll caveat this by saying I'm not sure how your data is set up (nor where blank rows are, etc.), so if it is horribly wrong that is my excuse :) One way that you could do it (at least with the date - not sure what your other columns are like) is to populate the first row of the data with the column, the second with an actual date, and then drop this formula in the third row (assuming it is in column A):

=IFERROR(IF(WEEKDAY(A2)=7,"Total",A2+1),A1+1)

This assumes that you are starting the week on a Sunday (you can toy with the WEEKDAY(A2)= number to get it how you want). General idea is that it uses your first date as the starting point, increments the date if the previous date isn't the end of the week, but if it is then writes Total. Then for the next row, if taking the WEEKDAY() causes an error (as it will with string Total), it takes the row above that an increments by one. Not sure if this gets you want you want, but hope it points you in the right direction!

Answer 2

I don't use autofill for sequences, instead I use a formula that adds one to the cell containing the previous value.