Forum Discussion
Advocate IIFiltering text with > or <
I think the solution would to use power query to remove the decimal points and possilby store the verison number as a whole number in a column. That way you are just dealing with numbers like, 1110, 1101 and 1102 as the trailing zero shouldn't matter for the comparison you are trying to make.
Super UserI think the solution would to use power query to remove the decimal points and possilby store the verison number as a whole number in a column. That way you are just dealing with numbers like, 1110, 1101 and 1102 as the trailing zero shouldn't matter for the comparison you are trying to make.
mateoc15Because I'm only concerned about a version 11+ that should be alright, two digits there is good. Won't cause a problem until we get to version 99+, and I won't be around for that. Thank you.