I would like to understand how I can make sure that the following two functions produce the same results in terms of ordering.
So, 1st function:
=query(importrange("URL";"'A sheet'!A3:AH");"Select Col33, Col25 where Col17='Yes' AND Col18<>'Yes' order by Col33";1)
2nd function:
=ArrayFormula(query(TO_TEXT(importrange("URL";"'A sheet'!A3:AH"));"select Col33, Col25 where Col17='Yes' AND Col18<>'Yes' order by Col33";1))
Unfortunately, the second function provide results in a different order compared to the first. How can I fix it? I thought that ordering by the same column would solve it. Any suggestions, please?