Forum Discussion
Is there a way to compare whether two cells are equal in the numerical value, ignoring the text?
Is there a way to compare whether two cells are equal in the numerical value, ignoring the text? For instance, I want =2=2 years to return TRUE because the 2’s are equal to each other.
2 Replies
- The only way is to clean your strings by extracting the numerical value first then comparing them.
There are many ways to extract a number from a string. There are no cell references in =2=2 years.
