How to sort a range created by formulas?

Question

Google Sheets

There was a problem in range sorting. The bottom line is that a certain data array is constantly filled with previously written formulas, for example, (A1=B1). And there was such a problem of the inability to sort the range formed by such formulas. The cells simply do not change places according to the given sorting logic. Please tell me how to solve this problem?

Answer 1

https://support.google.com/docs/topic/3105422?hl=en