Excel Forum
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



Excel Magic Trick 687: Exclude Values Less Than Zero From Non-Contiguous Ranges - Amazing!


Amazing use of the functions FREQUENCY, LARGE, ROW, INDIRECT to exclude values less than or equal to zero from non-contiguous ranges in order to make calculations inside the functions MEDIAN, MODE, AVERAGE, STDEV functions. Amazing Trick from Pgc01 from the Mr Excel Message Board
Download file: http://flightline.highline.edu/mgirvin/ExcelIsFun.htm





Got a Question? Ask it Here in the Forum.