» Returning the Nth Largest / Smallest Values in a Range
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
Problem: Finding variously ranked numbers in List1. For example, the second largest number, the third smallest number, and so on.
Solution:
Use the LARGE and SMALL functions in the following formulas:
To find 2nd largest number enter:
=LARGE(A2:A8,2)
To find 3rd smallest number enter:
=SMALL(A2:A8,3)
Book Store:
Recommended Books:
- The 11 Immutable Laws of Internet Branding
- The Essential 55: An Award-Winning Educator's Rules for Discovering the Successful Student in Every Child
- The 22 Immutable Laws of Branding
- Flipping Properties: Generate Instant Cash Profits in Real Estate
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
- The Ernst & Young Business Plan Guide
No comments have been submitted.
