you will need +1 column to generate sorting sequence used in =QUERY which will return your data
assuming your dataset somehow looks like:
paste this formula in cell F1:
=ARRAYFORMULA(IF(LEN(A:A&B:B&C:C&D:D&E:E),;
MMULT(--(LEN(A:E)>0),;
TRANSPOSE(SIGN(COLUMN(A1:E1)))),;
IFERROR(1/0)))
and then paste this formula wherever you need to:
=QUERY(A1:F,F; "select A, B, C, D, E where F is not null order by F desc"desc"; 0)
if overall visual requires so, you can easily hide the whole F column:
you will need +1 column to generate sorting sequence used in =QUERY which will return your data
assuming your dataset somehow looks like:
paste this formula in cell F1:
=ARRAYFORMULA(IF(LEN(A:A&B:B&C:C&D:D&E:E),
MMULT(--(LEN(A:E)>0),
TRANSPOSE(SIGN(COLUMN(A1:E1)))),
IFERROR(1/0)))
and then paste this formula wherever you need to:
=QUERY(A1:F,"select A, B, C, D, E where F is not null order by F desc")
if overall visual requires so, you can easily hide the whole F column:
you will need +1 column to generate sorting sequence used in =QUERY which will return your data
assuming your dataset somehow looks like:
paste this formula in cell F1:
=ARRAYFORMULA(IF(LEN(A:A&B:B&C:C&D:D&E:E);
MMULT(--(LEN(A:E)>0);
TRANSPOSE(SIGN(COLUMN(A1:E1))));
IFERROR(1/0)))
and then paste this formula wherever you need to:
=QUERY(A1:F; "select A, B, C, D, E where F is not null order by F desc"; 0)
if overall visual requires so, you can easily hide the whole F column:
you will need +1 column to generate sorting sequence used in =QUERY which will return your data
assuming your dataset somehow looks like:
paste this formula in cell F1:
=ARRAYFORMULA(IF(LEN(A:A&B:B&C:C&D:D&E:E),
MMULT(--(LEN(A:E)>0),
TRANSPOSE(SIGN(COLUMN(A1:E1)))),
IFERROR(1/0)))
and then paste this formula wherever you need to:
=QUERY(A1:F,"select A, B, C, D, E where F is not null order by F desc")
if overall visual requires so, you can easily hide the whole F column:
