How to select the highest or lowest value in excel using function.
In this quick tutorial you will learn how to find highest and lowest value in Microsoft Excel 2010 with function.
Greetings and welcome to Excel 10 Tutorial. I am using Microsoft excel 2010 and I am going to use Excel functions in this tutorial. Let’s get started.
Step 1: Open workbook.
Step 2: Select a cell and write =Max(Cell value) to find the highest number.
Step 3: Select a cell and write =Min(Cell value) to find the lowest number.
Step 4: Press “Enter”
That’s it you got the highest and lowest values in Microsoft excel 2010 using two functions. For your convenience here are the functions.
Max Function: =MAX()
Min Function: =MIN()
Inside the () you’ll have the write the cell value from where you are searching for the highest/lowest value.
Thanks a lot. Please share this video with your friends and subscribe the channel: [ Ссылка ]
#excelfunction #excel10tutorial #MaxMin
-----------------------------------------------------------------------------------------------------------
Support Us: [ Ссылка ]
-----------------------------------------------------------------------------------------------------------
Here goes the most recent video of the channel: [ Ссылка ]
Playlists:
Advance Excel Tutorial: [ Ссылка ]
Excel Tutorial for Beginners: [ Ссылка ]
Excel Case: [ Ссылка ]
Excel VBA Programming Course: [ Ссылка ]
Social media:
Facebook: [ Ссылка ]
Twitter: [ Ссылка ]
Blogger: [ Ссылка ]
Tumblr: [ Ссылка ]
Instagram: [ Ссылка ]
Hubpages: [ Ссылка ]
How to select the highest or lowest value in excel using function
Теги
Learn how to find highest and lowest value in Microsoft Excel 2010 with functionSelect Top value in exceFind lowest value in excelexcel10tutorialSelect lowest value in excelHow to select the highest or lowest value in excel using functionGet highest and lowest values in Microsoft excelFind highest value in excelFind highest value with Max functionExcel functionExcel tutorialsExcel 2010 tutorialMicrosoft excelMax function in excelMin function in excel