Forum Discussion
Compare text and integers
Hi Elios ,
Have you tried wrapping your formula with ISERROR? This should return TRUE/FALSE and then in the data view you can filter this to just TRUE and inspect the data. Otherwise you might have to clean your data first in Power Query - removing special characters and text from the field.
I agree with PhilipTreacy , a sample data would be very useful. We understand its confidentiality so a dummy sample data would do - remove confidential information or obfuscate it one way or another.
Super UserHi Elios
You can't even copy/paste some examples of your data?
How can I know if you are trying to compare numbers stored as text or actual text strings? Or numbers and text mixed into cells? How do I know which columns are text and which are number?
Your code refers to multiple columns. I can't recreate all of that.
If you are storing numbers as text, convert all of these to numbers.
Regards
Phil