Saturday, 5 September 2015

How to Show Largest Value In MS.Excel


With the help of LARGE function we can show largest value. It may be  1st,2nd,3rd etc largest value.
In this image 1st largest value is return.









If we want to show 2nd largest value then below's image is an example.Formula will be same,we just have to change last value of formula like,1 will return 1st largest and 2 will show 2nd largest value.


No comments:

Post a Comment