Excel Forum

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.