In this lesson, We are going to explore:
0:00 Getting started.
0:03 INDEX MATCH Exercise (finding the highest and lowest value dynamically).
All explanations are simple and to the point.
Feel free to make your copy of this spreadsheet:
[ Ссылка ]

#GoogleForEducation #GoogleWorkspace #GoogleSheets

If you found this video helpful, give us an old like and share it with some people you think this could be helpful for. And if you're not already a subscriber, make sure to hit the subscribe button and also the notification bell to be notified every time a video is uploaded

Useful Link:
Ben Collins (Google Developer Expert & Data Analytics Instructor)
[ Ссылка ]

Google Sheets training:
[ Ссылка ]

The whole playlist link:
[ Ссылка ]-

Follow us on Pinterest:
[ Ссылка ]

Sound from Zapsplat.com

Apple logo
[ Ссылка ]

Windows logo
[ Ссылка ]

Welcome back, Educators.
Our mission is to find the maximum and minimum scores dynamically.
Let’s start building the parts of the formula, then put them all together.
First, we need to find the maximum score.
Type =MAX(
Click the column header to select the whole column.
Press Enter.
Now we need to know the position of this score in the range.
Type =MATCH(
The search key is the maximum score.
Select the range.
Type 0 to find an exact match.
Press Enter.
Finally, we return the student name and the score using the INDEX.
Type =INDEX(
Select the range.
The row is the MATCH formula that we’ve built.
Set the column to 0 to return the whole row.
Press Enter.
It is time to put it all together.
Copy the MATCH formula without the equal sign.
Delete the cell reference.
Paste the formula.
Copy the MAX formula without the equal sign.
Delete the cell reference.
Paste the formula.
Copy the whole INDEX formula.
Then paste it under Best.
The O Student has got the highest score.
Paste the formula under Worst.
Delete MAX.
Type MIN.
The U Student has got the lowest score.
If we change the score of A Student, for example, the result is updated automatically.
Also, when we add a new student, all is updated automatically.
To spice up the sheet, we have added some custom number formats.
That’s it, have fun. Thanks for watching.
If you like the video, please give us a thumbs up.
And subscribe to our channel.

свернуть