just want to ask if anyone may can help me with this one: I’m looking for an easy way to search for an exact number in an array.
I have this Table “User Air ID” with lots of numbers like “35, 65, 76, 654”. What I want to do to filter a list, I want to make a “filterByFormula” looking for entries containing #65.
When using the functions FIND and SEARCH I not only get the results for number 65 but also for rows containing number 654. That’s a correct results as 65 is also part of 654. Does anyone know how to set up the correct formula for ignoring other numbers than just the 65?