I have this table, which is a ranking, the values are updated automatically (data gathered from other files). What I want is that every time this values are updated the ranking automatically updates also.EXAMPLE:Table nowTable after one update, Frank has the higher score nowI don't want to go to the sort menu every time, is this possible? thanks!
Google spreadsheet sort auto update
google spreadsheets;sorting;google spreadsheets query
This duplicates data (or since the source for the query is itself imported, even triplicates) but does seem to provide automatic resorting as data input changes:   =query(A1:B5,Select * order by B desc)