In the next couple of minutes, we’ll go through a quick guide on how to find the largest number in Excel. Thanks to these simple steps, you’ll be able to find out maximum sales for a certain period of time promptly.
See the video tutorial and transcription below:
See this video on YouTube:
The largest number of a group in Excel can be identified in more than one way. Today, we’ll cover just one, the simplest way, step by step, using this specific data set as an example.
Set the pointer on the cell in which you want the largest number to appear. In this case, we’ll click on C13, where we want to display the maximum sales for Q1.
Go to ‘Home’ tab and look for the button ‘AutoSum’ in the group ‘Editing’. After clicking on the button, a drop-down menu will appear.
Since we’re looking for maximum sales, find and select the function ‘Max’.
Excel will then prompt us to define the area in which we want to look for the maximum value, which is Q1.
You can drag your mouse to select the cell range C3 to C10.
Now click on OK. Perfect!
If you need to look for the largest number in any of the data tables you created, you can follow these steps.
And there’s more to that.
To find out maximum sales in all quarters, just click on the cell containing the function and through its right bottom corner drag the formula through the rest of the cells.
Like this! Easy, right?
Are you interested in:
If you found this tutorial helpful, give us a ‘like’ and watch other video tutorials by EasyClick Academy. Learn how to use Excel in a quick and easy way!
Is this your first time on EasyClick? We’ll be more than happy to welcome you in our online community. Hit that Subscribe button on our YouTube channel and join the EasyClickers!
See you in the next tutorial!