Excel - Dropping the Lowest Grade Averaging

Automated way to drop a certain number of lowest or largest numbers then average in one elegant function.

[@bookedtea]

You have saved my life with this video, thank you so much!!

[@EdwardClayMeow]

Thank you for the video! This will help me with calculating advantage and disadvantage in my Dungeons and Dragons adventure.

[@alexkanga4966]

Thank you for this easy reponse.

[@emmahood5530]

super helpful and easy to follow!

[@eddievangundy]

Thank you so much for this video and explanation! Very clear!

[@ImpliedFP]

How can I do this with non-contiguous cells in a ROW?

[@eastbee103]

What if you have 20 values and want the highest 12?

[@eddievangundy4510]

Watch the video!

[@eastbee103]

@@eddievangundy4510 i tried and it didn't work!!

[@eddievangundy4510]

Or should I say, type to 12!

[@RuneRane]

Any way to omit the lowest score and average the rest as a progression? So after 2 tests, take the highest score as an answer. After 3 tests, take the average of the top 2, and so on?

[@gaeller.6601]

Anyone watching this video around final week?

[@jasonbroadway8027]

I wish that you would redo this video; it would be wonderful without the pauses. Thumbs up all the same

[@eddievangundy4510]

It's already wonderful. Pauses give people time to understand.

[@jasonbroadway8027]

@@eddievangundy4510 I respect your viewpoint. In all honesty, I forgot about this review.