Fresh Excel Tips

Quick and Easy Excel Tips and Tutorials

How to Use the LARGE function to find the highest values in Excel
Addicted To Cialis Medrol Packs Buying Viagra Over The Internet Bio Brite Sun Alarm Can Plavix Substitute For Coumadin Viagra And Affiliate Breast Augmentation Discussion Boards Natural Herb For Lasix Plavix And Inr Breast Enhancement Capsules Ultra Curves Estrogen Coral Calcium Supreme 240 Zelnorm Affects Birth Control Patti Labelle Clas Of The Choirs Benefit Of Coral Calcium Hgh Effects On Teens Buy Hgh Buy Hgh Buy Hgh Anoretic Cardura Medication Leukeran Pet Medication Levitra For Females Out Of Court Settlement For Viagra Prednisone Prescribing Lamictal Bipolar 1 Aleve Pregnancy Coumadin Anticoagulation Drug Interaction Cipro Zoloft And Sudafed Plavix And Aspirin Interactions Use Zovirax For Effective Herpes Treatment Medrol Dose Pack And Crohns Synthroid Hot Flashes Geodon Im Cialis Manufacturer Jewish Purim Cookies Squill And Lipitor Synthroid Destroys Thyroid Advil Or Motrin Atarax Prescribing Information Flonase For Kidney Stones Lotrisone Cr 30 Mg Cost Of Viagra In The Philippines Can I Take Prozac At Night Zoloft Cleft Palatte Benefit Of Coral Calcium 0a North Beach Pizza Soma San Francisco Viagra Over Counter Herb Valproic Depakote Hypothalmus Hoodia Tlc Lasix Veterinary Dose Of Tramadol Neurontin Use

To determine the highest value in a list, we used the MAX function. To find out multiple high values of a range, the LARGE function can be used. This function returns the nth highest value in a set of data.

LARGE(array, n)
array: Array or range of numerical data in which we want to find the nth highest value.
n: The position from the highest in the array or range of data to return.

To determine the three highest values of a range:

  1. In cells A2:C10 type any values from 0 to 99.
  2. Number cells A12, A13, and A14 with 1, 2, and 3.
  3. Select cells B12:D14 and type the following formula: =LARGE(B$2:B$10,$A12).
  4. Press Ctrl+Enter.

How to Use the LARGE function to find the highest values in Excel

How to Use the LARGE function to find the highest values in Excel
  1. Use the INDEX, MATCH, and LARGE functions to determine the best salesperson
  2. How to Use the PRODUCT function to multiply conditional values
  3. How to check for invalid values using the TYPE function in Excel
  4. Use the SMALL function to find the smallest values in Excel
  5. How to Use the RAND function to generate random values in Excel

Article Information

Category
Formula and Function Examples

Tags
,

Trackback URI

Comments RSS


Leave a Reply

← Using the PROPER function to change first letters to uppercase
How to Separate Cell Values Using the Trim Function in Excel →