8 hours 33 minutes
Okay, so first of all, I made small mistake. So this is not here going to be result.
It's going to be Elaine.
So we're looking and in which lane
we're going to s o. We want somebody to be in Lane eight or lane four, and we want the name of that contestant.
And, uh, we know that
or sorry, we're going to determine Lane manually is going to be, like
position. So this guy's going to So we're going to ask, give us the name off the competitors that was in position, for example seven
and is going to written to us that.
way we're going to have a loop. So for I equals 1 to 8,
and then the question is going to ask and we want what we are going to ask. We're going to ask if
the position ah, off the S o. If
what is the name
That is, for example, seventh
on the list.
we're going to ask if
is equal tar off
And if that is the case, then
what we're going to do? We're going toe to toe. Look. Att. The name
So we have here,
we're going to different defined. This results or we're going to put it is a temporary variable.
So, for example, I don't know. This guy has qualified and we want him.
We find him
and way have this results. So we're going to score this result.
we're going to say
So death one
may not actually can do it here.
You don't need block if
and we're going to just say next
And now we're going to go again
through entire list off competitors in the seven filed. Also for I equals 3 to 26.
And then we're going to have if and let's say that
them result is equal
to range. And well, now let's lift where the results are.
So it's f
and what we're now returning.
before I now name
is going to be equal to
Where is the name in cold e. So range
we're a simple
and again next I
and this is how it's done. So we found the result, and now we're going to put the name to that result and it's going to be
the value off the
we just have to put here Sorry.
and here we have to put value
on and everything else is okay,
so we have finalized this module so it's called Final and M to save this close this
and then we're going to just say it's going to be final
and I am
and we have just one parameter also say this was seven
and then it's going to be cool for now
so it's going to be five
on and let's copied
and then just changed this. So it's going to be three
and then the next he's going to be one
and it is going to be too
and we got all of them.
And now what? The only thing left over for us to do
is to put here They're starting number
because that's the way that people helping the athletes in the
or the track
are going to know where to put the trunk.
So we're going to use simple look up command, so we're going to say
and then we're going to open.
And so what we're looking
and then the rain.
And this is wrong.
Yeah. So then look up, Director. So where are we looking Here
and where are we getting the results from?
It's here. We're going to close
get this. And let's just post here some dollar signs
and here here.
So the results say the same. So let's just check if this is working so named 13 6 49 So it's clear
and we just expend this formula. And now we have created two functions that will help us that did help us do this job and with this job combining functions and custom functions, and now everything is ready for the final race. And now we're just waiting for
them to type in the results
and then the raking. So in the finals race, it's obviously for the finish, so ranking it usually happens that two competitors have the same result, so we're not going to do automatic ranking. It's going to be done by we're free or whoever is doing this, uh, manually.
So we have finished this
on dhe. The race can begin
and thank you for your attention in next module and just going to do the short recap off the entire
course. Thank you.
Data Analyst Excel
The Data Analyst Excel Test is a premium Cybrary assessment created by iMocha and intended ...
Monitor a Web App
In this IT Pro challenge, participants get hands-on experience activating server logging and using Application ...
Learn On Demand