I am dealing with a sorting problem that I have. Now I do it manually but I would like to do it automatic.
So I have 7 columns and loads of rows.
First I sort all the rows so the biggest value in column A is on top- Then in column B I give the top row a 1, second row a 2 and so on.
Then I sort the all the rows so that the biggest value of column C are in the top. After that I do the same, in column D and row 1 I give that one value 1, next row value 2 and so on.
Then in Column E I add the numbers from column B and D together and sort Column E from so the lowest value are in the top.
After that I take the top 20 Rows and sort once more with column F and the biggest value in the top.
It's a wee bit complicated sorting system and I do it on a regular base.
Dose anybody have a good idea how to do this a bit more simplistic?
So I have now down 5 different sheets, not the prettiest solution.
On the first I have
QUERY('data_2020-06-07'!A1:I998;"select A, B, C, D, E";1)
QUERY('Sort 1'!A1:F249;"select A, B, C, D, E, F order by F desc";1)
QUERY('Sort 2'!A1:G308;"select A, B, C, D, E, F, G order by D desc";1)
QUERY('Sort 3'!A1:I1000;"select * where I <> '' or I is not null order by I Limit 20")
QUERY('Sort 4'!A1:I1000;"select * where E <> '' or E is not null order by E DESC Limit 20")