How to select highest three or lowest three values in Microsoft Excel Using Formula
34.4 هزار بار بازدید -
6 سال پیش
-
How to select highest three
How to select highest three or lowest three value in excel 2010 using formula?
In this video we are about to learn how to find top 10/5/3 values or lowest 10/5/3 values in Microsoft Excel 2010 using formula. This is a beginners excel tutorial.
In the previous excel tutorial I showed you how to find the highest and lowest values in excel. Here is the link to that: How to select the highest or lowest v...
Let’s get started.
Step 1: Open workbook
Step 2: Write formula
To find top 3 highest value write: =LARGE(A2:A15,1)&", "&LARGE(A2:A15,2)&", "&LARGE(A2:A15,3)
To find top 5 highest value write: =LARGE(A2:A15,1)&", "&LARGE(A2:A15,2)&", "&LARGE(A2:A15,3) &", "&LARGE(A2:A15,4) &", "&LARGE(A2:A15,5)
To find top 10 highest value write: =LARGE(A2:A15,1)&", "&LARGE(A2:A15,2)&", "&LARGE(A2:A15,3) &", "&LARGE(A2:A15,4) &", "&LARGE(A2:A15,5) &", "&LARGE(A2:A15,6) &", "&LARGE(A2:A15,7) &", "&LARGE(A2:A15,8) &", "&LARGE(A2:A15,9) &", "&LARGE(A2:A15,10)
To find the lowest 3 value write: =SMALL(A2:A15,1)&", "&SMALL(A2:A15,2)&", "&SMALL(A2:A15,3)
To find the lowest 5 value write: =SMALL(A2:A15,1)&", "&SMALL(A2:A15,2)&", "&SMALL(A2:A15,3) &", "&SMALL(A2:A15,4)&", "&SMALL(A2:A15,5)
To find the lowest 10 value write: =SMALL(A2:A15,1)&", "&SMALL(A2:A15,2)&", "&SMALL(A2:A15,3) &", "&SMALL(A2:A15,4)&", "&SMALL(A2:A15,5) =SMALL(A2:A15,6)&", "&SMALL(A2:A15,7)&", "&SMALL(A2:A15,8) &", "&SMALL(A2:A15,9)&", "&SMALL(A2:A15,10)
A2:A15 is the data range from where you are selecting highest and lowest value. Change it according to your need.
if you need to find top 11 then just add &", "&LARGE(A2:A15,10) to your code
if you need to find lowest 11 then just add &", "&SMALL(A2:A15,10)
Hope it helps. Thanks for watching.
If you like this tutorial, please subscribe: https://goo.gl/uL8fqQ
#exceltutorial #TopValues #Formula
Here goes the most recent video of the channel: http://bit.ly/2oXmqsb
Playlists:
Advance Excel Tutorial: https://goo.gl/ExYy7v
Excel Tutorial for Beginners: https://goo.gl/UDrDcA
Excel Case: https://goo.gl/xiP3tv
Excel VBA Programming Course: http://bit.ly/excelvbacourse
Social media:
Facebook: Facebook: excel10tutorial
Twitter: Twitter: excel10tutorial
Blogger: https://excel10tutorial.blogspot.com
Tumblr: Tumblr: excel10tutorial
Instagram: Instagram: excel_10_tutorial
Hubpages: https://hubpages.com/@excel10tutorial
In this video we are about to learn how to find top 10/5/3 values or lowest 10/5/3 values in Microsoft Excel 2010 using formula. This is a beginners excel tutorial.
In the previous excel tutorial I showed you how to find the highest and lowest values in excel. Here is the link to that: How to select the highest or lowest v...
Let’s get started.
Step 1: Open workbook
Step 2: Write formula
To find top 3 highest value write: =LARGE(A2:A15,1)&", "&LARGE(A2:A15,2)&", "&LARGE(A2:A15,3)
To find top 5 highest value write: =LARGE(A2:A15,1)&", "&LARGE(A2:A15,2)&", "&LARGE(A2:A15,3) &", "&LARGE(A2:A15,4) &", "&LARGE(A2:A15,5)
To find top 10 highest value write: =LARGE(A2:A15,1)&", "&LARGE(A2:A15,2)&", "&LARGE(A2:A15,3) &", "&LARGE(A2:A15,4) &", "&LARGE(A2:A15,5) &", "&LARGE(A2:A15,6) &", "&LARGE(A2:A15,7) &", "&LARGE(A2:A15,8) &", "&LARGE(A2:A15,9) &", "&LARGE(A2:A15,10)
To find the lowest 3 value write: =SMALL(A2:A15,1)&", "&SMALL(A2:A15,2)&", "&SMALL(A2:A15,3)
To find the lowest 5 value write: =SMALL(A2:A15,1)&", "&SMALL(A2:A15,2)&", "&SMALL(A2:A15,3) &", "&SMALL(A2:A15,4)&", "&SMALL(A2:A15,5)
To find the lowest 10 value write: =SMALL(A2:A15,1)&", "&SMALL(A2:A15,2)&", "&SMALL(A2:A15,3) &", "&SMALL(A2:A15,4)&", "&SMALL(A2:A15,5) =SMALL(A2:A15,6)&", "&SMALL(A2:A15,7)&", "&SMALL(A2:A15,8) &", "&SMALL(A2:A15,9)&", "&SMALL(A2:A15,10)
A2:A15 is the data range from where you are selecting highest and lowest value. Change it according to your need.
if you need to find top 11 then just add &", "&LARGE(A2:A15,10) to your code
if you need to find lowest 11 then just add &", "&SMALL(A2:A15,10)
Hope it helps. Thanks for watching.
If you like this tutorial, please subscribe: https://goo.gl/uL8fqQ
#exceltutorial #TopValues #Formula
Here goes the most recent video of the channel: http://bit.ly/2oXmqsb
Playlists:
Advance Excel Tutorial: https://goo.gl/ExYy7v
Excel Tutorial for Beginners: https://goo.gl/UDrDcA
Excel Case: https://goo.gl/xiP3tv
Excel VBA Programming Course: http://bit.ly/excelvbacourse
Social media:
Facebook: Facebook: excel10tutorial
Twitter: Twitter: excel10tutorial
Blogger: https://excel10tutorial.blogspot.com
Tumblr: Tumblr: excel10tutorial
Instagram: Instagram: excel_10_tutorial
Hubpages: https://hubpages.com/@excel10tutorial
6 سال پیش
در تاریخ 1397/10/19 منتشر شده
است.
34,464
بـار بازدید شده