# Identifying Largest and Smallest Values in an Excel List

Tags
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.

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

### Replies

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)
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)
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)
By Sai krishna
Jun 26th 2015 01:12

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

Thanks (0)
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)
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)