Answer the question
In order to leave comments, you need to log in
How to make it so that when the filter function is executed, the data is sorted in the order in which they were filtered?
The point is that when transferred to the next sheet through the filter function, the line gets to the bottom of the array, and not somewhere else.
That is, I have some kind of array in column A, if I assign a certain value to a cell in column B, then the row that the cell belongs to goes to another sheet. And what I need is that no matter which row and in what order I assign those specific values, those rows always hit bottom when filtered.
Answer the question
In order to leave comments, you need to log in
If someone is interested, here is a script that solves the problem.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question