Extract the 7 Largest Donations (plus BONUS VIDEO!)
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
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.linkedin.com/posts/ajayanand-xlncad_advancedfilter-excel-activity-6649848928080629760-XCm8
Thank you for sharing. Is there any alternative function to Large one?
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)