SOLVED

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

@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?

@Hans Vogelaar 

return to another column, 

 

best response confirmed by Sergei Baklan (MVP)
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.

thanks
1 best response

Accepted Solutions
best response confirmed by Sergei Baklan (MVP)
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.

View solution in original post