LARGE Function, Averaging Top Scores and Over-Thinking скачать в хорошем качестве

LARGE Function, Averaging Top Scores and Over-Thinking

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/ins... Website: http://ozdusoleil.com My book: Guerrilla Data Analysis 2nd Edition http://www.amazon.com/Guerrilla-Analy... My old blog: http://datascopic.net/blog-2-2