Excel Magic Trick 912: Conditional Formatting Minimum Value in Row Ignore Zero and #N/A: AGGREGATE

Similar Tracks
Excel Magic Trick 935: MAX Value Between Two Dates: DMAX, MAX-IF-IF, or AGGREGATE Function?
excelisfun
Excel Magic Trick 923: Recorded Macro Basics: Click Button To Move Data To Table On Another Sheet
excelisfun
Excel Magic Trick 914: Top 5, Bottom 5 Excluding Zeros: LARGE, SMALL & AGGREGATE Functions
excelisfun