Project 7: Sort and Filter Logic with RANK.EQ, COUNTIF and LARGE
This lesson is part of the course
In this lesson
Suggested time: 10 minutes. You rank Fernhill's products by units sold, count products by category and by a threshold, and build a top-3 list that re-sorts itself.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Project 1: Cell References and a Tax-Rate Cell Locked
- Project 2: SUM, AVERAGE, COUNT, MIN and MAX Locked
- Project 3: CONCAT, PROPER, UPPER, LEFT, RIGHT and LEN Locked
- Project 4: IF, Nested IF and IF with AND Locked
- Project 5: Number Formats and Conditional Formatting Locked
- Project 6: Create and Modify Charts Locked
- Project 7: Sort and Filter Logic with RANK.EQ, COUNTIF and LARGE Locked
- Project 8: Timed Mixed Project (20 Minutes) Locked