Number Rows If Blank Rows in Google Sheets

0:00 Here's an interesting trick to number rows, even if you have blank rows, so we want to number these 1, 2, 3, but if we add something here, we want to , renumber this, 2, 3, 4. Now this is really easy if there's no blanks. If there's no blanks, we just can do row, Minus one, we could copy paste this all the way down. We could even do equals sequence . Ten rows, one column, start at one, step one, and just get one through ten, but we have these blanks. So how do we deal with those? We're going to need to show the number only when there's something there. So we'll start with if, isBlank, and we'll use b2 because that's the, uh, cell that we want to know is it blank or not. We don't want to do anything if it actually is blank so we need two How to Iterate Counting Blank Cells in Google Sheets Beginners Guide to Using Index, Row, and Column | Simply useful Google Sheets Formulas Automate Move Blank Rows How to Automatically Number Rows in Google Sheets

0:46 commas and then what to do if it is not blank we want to number it we'll do count a and here's the little bit of a trick we do dollar sign b dollar sign two colon b two there's no dollar signs in the second part of that. Now, if we copy paste, you'll notice the B2 that is not with the dollar sign will change to B3. Copy paste again, now it's B4. and we're now numbering when we have no blinks. So if we delete coffee, it automatically re numbers these. This is a pretty cool little trick. If you're looking for more tips, tricks, tutorials, or even some templates or automations to add to your templates, subscribe here on YouTube to BetterSheets. How to Iterate Counting Blank Cells in Google Sheets Figure Out Frequency of Numbers How to Auto Increment Numbers in Google Sheets