Extract the 7 Largest Donations (plus BONUS VIDEO!)
Oz du Soleil
![Oz du Soleil]()
Oz du Soleil
Microsoft Excel MVP | Excel Instructor on LinkedIn | YouTube: Excel on Fire | Professional Raconteur | Video Editor
This week's challenge asks users to extract the Top 7 Donations from a list and specifically, use the LARGE function. (Download the file and bonus content)
The Case for LARGE
In this situation the source dataset is sorted by the donors' names. Therefore, in order to see the top 7 donations, we can't sort the source data and just look. Also, when source data is updated, LARGE will automatically update.
BONUS CONTENT: Extracting the Top 7 using Dynamic Arrays and Power Query
For those who would like an additional challenge, complete this 2 different ways, using:
- Dynamic Array functions
- Power Query
For those who don't know how, that's perfectly fine. The solution is in the video below:
Where to find Oz
List of Courses by Oz du Soleil in the LinkedIn Learning Library
YouTube: Excel on Fire
Civil Engineer | Microsoft Excel MVP | Sub 4hr Marathoner
4 年Thank you Oz, for those 3 Awesome methods. Here is one more method using Advanced Filter. The following formula is used to return the 7th largest donation with > symbol in front of it.? =">="&LARGE(Donations[Donation],7) Then Advanced Filter is applied to filter the top seven donations. https://www.dhirubhai.net/posts/ajayanand-xlncad_advancedfilter-excel-activity-6649848928080629760-XCm8
Training Program Manager @ Novum LLC | Microsoft ?MVP | MCT Regional Lead (CEE Region)
4 年Thank you for sharing. Is there any alternative function to Large one?
Microsoft Excel MVP. Author, trainer and consultant. Master of 365 Functions, Data Analysis & VBA
4 年A simpler method: 1) without transforming the range into a table 2) without a helper column type the following formula in F3 and drag down all the way to F9 =LARGE($C$3:$C$27,ROW()-2)