PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

CONTENTS

EXCEL FUNCTIONS-LARGE

INTRODUCTION

LARGE FUNCTION is one of the very simple but extremely useful function.

It is found under the STATISTICAL GROUP of the formulas in MICROSOFT EXCEL.

LARGE FUNCTION gives us the value of kth largest number or value i.e. we can find the highest i.e. 1,

second highest, i.e. 2 and so on………upto kth highest number in any given array or range.

 

This function is used a lot when we are making report. Whenever we need to find out the largest number of some range, or second largest or any ranking in a big array, this function is always there for our need.

PURPOSE OF LARGE FUNCTION IN EXCEL

LARGE FUNCTION returns the kth largest number in a given array or range.

PREREQUISITES TO LEARN COUNTA FUNCTION

THERE ARE A FEW PREREQUISITES WHICH WILL ENABLE YOU TO UNDERSTAND THIS FUNCTION IN A BETTER WAY.

 

  •  Basic understanding of how to use a formula or function.
  •  Basic understanding of rows and columns in Excel.
  • Some information about the STATISTICAL terms is an advantage for the use of such formulas.
  •  Of course, Excel software.
Helpful links for the prerequisites mentioned above

SYNTAX: LARGE FUNCTION

The Syntax for the function is

=LARGE( ARRAY OR RANGE, KTH LARGEST NUMBER)

ARRAY OR RANGE is the given array or a range in which we want to find out the largest number.
Kth largest number is the kth largest number in the given array or range. e.g. 1 for the highest, 2 for the second highest and so on…

EXAMPLE:LARGE FUNCTION IN EXCEL

DATA SAMPLE

Let us take a random data to find out the highest and fifth highest number in the given data.

DATA
9471 5235 9247 3801 7987 8875
8416 3732 8216 3765 5077 7348
6486 7423 962 8647 4485 1229
7759 194 8333 237 4360 4144
7296 1740 161 3597 8041 3631
6739 1073 6466 4428 4837 4882
4379 6057 3775 1478 9732 5522
8020 1885 2948 9471 3261 1900
9957 3553 9078 2615 6422 6688
9455 895 9302 4262 6125 8657
666 263 8070 3015 478 6580
1790 2097 210 6192 1193 5339
596 9027 3983 7344 594 567
538 1339 3976 245 5086 4542
3844 1148 6577 4197 180 4674
9410 952 2430 5507 1182 6809

We’ll find out the largest and fifth largest number from the above data using the LARGE function.

LARGE FUNCTION EXAMPLE IN EXCEL
USING LARGE FUNCTION IN EXCEL

STEPS TO USE LARGE FUNCTION-EXAMPLE

STEPS:

1. Place the cursor in the cell and type the following function

2. USE THE FOLLOWING FUNCTION

=LARGE(C7:H22,1) FOR FINDING THE LARGEST NUMBER IN THE DATA

3. Again place the cursor in other cell and enter the following function

=LARGE(C7:H22,5) FOR FINDING THE FIFTH LARGEST NUMBER IN THE DATA

2. Press ENTER, the answer will appear as 9957 and 9455.

 

The answers can be checked manually. We find that all answers are correct.

 

generalized STEPS TO USE COUNTA function

HERE ARE THE STEPS TO USE COUNT FUNCTION
  • USE THE FUNCTION
  • =LARGE(RANGE, KTH LARGEST NUMBER WE WANT)  in the cell where we want the result.
  • Press ENTER and the result will appear.

OTHER WAYS TO REACH THIS ARTICLE

  • WHAT IS EXCEL, HOW EXCEL WORKS, WRITE FORMULA IN EXCEL, EXAMPLE OF USING FORMULA IN EXCEL, ANIMATED EXAMLPE OF USING FORMULA IN EXCEL

LEARN

Encourage us by following at …

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

[email protected]