Zakir Asks: Find First Car in a Row

<div>0:00 He's a care. So the question was, um, you have this function Learn about functions and how they can streamline your data analysis. Opens in new tab that you are looking to know when does a car start and how many cars start?<br>0:11 So, uh, I think we gotta do two things. One, we gotta flip your idea of this column. I don't think that's gonna get us the information because the, the relation is actually the car one along this road.<br>0:26 Where Understand how to filter data using the WHERE clause in queries. Opens in new tab does it start? Car at car two. Where Understand how to filter data using the WHERE clause in queries. Opens in new tab does it start? Car three, where Understand how to filter data using the WHERE clause in queries. Opens in new tab does it start? And then once we have that information, we can add up these.<br>0:33 So this, this car starting, you don't need this.

Um, and total start will, we'll get that in a second. So I did index match Discover how INDEX and MATCH work together for powerful lookups. Opens in new tab here, um, to figure out basically, which is the first, uh, non blank one See is blank.<br>0:53 False. So, um, we can use index Explore the INDEX function and its role in retrieving data from arrays. Opens in new tab and what we're doing is we're indexing this row. So when we find out what's the first non blank one here, um, we'll go pop up here.<br>1:07 So we did that all here. So now we have all these cars. We know when did they start? Then we can go here and say, okay, equals counts if, um, and we're gonna count this range Get to know what ranges are and how they are used in formulas. Opens in new tab actually be three.<br>1:24 Yeah. Um, and the tering is gonna be the name here.

So we can have zero there. Now we wanna stick the B column.<br>1:35 Same. We wanna stick the two. Okay, So now we have the answer. Total start is 0, 1, 2, 0. Okay. So now if you change any of this, like if you add more periods, just uh, change the uh, this here and this here.<br>1:58 Um, if you add more down more cars than in here, you would have to change this formula Review the syntax rules that govern formula creation in spreadsheets. Opens in new tab . Hopefully that helps.</div>