LARGE Function, Averaging Top Scores and Over-Thinking

/in /by

This one is about over-thinking. A friend asked how to average the top 3 of 4 scores. I started thinking about Dynamic Arrays, unpivot and maybe the opportunity to show off some Power Query. But when I went with my first and dullest idea, that’s what gave her exactly what she needed.

I used the LARGE function to pick:
LARGE, 1 (largest value)
LARGE, 2 (second largest value)
LARGE, 3 (third largest value)
add them up and divide by 3. DONE! BOOM!

Sometimes the simplest, dullest solution is all that’s necessary.

#LARGEfunction

For an intro to Get & Transform (Power Query) try my Lynda/LinkedIn course:
https://www.linkedin.com/learning/instructors/oz-du-soleil?trk=insiders_28299411_learning
Website: https://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition

My old blog: http://datascopic.net/blog-2-2