Formulas and Functions
এই নিয়ন্ত্রণ পরিবর্তন করলে এই পেজটি স্বয়ংক্রিয়ভাবে আপডেট হবে

LARGE

The LARGE function returns the nth-largest value within a collection. The largest value is ranked number 1.

LARGE(value-set, ranking)

value-set: A collection of values. value-set must contain number values, date/time values or duration values. All values must be of the same value type.

ranking: A number value representing the size ranking of the value you want to retrieve. ranking must be in the range of 1 to the number of values in value-set.

Notes

  • A ranking of 1 retrieves the largest number in the collection, 2 the second-largest and so on. Values included in the collection that are the same are ranked together, but impact the outcome.

  • Enclose a non-contiguous value set in curly brackets.

Examples

Suppose the following table contains the cumulative test scores for this term for your 20 students. (The data is organised this way for the example; it would probably originally have been in 20 separate rows.)

A

B

C

D

E

1

30

75

92

86

51

2

83

100

92

68

70

3

77

91

86

85

83

4

77

90

83

75

80

=LARGE(A1:E4, 1) returns 100, the largest cumulative test score (cell B2).

=LARGE(A1:E4, 2) returns 92, the second-largest cumulative test score (either cell B2 or cell C2).

=LARGE(A1:E4, 3) returns 92, also the third-largest cumulative test score because it appears twice (cells C1 and C2).

=LARGE(A1:E4, 6) returns 86, the sixth-largest cumulative test score (order is 100, 92, 92, 91, 90, then 86).

See alsoMAXRANKSMALL
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
কাজে লেগেছে?
অক্ষর সীমা: 250
সর্বাধিক অক্ষর সীমা 250।
আপনার মতামতের জন্য ধন্যবাদ।
Morty Proxy This is a proxified and sanitized view of the page, visit original site.