help with formula

[zcaldwell32]

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

[#2]

@zcaldwell32 

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?

[#3]

@Hans Vogelaar 

return to another column, 

[#4 · Accepted solution]

@zcaldwell32 

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.

[#5]

thanks