I keep getting a Div/0 error with this formula
=FILTER('Job Register'!A:AT,(ISNUMBER('Job Register'!AT:AT))*(('Job Register'!AT:AT<-0.02)+('Job Register'!AT:AT>0.02)))
My column AT has both blank cells and #div/0! cells.
Any help would be appreciated, Thanks
=FILTER('Job Register'!A:AT,(ISNUMBER('Job Register'!AT:AT))*(('Job Register'!AT:AT<-0.02)+('Job Register'!AT:AT>0.02)))
My column AT has both blank cells and #div/0! cells.
Any help would be appreciated, Thanks