I want to get the total number of rows where the density percentage is more than 60% but less than 90%.
I am doing this through VBA to add filters on density column (percentage format):
With ActiveSheet
.AutoFilterMode = False
With .Range("A3:EB3")
.AutoFilter
.AutoFilter Field:=98, Criteria1:=">9"
.AutoFilter Field:=99, Criteria1:=">2014"
.AutoFilter Field:=23, Criteria1:=">60%"
.AutoFilter Field:=23, Criteria1:="<90%"
End With
End With
But auto filter displays no rows