Tag Archives: LARGE

SUM the last X non-blank values in a column in #Excel

Posted on September 27, 2020 by MF

Got this question from my brother. He is tracking scores for game he plays with friends. The game can be played with up to four players. He wants a formula to calculate the last 10 scores of a player. He … Continue reading →

Rate this:

Posted in Excel in Action, Formula | Tagged , , , | 2 Comments

Highlighting Top X values with Icon Set in #Excel

Posted on December 22, 2018 by MF

This post is a continuation of the previous one – Highlighting Top X values with Conditional Formatting in #Excel So I will go straight to the point.  For background information, please read the previous post. 🙂 To insert Icon Set Select … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment

Highlighting Top X values with Conditional Formatting in #Excel

Posted on December 15, 2018 by MF

Well… think this topic is too simple?  How about doing this with a dropdown menu to make the Top X a dynamic one? with Icon Set? You may download a Sample File to follow along. Let’s start with the basics … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , , , , | Leave a comment