Excel Data AnalysisLesson 46Free preview
Excel Top Bottom Rules
This lesson is part of Excel · All levels
Summary
Top/Bottom Rules mark cells based on their position in a data set, not a fixed benchmark value. You can highlight top 10 items, top 10%, bottom 10 items, or above average scores. It's perfect for finding best-selling, top-performing students, or metrics that are higher than average.
Key points
- Top/Bottom Rules based on relative position in the data
- Top 10 items marked the top ten values
- The top 10% marks the top 10% of the cell count
- Above Average marks the cell above the mean range
Full lesson
Code examples and quizzes
Full lessons, code examples, and quizzes are available to subscribers. 5 questions.