Video 00098 Distribute a number across consecutive zeros R.Admin 7 years ago Video 00098 Distribute a number across consecutive zeros # Share this:Print Excel Magic Trick 344: MAX IF & RANK functions without ZerosDateFebruary 23, 2017In relation toLearn ExcelHow to Count only Positive values in a given rangeDateJuly 16, 2014In relation toExcel TipsHow to create 3D Worksheets in ExcelDateSeptember 10, 2014In relation toExcel Tips