Identifying Largest and Smallest Values in an Excel List

istock_000000625446_large.jpg

Spreadsheet
jasantiso_iStock_spreadsheet
Share this content
Tags
6
Periodically, you may wish to rank a series of items within an Excel spreadsheet. Many users often rely on sorting data in ascending or descending order. I'll describe an alternative that uses the LARGE and SMALL functions to create an ordered list of whatever you'd like to rank. You're probably already familiar with the MIN and MAX functions in Excel, which return the smallest or largest value within a list, respectively. As shown in Figure 1, MIN indicates the smallest value is 191, and the largest value is 958. MIN and MAX are limited to the single smallest or largest values respectively, but LARGE and SMALL allow you to return the second largest or third smallest value if you choose. I'll explain these functions in a moment, but first let's explore MIN and MAX.

Please Login or Register to read the full article

To access all of the content on our site, register (it's free!) or login to your existing account.

Replies

Please login or register to join the discussion.

avatar
By InLoveWithExcel
Jun 26th 2015 01:11

Is it legal in the state of Nevada to marry a software application? If so, Excel, will you marry me?

Thanks (0)
avatar
By vince
Jun 26th 2015 01:11

help, how will I incorporate countif in the above formula? I mean to list down all the items with the same sales

Thanks (0)
avatar
By Joshep
Jun 26th 2015 01:11

Good Day, If I have 2 names bananas and diferent sales, How I can sum and select the top 5??

Thanks (0)
avatar
By Sai krishna
Jun 26th 2015 01:12

HOW TO COMPARE OR FIND THE LESS VALUES IN THREE COLUMNS COMPARISION

Thanks (0)
avatar
By Daniel
Jun 26th 2015 01:12

Hi, if I have 2 of the same numbers in row B how can I over come this ?

Thanks (0)
avatar
By Stef
Jun 26th 2015 01:12

I have data which consists of reversal journals. I want to sort with positive number first then corresponding negative. How do I do that?

Thanks (0)