ExcelBanter

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - MODE (https://www.excelbanter.com/excel-discussion-misc-queries/145328-mode.html)

shabbyshic

MODE

=MAX(FREQUENCY(IF(D2:D254=0,COUNTIF(OFFSET(D2,,,RO W(INDIRECT("1:"&ROWS(D2:
D254)))),"<"&0)),ROW(INDIRECT("1:"&ROWS(D2:D254)) )-1))

After calculating the max frequency of "0" occuring in a string of data, I
needed the ability to return the average occurrence of the "0"s.

All times are GMT +1. The time now is 10:37 PM.