6

What am I missing here?

=QUERY('STUDENT SIGN IN'!A1:K, "select K,C,F,D,E,B ORDER BY A DESC, B"

The data is sorting on Column A, but doing nothing to Column B.

Since that didn't work, I also tried building it this way, however I haven't done a vested formula in sheets before. This formula is causing a #ERROR:

=SORT((QUERY('STUDENT SIGN IN'!A1:K, "select K,C,F,D,E,B)")Select 1,TRUE,2,FALSE))

Kristi Miller
  • 61
  • 1
  • 1
  • 5

2 Answers2

10

If the order for ColumnB is not changing then it is presumably already in the default (ascending) order within each ColumnA value. To reverse this as well as the order of ColumnA you might try:

=QUERY('STUDENT SIGN IN'!A1:K, "select K,C,F,D,E,B ORDER BY A DESC, B desc")
pnuts
  • 58,317
  • 11
  • 87
  • 139
0

Question: =QUERY('STUDENT SIGN IN'!A1:K, "select K,C,F,D,E,B ORDER BY A DESC, B"

Answer: =QUERY('STUDENT SIGN IN'!A1:K, "select K,C,F,D,E,B ORDER BY A,B DESC")

Both will be ASC or DESC

Question: =SORT((QUERY('STUDENT SIGN IN'!A1:K, "select K,C,F,D,E,B)")Select 1,TRUE,2,FALSE))

Answer: =SORT(QUERY('STUDENT SIGN IN'!A1:K,"select K,C,F,D,E,B"),1,TRUE,2,FALSE)

Each One can Be ASC Or DESC

Saa
  • 151
  • 1
  • 2