Return to Answer

added 15 characters in body

Source Link

edited Feb 6, 2022 at 19:16

You can get that with query(), like this:

=query( 
  sort( { row(A51) - row(A$2:A51) + 1, A$2:A51 }, row(A$2:A51), false ),  
  "select Col1 where Col2 > 655 limit 1",
  0 
)

You can get that with query(), like this:

=query( 
  sort( { row(A$2:A51), A$2:A51 }, row(A$2:A51), false ),  
  "select Col1 where Col2 > 655 limit 1",
  0 
)

You can get that with query(), like this:

=query( 
  sort( { row(A51) - row(A$2:A51) + 1, A$2:A51 }, row(A$2:A51), false ),  
  "select Col1 where Col2 > 655 limit 1",
  0 
)

Source Link

created Feb 6, 2022 at 17:15

You can get that with query(), like this:

=query( 
  sort( { row(A$2:A51), A$2:A51 }, row(A$2:A51), false ),  
  "select Col1 where Col2 > 655 limit 1",
  0 
)