P
P
paroletatel2019-02-13 00:47:41
Google Sheets
paroletatel, 2019-02-13 00:47:41

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

1 answer(s)
P
paroletatel, 2019-02-13
@paroletatel

5c646a1cdcf53787290001.png
If someone is interested, here is a script that solves the problem.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question