Hi Guys,
I need to calculate the mode of a column, but allow for a 25 unit margin of error above and below. My current array formula is
=MODE(IF(AZ3=$Q$30:$Q$5000,$E$33:$E$5000))
With the current formula if there is no mode, it returns #N/A. Any ideas how to build in this leeway? Colums AW...