help with formula

Copper Contributor

Im trying to auto sort a column by descending order, but I need the column next it to move with it, ex one column has names, the next has hours worked.  When the hours are worked I need the names and hours to auto sort


4 Replies


You mention "auto sort".

Do you want the data to be sorted automatically in place, or do you want to return the sorted data in another location?

@Hans Vogelaar 

return to another column, 


best response confirmed by Sergei Baklan (MVP)


Let's say your data are in D2:E500.

In a cell elsewhere:

=SORT(D2:E500, 2, -1)

will return the data sorted descending on hours worked.