From the course: Excel Weekly Challenge

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

List the top seven donation amounts

List the top seven donation amounts - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

List the top seven donation amounts

“

- [Instructor] Okay, here we have a list of donations and donors. What we want in column I is a list of the top seven donations. This is when you'd use the large function just to give you a little hint, all right? Pause the video, get that list of the top seven donations, come back, and I will show you how to use that large function if you don't already know how. All right, you're back. Here's how we're going to do it. We're going to start by putting one, two, three, four, five, six, seven. There we go. Now, put this data into tables. Here we go. Cursor in the data set, format as table, let's pick this nice orange color. Okay. Don't need to fill the bubbles. Now, the large function. Equals large, open parenthesis, what is our array? It is this column here with the donation amounts in it. Comma, and our K value. We want the first largest. Enter. It's 1000 bucks from Garfield Chavez. What a kind, kind…

Contents