Excel: Using the LARGE() and SMALL() Functions

If you have been using Excel you have probably come across the MAX and MIN functions for finding the highest or lowest values in a range. But what if you want to find the second largest or third and so on, or what if you want to find the second smallest and so on. Well for that you have the LARGE and SMALL function.

This can be very useful if you want to find out who came second or third, aside of course finding out who came first. You could use MAX for finding out who came first but you could also using LARGE too.

Here in this video I show you how to use both of these and a quick reminder of how MAX and MIN work.

About garysch

A bit of a techno nut who likes sharing what I know about technology, especially with those who struggle with it. Also through my podcast www.jargonfreehelp.com
This entry was posted in Excel, excel function, Excel Functions, Microsoft 365, Microsoft Office and tagged , , , , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s