 There is a request I got on YouTube. This person has an interesting request. They want to be able to populate a cell with a number and Then have cells below that auto populate With the number of cells equal to the number that they had entered So I'm going to move this so you can kind of follow along Make this a little bit bigger so you can see there you go. They want that in C So here we'll have something like enter number and this they wanted to be a list. So we'll go to data data validation allow a list Here let's just go zero one two three four five six seven eight nine. We'll go to ten You could keep going of course and So here we have a drop-down list that we can enter a number Now we're going to need to test against that number and so there's a few ways we could do that The one I'm going to suggest is Let's build it on row. So here I can type equals row And that's going to tell me that I'm in row two. I could have also Put some other cell in here and then that would tell me. Oh, that's row ten I'm going to hit control Z. So we're back to just equals row So we're now testing that this is row two and then what we could do is just subtract one Because we're actually starting row two would be our row one because we're using row one for that number entry Cool. So that's that's one and we can drag it down to make sure that works sure enough this row minus one that works Well, I'm going to delete that and then what I'm suggesting is that we now take this number and compare it against this number To know if it should be populated or not and so to do that I'm going to put an if here so equals if and if that Formula and I'm going to go ahead and put this whole thing in parentheses You actually don't need to but I think it makes it easier to follow row minus one if that's less than or equal to whatever this number is Then we want to say yes Let's put that in quotes. So it just says yes, and if not, I'm going to do two quotes. So nothing shows up All right. Now, we don't want this C1 to drag with us So I'm going to use F4 to put dollar signs on there or you could just enter the dollar signs hit enter That says yes drag it down to here great. So three is yes 10 Yes 8 great and maybe yes isn't instructive enough for you Maybe you want something more clear in there what you could do is take this function and Replace that yes with the actual function. So it'll show you the number of the row. So you enter 8 There's 8 or 10. There's 10 going down I hope that that was helpful