Search api not finding results consistently
We are doing an all-sheets search via the API and cannot figure out why, on one of the sheets, it is not including certain rows:
The search is:
We are trying to match all rows where the column starts with 97*
The results consistently ignore the cells which end in /H
so it gets
97/145 and 97/D but does not get 97/H
On another sheet it gets all 3....
Can anyone shed any light on this issue?