Hey guys,
I have a column that contains numerical information (the fields are "general"). Some of the numerical fields have either ">, >=, <, <=" before the number. However, based on the data filtering I am doing, these prefixes affect the search.
How would I go about removing these prefixes? or somehow still manage to count the data with the prefixes?
Example of the filter code I have:
With ws1
.Activate
DataDate = Application.WorksheetFunction.CountIfs(Range("Q:Q"), ">60", Range("R:R"), ">=" & Date12Months)
End With
Bookmarks