I wanna show you a few ways to auto increment or automatically increment or increase a number in a cell and in a column we can put a number here, like in a two, we can put the number one. And in a three we can do equals this plus one. And if we copy paste this all the way down, you'll see that they. Increase. But how do we do this automatically? We don't wanna have to copy paste this all the way down. Each time we add someone's name, we can put equals if blank if is blank B two, then if that's false, meaning it's not blank, we can put the number one and now in a two plus one. We'll take that and do if is blank, and we'll make sure we're selecting B three comma, comma, and then

we'll put that a two plus one. So now we're only going to do this if there is a employee in column B. So let's go all the way down. Let's copy paste this all the way down. And we'll see that all of these are, now, if this one is blank, don't do anything. That's what this middle part is doing. These two, right between these two commas we're saying just don't put anything. So now put Quint and we have a number every time. There's another formula that we can do here, which is equals sequence , and the sequence can be the number of rows count A, B, two, colon B, which is the entire B column, and it's only gonna count when it's got some value.

Value. We're only gonna do one column. We're gonna start at one, we're gonna step one, meaning we're gonna increment each number by one. And there, if we do this all the way down, see, we don't have formulas here anymore. We don't need these anymore. We can delete those and we'll automatically increment if we add someone's name. And all we need is this one formula here. You are watching better sheets here on YouTube. Make sure you check out this video or this video and subscribe right now to get more tips, tricks, how tos, get more out of your Google sheets than you ever have before. I'm excited to be making a ton more videos here. Ask me questions down in the comments and I will answer them in future videos. But for right now, right here, one of these videos is gonna be your next Google sheet.