Count non-empty cells and find nth largest/smallest values.
“COUNTA, COUNTBLANK, LARGE & SMALL” is part of Excel Zero to Hero — Complete Master Course. Free preview lessons are open to everyone; the remaining lessons are for enrolled learners.
Module 6: Advanced Lookups
Module 7: Dates & Dynamic Arrays
Module 8: PivotTables & Charts
Module 9: Advanced Formulas
Module 10: Analysis & Power Tools
Module 11: Power Pivot & VBA
Module 12: Automation & Capstone
