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.

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

Thanks (0)

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

Thanks (0)

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

Thanks (0)

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

Thanks (0)

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

Thanks (0)

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)